Re: how to export create statement for one table

I know the describe statement, the statement don't display the FIELDS TERMINATED and LINES TERMINATED, it only display column name and column type. 2010/9/19 Ted Yu yuzhih...@gmail.com See bottom of http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL On Sat, Sep 18, 2010 at 7:13 PM, lei

Re: how to export create statement for one table

Maybe you can find the original file to find out it. 2010/9/19 lei liu liulei...@gmail.com I know the describe statement, the statement don't display the FIELDS TERMINATED and LINES TERMINATED, it only display column name and column type. 2010/9/19 Ted Yu yuzhih...@gmail.com See bottom of

how to export create statement for one table

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

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 liulei...@gmail.com 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