Support Questions
Find answers, ask questions, and share your expertise

external table folder creation

external table folder creation

Contributor

CREATE EXTERNAL TABLE IF NOT EXISTS stocks ( exchange STRING, symbol STRING, ymd STRING, price_open FLOAT, price_high FLOAT, price_low FLOAT, price_close FLOAT, volume INT, price_adj_close FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/data/stocks';

I do not see any folder stocks in HDFS.where it will be created?

1 REPLY 1

Re: external table folder creation

Contributor

Since it is external table hive won't create any folder for data storage, in hdfs. It will expect the folder and data to be present with appropriate permission. You can create the folder /data/stocks in hdfs and move data files there