Hi, 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? -- - Prash
