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,
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