hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <dean.wamp...@thinkbiganalytics.com>
Subject Re: Generate Hive DDL
Date Fri, 15 Feb 2013 15:21:42 GMT
If you're using Hive v0.10, this implements the new SHOW CREATE TABLE
mytable command.

On Fri, Feb 15, 2013 at 12:07 AM, Anandha L Ranganathan <
analog.sony@gmail.com> wrote:

> 1) download the jar from
>           from Apache JIRA https://issues.apache.org/jira/browse/HIVE-967
>
> 2) run the following command to generate DDLs.
>
>  hive --service jar <<path_to_jar>>
> com.media6.hive2rdbms.job.ShowCreateTable -D db.name=default -D table.name=<<TABLE_NAME>>
> 2>/dev/null
>
>
>
> On Thu, Feb 14, 2013 at 9:41 PM, Murtaza Doctor <murtaza@richrelevance.com
> > wrote:
>
>>  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
>> version control.  We could replicate the entire metastore would we just
>> want 4 tables out of the 100 we already have in place.
>>
>>  Thanks,
>> murtaza
>>
>
>


-- 
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330

Mime
View raw message