When we create a table, HIVE takes care to manage data in the table. By default, it moves the data to its warehouse directory(/user/warehouse/hive/).
Steps 1:
hive> create table managed_table(name string,rollno int,dept string)
> row format delimited
> fields terminated by ',';
Step 2: Load data in the table.
hive> load data local inpath '/home/arani/Desktop/student.csv' into table managed_table;
Step 3: You can check your managede_table.
hive> select * from managed_table;
In this table, you might have noticed that data is being moved to the table.