set these value before running insert overwrite command (execute in hive console)
*set hive.exec.dynamic.partition=true;set hive.exec.dynamic.partition.mode=nonstrict;* On Fri, May 2, 2014 at 6:18 PM, Kishore kumar <kish...@techdigita.in> wrote: > Hi Experts, > > How to change the non partitioned table into partitioned table in hive. > > I created a table with > > create table table_name1(col1 type, col2 type.......) > row format > fields terminated by '|' > stored as textfile > > loaded data from local with > > load data local inpath "/to/path" (overwrite)into table table_name; > > I am trying to change the above table as a partitioned table by creating > new table > > create table table_name2 like table table_name1 > insert overwrite table table_name2 partition(col1, col2) select col3, > col4, ....col1, col2 from table_name1; > > > the error i am facing is > > OK > FAILED: SemanticException [Error 10098]: Non-Partition column appears in the > partition specification: col1 > > > > Please help me what I am missing. > > -- > > *Kishore Kumar* > ITIM > > -- *Muhammad Hamza Asad*
