I have a partitioned table A in sequence file. Now to want to create a partitioned parquet table B with schema and data same as A.
What I have tried:
create table A like B;
alter table A set fileformat parquet;
insert into table A partition(part) select*from B;
This gives error (surprisingly works for fileformat orc)
SemanticException Line 1:18 Exception while processing 'A': must specify an InputFormat class
Now something like this also does not work.
create table A stored as parquet partitioned by (part) like B;
All my three requirements (parquet, partition, like B) just does not come in same line according to hive.
How to create such a table?