Create hive table with location

0 votes

Hi Team,

I have configured hive. I want to create a Hive table with a location. How can I do that?

Oct 15, 2020 in Big Data Hadoop by MD
• 95,180 points
56 views

1 answer to this question.

0 votes

Hi@MD,

We can also create a hive table for sequence file data with location. The specified location should have sequence file format data.

create table employee_seq(name string,salary int,deptno int,DOJ date)  row format delimited fields terminated by ',' 
stored as SequenceFile location '/data/in/employee_seq' ;
answered Oct 15, 2020 by akhtar
• 38,170 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Hive: LOCATION and WITH DBPROPERTIES command in create table command

By default, the Hive database will be ...READ MORE

answered May 22, 2019 in Big Data Hadoop by Firoz
1,579 views
+2 votes
2 answers

Create HIVE Table with multi character delimiter

FILELDS TERMINATED BY does not support multi-character delimiters. ...READ MORE

answered Oct 3, 2018 in Big Data Hadoop by slayer
• 29,300 points
8,162 views
0 votes
1 answer

How to create a Hive table with a sequence file?

In Hive we can create a sequence ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 69,130 points
2,075 views
–1 vote
1 answer

Create Hive table with bucketing and ORC file format

create table hive_dml (emp_id int, first_name string, last_name ...READ MORE

answered Jan 4, 2019 in Big Data Hadoop by Omkar
• 69,130 points
1,687 views
0 votes
1 answer

What is the command to find the free space in HDFS?

You can use dfsadmin which runs a ...READ MORE

answered Apr 29, 2018 in Big Data Hadoop by Shubham
• 13,480 points
850 views
0 votes
1 answer

How to find the used cache in HDFS

hdfs dfsadmin -report This command tells fs ...READ MORE

answered May 4, 2018 in Big Data Hadoop by Shubham
• 13,480 points
940 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
• 11,380 points
7,244 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
• 11,380 points
1,176 views
0 votes
2 answers

How to know Hive and Hadoop versions from command prompt?

Hi, Hadoop and hive have their individual commands. ...READ MORE

answered Dec 18, 2020 in Big Data Hadoop by akhtar
• 38,170 points
216 views
0 votes
2 answers

How to delete and update a record in Hive?

Hi, Earlier, there was no operation supported for ...READ MORE

answered Dec 18, 2020 in Big Data Hadoop by akhtar
• 38,170 points
206 views