hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Avro Format output
Date Thu, 02 Jul 2015 06:01:20 GMT
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 <kjayapal17@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
>

Mime
View raw message