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 >> Hive table creation over a Hadoop Sequence File


Copy link to this message
-
Re: Hive table creation over a Hadoop Sequence File
This means the data key is null and data is (delimited) text. This would
not work for generic sequencefiles.

Thanks,
Aniket

On Thu, Mar 1, 2012 at 4:39 AM, Bejoy Ks <[EMAIL PROTECTED]> wrote:

> Hi Madhu
>       You can definitely do the same. Specify the SEQUENCE FILE in 'STORED
> AS' clause in your DDL.
>
> An example from hive wiki
>
> 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)
>  CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
>  ROW FORMAT DELIMITED
>    FIELDS TERMINATED BY '\001'
>    COLLECTION ITEMS TERMINATED BY '\002'
>    MAP KEYS TERMINATED BY '\003'
>  STORED AS SEQUENCEFILE;
>
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable
>
>
> Regards
> Bejoy.K.S
>
>   ------------------------------
> *From:* madhu phatak <[EMAIL PROTECTED]>
> *To:* [EMAIL PROTECTED]
> *Sent:* Thursday, March 1, 2012 4:19 PM
> *Subject:* Hive table creation over a Hadoop Sequence File
>
> Hi Group,
>  Can we create a Hive table over a Sequence File of Hadoop for querying?
> If its possible can you point to me any documentation for that?
>
> --
> Join me at http://hadoopworkshop.eventbrite.com/
>
>
>
--
"...:::Aniket:::... Quetzalco@tl"
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