티스토리 뷰

공부

[hive] table get `location`

승가비 2023. 1. 24. 06:33
728x90
SHOW CREATE TABLE db.table AS SERDE; -- LOCATION ... (only external table)
DESCRIBE FORMATTED db.table; -- Location

https://stackoverflow.com/questions/68562219/error-in-performing-show-create-table-opencsv-serde-hive-table-in-databricks

 

Error in performing 'show create table' OpenCSV Serde Hive Table in Databricks

I have created a table with OpenCSV Serde in Databricks below DDL :- CREATE TABLE db_name.table_name( col1 String, col2 String) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'...

stackoverflow.com

https://stackoverflow.com/questions/13178182/i-have-created-a-table-in-hive-i-would-like-to-know-which-directory-my-table-is

 

I have created a table in hive, I would like to know which directory my table is created in?

I have created a table in hive, I would like to know which directory my table is created in? I would like to know the path...

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[hive] 대체제 (hudi, iceberg, delta lake) -> iceberg  (0) 2023.01.28
[git] branch remove all exclude (main | master | release)  (0) 2023.01.24
[s3] delete (object & version)  (0) 2023.01.24
[mongoose] MongooseServerSelectionError: connect ECONNREFUSED ::1:27017  (0) 2023.01.24
[js] node & npm & yarn  (0) 2023.01.24
댓글