You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@impala.apache.org by "Nagalingam, Karthikeyan" <KA...@netapp.com> on 2016/04/01 15:28:39 UTC
failed to load metadata for table : xxx

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