Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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 ?
>>>
>>>
>>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB