공부

[Hive] ALTER TABLE table_name SET LOCATION "hdfs://mycluster:8020/jsam/j1";

승가비 2020. 11. 23. 03:52
728x90

https://community.cloudera.com/t5/Support-Questions/How-to-change-location-of-the-external-table-in-hive/td-p/134391

 

How to change location of the external table in hive .

1) CREATE EXTERNAL TABLE IF NOT EXISTS jsont1( json string ) LOCATION '/jsam'; Now I need to change the location from where above json1 points to. I tried this command - ALTER TABLE jsont1 SET LOCATION "/jsam/j2" ; but getting error as below : FAILED: Exec

community.cloudera.com

 

728x90
저작자표시 비영리 (새창열림)