hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kishore kumar <kish...@techdigita.in>
Subject Alter non partitioned table into partitioned table
Date Fri, 02 May 2014 13:18:51 GMT
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

Mime
View raw message