Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Who agreed with this solution

avatar
Contributor

The ROW FORMAT clause only applies to tables using the text format.  STORED AS PARQUET means the table expects the data to already be in Parquet format. You will need to make 2 tables.  One table with no STORED AS clause but with ROW FORMAT DELIMITED etc.  You will be able to query this table after you move the delimited data files into the table directory and REFRESH the table).  Then another (empty) table with the same columns and a STORED AS PARQUET clause.  Then to convert the data to Parquet, you do:

 

insert into parquet_table select * from text_table;

 

John

View solution in original post

Who agreed with this solution