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 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 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 ? >> >> >
