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
