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 Kumar Jayapal <kj...@gmail.com> on 2015/07/17 01:15:22 UTC
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
Thanks
Jay
Re: How to convert files in HIVE
Posted by Ted Yu <yu...@gmail.com>.
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 <kj...@gmail.com> 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
Posted by Han-Cheol Cho <ha...@nhn-playart.com>.
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"<kjayapal17@gmail.com>
To: <user@hadoop.apache.org>;
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
Re: How to convert files in HIVE
Posted by Ted Yu <yu...@gmail.com>.
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 <kj...@gmail.com> 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
Posted by Han-Cheol Cho <ha...@nhn-playart.com>.
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"<kjayapal17@gmail.com>
To: <user@hadoop.apache.org>;
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
Re: How to convert files in HIVE
Posted by Ted Yu <yu...@gmail.com>.
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 <kj...@gmail.com> 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
Posted by Han-Cheol Cho <ha...@nhn-playart.com>.
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"<kjayapal17@gmail.com>
To: <user@hadoop.apache.org>;
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
What about Create Table As Select (CTAS)? RE: How to convert files in HIVE
Posted by Han-Cheol Cho <ha...@nhn-playart.com>.
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"<kjayapal17@gmail.com>
To: <user@hadoop.apache.org>;
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
Re: How to convert files in HIVE
Posted by Ted Yu <yu...@gmail.com>.
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 <kj...@gmail.com> 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
>