Re: Query using dynamic partitions

2011-09-17 Thread Sumanth V
Hi Adriaan, To use dynamic partition, follow the following steps inside hive shell - #Set the following values - set hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.dynamic.partition=true #Create another table - create table raw_2 ( data string ) partitioned by (partition1 string,

Query using dynamic partitions

2011-09-17 Thread Adriaan Tijsseling
Hi, I have a table created with CREATE TABLE raw(partition1 string, partition2 string, data string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE; I want to further process "data" and put it in a partition (partition1, partition2) defined by the values in the relevant row