Hi all,


I've been working with kudu, impala, hive, namenode, datanode  and several
other services in the Hadoop ecosystem for some time and I have tried
recently to create tables in impala and use Amazon S3 as the data store as
mentioned in this page(
https://impala.apache.org/docs/build/html/topics/impala_s3.html) and faced
below mentioned issue while creating table.



*[0.0.0.0:11432 <http://0.0.0.0:11432/>] default> create table
sample_table_on_s3 (id int, val int, ex_filed string,name string, assertion
boolean, city string, country string) stored as parquet location
's3a://impala-data-store-s3/impala-tbl';*

*Query: create table sample_table_on_s3 (id int, val int, ex_filed
string,name string, assertion boolean, city string, country string) stored
as parquet location 's3a://impala-data-store-s3/impala-tbl'*

*ERROR: ImpalaRuntimeException: Error making 'createTable' RPC to Hive
Metastore:*

*CAUSED BY: MetaException: java.lang.RuntimeException:
java.lang.ClassNotFoundException: Class
org.apache.hadoop.fs.s3a.S3AFileSystem not found*



*[0.0.0.0:11432 <http://0.0.0.0:11432/>] default>*

Has anyone else faced this issue?

Software versions:

   - Impala – 3.4.0
   - Hive - 3.1.2
   - Hadoop-3.3.0


Thanks & Regards,
Dinujaya Kaweesha

Reply via email to