amazon s3 - Created table in Impala using S3 location but unable to get data into table -


i have created table impala using s3 location along partition, no data populating while querying. how can overcome this?

create table t(id int, name string) partitioned (year int) stored avaro location 's3a://impala-/dir1/'; 

it looks want use external table:

by default, impala creates "internal" table, impala manages underlying data files table, , physically deletes data files when drop table. if specify external clause, impala treats table "external" table, data files typically produced outside impala , queried original locations in hdfs, , impala leaves data files in place when drop table.

therefore, try this:

create external table t(id int, name string) partitioned (year int) stored avro location 's3a://impala-/dir1/'; 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -