Home | About | Sematext search-lucene.com search-hadoop.com
 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
Ted Yu 2010-09-19, 03:31
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 ?
>
>