How to change the location of a table in hive

Question

Hi,

I am working on hive and after creating a table its showing the location is default. Can anyone tell me that how to change the table location in hive?

Answer 1

Hey,

Basically When we create a table in hive, it creates in the default location of the hive warehouse. After creating the table you can move the data from hive table to HDFS with the help of this command:

And you can check the table you have created in HDFS with the help of this command:

Answer 2

Changing location requires 2 steps:

1.) Change location in the table properties using the following query
 ALTER TABLE table_name SET LOCATION "location_in_hdfs" (e.g  "hdfs://bighdpope/data/raw/cag/Output")

2.) Copy the file from old_location to new_location using the File Browser.