question Loading sequence files to Hive table in Archives of Support Questions (Read Only)

Loading sequence files to Hive table

das_dineshk — Wed, 31 May 2017 16:36:31 GMT

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

Looking for a help

Re: Loading sequence files to Hive table

ssahi — Fri, 02 Jun 2017 05:37:19 GMT

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.

Re: Loading sequence files to Hive table

saha_priyatam — Fri, 02 Jun 2017 15:05:56 GMT

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>;