i have created table after enabling dynamic partition. i partitioned it on date but it is not splitting data datewise. Below is the query of table created and data insert CREATE TABLE rc_partition_cluster_table( id int, event_id int, user_id BIGINT, event_date string, intval_1 int ) CLUSTERED BY(id) INTO 256 BUCKETS ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS RCFile;
set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.max.dynamic.partitions=1000; set hive.exec.max.dynamic.partitions.pernode=1000; INSERT OVERWRITE TABLE rc_partition_cluster_table Partition (event_date) SELECT * FROM events_details; why it is not working fine? -- *Muhammad Hamza Asad*