Re: How to convert files in HIVE

2015-07-16 Thread Ted Yu
Looks like you may get more help from Hive mailing list:

http://hive.apache.org/mailing_lists.html

FYI

On Thu, Jul 16, 2015 at 4:15 PM, Kumar Jayapal  wrote:

> 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
>
>
> Thanks
> Jay
>


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

2015-07-16 Thread Han-Cheol Cho
 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" 
To: ; 
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