Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> how to export create statement for one table


Copy link to this message
-
Re: how to export create statement for one table
See bottom of http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL

On Sat, Sep 18, 2010 at 7:13 PM, lei liu <[EMAIL PROTECTED]> wrote:

> I use below statement to create one table:
>
> CREATE TABLE page_view(viewTime INT, userid BIGINT,
>      page_url STRING, referrer_url STRING,
>      ip STRING COMMENT 'IP Address of the User')
>  COMMENT 'This is the page view table'
>  PARTITIONED BY(dt STRING, country STRING)
>  ROW FORMAT DELIMITED
>    FIELDS TERMINATED BY '\001'
> STORED AS SEQUENCEFILE;
>
>
> Now I want to export the DDL for page_view table, how can I do it ?
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB