-Re: how to export create statement for one table
wd 2010-09-20, 01:50
Maybe you can find the original file to find out it.
2010/9/19 lei liu <[EMAIL PROTECTED]>
> I know the describe statement, the statement don't display the FIELDS
> TERMINATED and LINES TERMINATED, it only display column name and column
> 2010/9/19 Ted Yu <[EMAIL PROTECTED]>
> 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 ?