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 ?

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

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

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