Create hive table with location

Question

Hi Team,

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

Answer 1

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