Hey there, Try posting to u...@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 <kjayapa...@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 >
