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 Abraham Elmahrek <ab...@cloudera.com> on 2015/07/02 08:01:20 UTC

Re: Avro Format output

Hey there,

Try posting to user@hive.apache.org.

To answer your question... AFAIK you can do this with hive, but as a CTAS
operation:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS)
.

On Mon, Jun 29, 2015 at 8:01 PM, Kumar Jayapal <kj...@gmail.com> wrote:

> Hello,
>
> I have a situation here. I have loaded CSV files into hive database in
> a PARQUET FORMAT.  I am want to move this data into a directory in AVRO
> format is it possible to do that. I tried with this potion but  not
> successed. Can some one please help.
>
> insert overwrite directory '/tmp/blo' ROW FORMAT DELIMITED FIELDS
> TERMINATED BY ','  STORED AS AVRO select dwhse, dsdat, dreg_num, drn_num,
> dscnr, dareq, datak, dmsgc from blok where fiscal_year=2008 and
> fiscal_period=01 limit 10;
>
>
>
>
> Thanks
> Jay
>