hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Haviv <>
Subject Re: Simple way to export data from a Hive table in to Avro?
Date Mon, 02 Feb 2015 13:17:04 GMT
I might be missing something here but you could use:
Create table newtable stored as avro as select * from oldtable

On Mon, Feb 2, 2015 at 3:09 PM, Michael Segel <>

> Currently using Hive 13.x
> Would like to select from a table that exists and output to an external
> file(s) in avro via hive.
> Is there a simple way to do this?
> From what I’ve seen online, the docs tend to imply you need to know the
> avro schema when you specify the table.
> Could you copy from an existing table, or do I need to dump the current
> schema and write some code to generate an avro schema?
> Thx
> -Mike

View raw message