Loading sequence files to Hive table

[#1]

How Can I load a sequence file to an external table.

Looking for a help

[#2 · Accepted solution]

Hi @Dinesh Das

You can do a CREATE EXTERNAL table as normal, but add the storage qualifier to it. For example:

create external table countries_ext_seq

LIKE countries_seq

STORED AS SEQUENCEFILE

LOCATION '/tmp/seqTest'

In the above example, I already have an existing hive table with the same columns and datatypes, so I use the lazy method by using the LIKE clause, but you can do the same with a full definition. I'm able to create this external table, point it to an existing sequence file stored in HDFS, and query with no problem.

As always, if you find this post useful, please "Accept" the answer.

[#3]

You need to create external table then load data either from local or from HDFS.

CREATE EXTERNAL TABLE <table_name> (column1 <datatype>,column2 <datatype>,column3 <datatype>,...) ROW FORMAT DELIMITED STORED AS SEQUENCEFILE LOCATION '<location_path>';
Now Load data :

LOAD DATA INPATH '<HDFS PATH>' INTO <table_name>;