How to create hive table without location

Question

Hi Guys,

I am new to Hive. I want to create a table in Hive without a location. How can I do that?

Answer 1

Hi@akhtar,

We can create a hive table for sequence file data without a location. And we can load data into that table later. You can use the below command.

$ create table employee_seq(name string,salary int,deptno int,DOJ date)  row format delimited fields terminated by ',' stored as SequenceFile ;