CODEWITHSUNDEEP
hive
Chaitra Bannihatti
Chaitra Bannihatti

Reputation: 211

In Qubole, creation of hive external table using S3 location

I am creating an external table in hive in QUBOLE. But there is no data after the table creation. Here is my DDL statement for creation. use vlc;

CREATE EXTERNAL TABLE dim_retailer_txt2( RETAILER_TENANT_ID int, RETAILER_NAME string, ACTIVE tinyint) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' ESCAPED BY '\' STORED AS TEXTFILE LOCATION 's3://manthan-impala-test/vi65test-txt/dim_retailer_vlc/';

Later if i check that data, there is not data

Upvotes: 0

Views: 462

Answers (1)

Chaitra Bannihatti
Chaitra Bannihatti

Reputation: 211

I was using S3 browser to dump data in the S3 location.When i did this in my case , some extra file which is of 1 byte size was also getting dumped to my S3 location. So while creating an table it was not able to fetch the exact data from the S3 location.

Upvotes: 0

Related Questions