hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hamza Asad <hamza.asa...@gmail.com>
Subject dynamic Partition not splitting properly
Date Wed, 12 Jun 2013 13:47:52 GMT
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*

Mime
View raw message