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