CODEWITHSUNDEEP
hadoophiveexternal
user3663615
user3663615

Reputation: 41

External table in hadoop

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?

Upvotes: 0

Views: 86

Answers (1)

x_coder
x_coder

Reputation: 73

EXTERNAL TABLE will point to the location you specified. here it is /data/stocks. check what this command is returning hadoop fs -ls /data/stocks

Upvotes: 1

Related Questions