You are viewing a plain text version of this content. The canonical link for it is here.

Posted to mapreduce-user@hadoop.apache.org by Han-Cheol Cho <ha...@nhn-playart.com> on 2015/07/17 03:40:51 UTC

What about Create Table As Select (CTAS)? RE: How to convert files in HIVE

 Hi,
 
In a simple way, you can create a table in avro format and insert all data from the old table into the new one.
Please check the "Create Table As Select" section in the following hive documentation.
    https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS) 
 
Best wishes,
 
-----Original Message-----
From: "Kumar Jayapal"&lt;kjayapal17@gmail.com&gt; 
To: &lt;user@hadoop.apache.org&gt;; 
Cc: 
Sent: 2015-07-17 (금) 08:15:22
Subject: How to convert files in HIVE
 
Hi, How can we convert files stored in snappy compressed parquet format in Hive to avro format. is it possible to do it. Can you please guide me or give me the link which describe the procdure  ThanksJay