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 <phatak....@gmail.com> To: user@hive.apache.org 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/
