Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - how to export create statement for one table


Copy link to this message
-
Re: how to export create statement for one table
wd 2010-09-20, 01:50
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 ?
>>>
>>>
>>
>