Create a Hive table with a sequence file

0 votes

Hi!

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

Thanks

Dec 20, 2018 in Apache Kafka by nguyenthaonhi
• 120 points

reshown Apr 10, 2019 by Vardhan 98 views
Hey there! Do you want to load the data from hdfs or from local file system?

1 answer to this question.

+1 vote

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​

answered Dec 26, 2018 by Omkar
• 68,860 points

Related Questions In Apache Kafka

+1 vote
10 answers

Writing the Kafka consumer output to a file

System.out.println(String.valueOf(output.offset()) + ": " + new String(bytes, ...READ MORE

answered Dec 7, 2018 in Apache Kafka by Harsh
9,352 views
0 votes
1 answer

Is there any change in consumer offsets if a new partition(s) is added to a Kafka topic?

Yes, it stays the same. An offset is ...READ MORE

answered Jul 9, 2018 in Apache Kafka by nitinrawat895
• 10,840 points
423 views
+1 vote
12 answers

How can I delete all the messages from a Kafka topic?

As of kafka 2.3.0 version, there is ...READ MORE

answered Sep 8, 2019 in Apache Kafka by Brajkishore
• 240 points
56,394 views
0 votes
1 answer

What is the optimum number of producers to create in Kafka?

In general, a single producer for all ...READ MORE

answered Jul 10, 2018 in Apache Kafka by nitinrawat895
• 10,840 points
1,804 views
0 votes
1 answer

How to delete a topic in Kafka 0.8.1.1?

Deleting topic isn't always working in 0.8.1.1 Deletion ...READ MORE

answered Sep 4, 2018 in Apache Kafka by nitinrawat895
• 10,840 points
289 views
0 votes
1 answer

How to write Kafka connector to integrate with Facebook API?

If you know the limit of API ...READ MORE

answered Apr 29, 2019 in Apache Kafka by Kumar
419 views
0 votes
1 answer

What is Metastore in Hive?

It stores metadata for Hive tables (like their schema ...READ MORE

answered Dec 20, 2018 in Big Data Hadoop by Frankie
• 9,810 points
290 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,840 points
3,915 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,840 points
539 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
20,820 views