Create a Hive table with a sequence file

Question

Hi!

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

Thanks

Comments

Hey there! Do you want to load the data from hdfs or from local file system?

Answer 1

Hey! Follow these steps to create a Hive table with a sequence file:

First, create sequence file using the following command syntax:

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

Then create hive table:

INSERT OVERWRITE TABLE sequenceTab 
SELECT * FROM emp;

If you want to use the sequence file from hdfs, you can follow the steps mentioned here:

https://www.edureka.co/community/33443/how-to-create-a-hive-table-from-sequence-file-stored-in-hdfs?show=33443#q33443​