hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lei liu <liulei...@gmail.com>
Subject Re: how to export create statement for one table
Date Sun, 19 Sep 2010 07:57:18 GMT
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 <yuzhihong@gmail.com>

> See bottom of http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL
>
>
> On Sat, Sep 18, 2010 at 7:13 PM, lei liu <liulei412@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 ?
>>
>>
>

Mime
View raw message