Avro Backed Hive tables

2013-03-06 Thread Murtaza Doctor
Folks, Wanted to get some help or feedback from the community on this one: We are trying to create a table backed by avro schema: Hive Version: 0.10 This is the syntax we are using to create the table. As you can notice the avro schema is defined inline. Question:- If you look at the avro sche

Re: Generate Hive DDL

2013-02-15 Thread Murtaza Doctor
ShowCreateTable -D db.name<http://db.name>=default -D table.name<http://table.name>=<> 2>/dev/null On Thu, Feb 14, 2013 at 9:41 PM, Murtaza Doctor mailto:murt...@richrelevance.com>> wrote: Folks, I was wondering if any one is aware of a way to generate Hive DDL s

Generate Hive DDL

2013-02-14 Thread Murtaza Doctor
Folks, I was wondering if any one is aware of a way to generate Hive DDL scripts using the existing metastore which in our case is in postgres. We have a few tables which have been historically created and figuring our creating ways to get the schema as DDL so that we can keep it in under versi