How to create a managed table in Hive

Question

I want to create a managed or internal table in Hive. Tablename should be employee and the fields should be name and salary. What command should I use to do this?

Answer 1

You can use this command:

create table employee(Name String, Sal Int) row format delimited fields terminated by ',';