Unabion le to create a table Not sure what location to use. It gives an error. Was trying to Use S3 which was used in an existing file. Please help

Lab Support
#1

CREATE EXTERNAL TABLE airlines_analysis.airline(
Year int,
Month int,
DayofMonth int,
DayOfWeek int,
DepTime int,
CRSDepTime int,
ArrTime int,
CRSArrTime int,
UniqueCarrier string,
FlightNum int,
TailNum int,
ActualElapsedTime int,
CRSElapsedTime int,
AirTime int,
ArrDelay int,
DepDelay int,
Origin string,
Dest string,
Distance int,
TaxiIn int,
TaxiOut int,
Cancelled int,
CancellationCode string,
Diverted int,
CarrierDelay int,
WeatherDelay int,
NASDelay int,
SecurityDelay int,
LateAircraftDelay int
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’
LOCATION ‘s3://airlinedatafortest/airlines_testing/’
tblproperties (“skip.header.line.count”=“1”);

#2

Hi @Gopal_Narasimha,

Can you please let us know what error you are getting?

I think you will have to add appropriate JARs to use S3 as a location.

If your file is in HDFS, you can create an external table with HDFS path. Please check this question for the sample location

Hope this helps.

Thanks