Top "Hive-partitions" questions

How do I drop all partitions at once in hive?

Hive version 1.1 I have a hive external table as below: CREATE EXTERNAL TABLE `schedule_events`( `schedule_id` string COMMENT 'from …

hive hive-partitions

How to create table in partition data in hive?

drwxr-xr-x - mgupta supergroup 0 2018-03-26 22:16 /kylin/retailer/qi_basket_brand_bucket_fact/_impala_insert_staging drwxr-xr-x - mgupta supergroup 0 2018…

hive create-table hive-partitions

External Hive Table Refresh table vs MSCK Repair

I have external hive table stored as Parquet, partitioned on a column say as_of_dt and data gets inserted …

apache-spark hive hivecontext hive-partitions

how to add columns to existing hive partitioned table?

alter table abc add columns (stats1 map<string,string>, stats2 map<string,string>) i have altered …

hive partitioning hive-partitions hiveddl

Does DROP PARTITION delete data from external table in HIVE?

An external table in HIVE is partitioned on year, month and day. So does the following query delete data from …

hive external-tables hive-partitions hiveddl

How to truncate a partitioned external table in hive?

I'm planning to truncate the hive external table which has one partition. So, I have used the following command to …

hive external-tables hive-partitions hiveddl