Hello, I am new to impala,
In impala, I am able to create the table but when I try to select the rows from the table it failed with "failed to load metadata for table : tab201". I tried the following, Please guide me. I tried the following: [ip-172-30-1-57.ec2.internal:21000] > create EXTERNAL TABLE tab201 ( id INT, col_1 BOOLEAN, col_2 DOUBLE, col_3 TIMESTAMP ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/impala/sample_data/tab1'; Query: create EXTERNAL TABLE tab201 ( id INT, col_1 BOOLEAN, col_2 DOUBLE, col_3 TIMESTAMP ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/impala/sample_data/tab1' Fetched 0 row(s) in 0.77s [ip-172-30-1-57.ec2.internal:21000] > show tables; Query: show tables +--------+ | name | +--------+ | tab1 | | tab101 | | tab11 | | tab2 | | tab201 | | tab3 | | tab31 | +--------+ Fetched 7 row(s) in 0.01s [ip-172-30-1-57.ec2.internal:21000] > select * from tab201; Query: select * from tab201 ERROR: AnalysisException: Failed to load metadata for table: 'tab201' CAUSED BY: TableLoadingException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: ExecutionException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil [ip-172-30-1-57.ec2.internal:21000] > invalidate metadata tab201; Query: invalidate metadata tab201 Fetched 0 row(s) in 0.06s [ip-172-30-1-57.ec2.internal:21000] > select * from tab201; Query: select * from tab201 ERROR: AnalysisException: Failed to load metadata for table: 'tab201' CAUSED BY: TableLoadingException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: ExecutionException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil [ip-172-30-1-57.ec2.internal:21000] > [ip-172-30-1-57.ec2.internal:21000] > alter table tab201 set fileformat PARQUET; Query: alter table tab201 set fileformat PARQUET ERROR: AnalysisException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: ExecutionException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: TableLoadingException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: ExecutionException: java.lang.NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil CAUSED BY: NoClassDefFoundError: Could not initialize class com.cloudera.impala.util.HdfsCachingUtil [ip-172-30-1-57.ec2.internal:21000] > -- Regards, Karthikeyan Nagalingam TME (Big Data Analytics) Mobile: 919-376-6422
