The Hive documentation describes keyword "external" as following:
The EXTERNAL keyword lets you create a table and provide a LOCATION so that
Hive does not use a default location for this table. This comes in handy if
you already have data generated.
I have my data available in a directory in a bucket in s3. I am trying to
create a table like
CREATE EXTERNAL TABLE IF NOT EXISTS mslog ( TIME_STAMP STRING, SEQ
STRING) LOCATION 's3:// <bucket name>/processed/'
But the table isnt' populated with the data available at the s3 location. Am
i missing something here?