How to create a Hive table with a sequence file

Question

Hello. I want to create a Hive table with a sequence file. Can someone tell me the steps to do this?

Comments

I think by using location keyword it will add the file automatically keep in mind that we have to store the table as sequence file format.

Answer 1

In Hive we can create a sequence file format as follows:

create table table_name (schema of the table) 
row format delimited 
fields terminated by '<delimiter>' 
stored as SEQUENCEFILE

INSERT OVERWRITE TABLE sequenceTab
SELECT * FROM emp;