Created on
10-09-2019
03:19 AM
- last edited on
10-09-2019
05:57 AM
by
ask_bill_brooks
After opening kerberos, impala can't access kudu table。
CDH6.0.0
[ghqbigdata3:21000] dm_odata_phq> select * from total_record limit 10;
Query: select * from total_record limit 10
Query submitted at: 2019-10-09 09:52:58 (Coordinator: http://ghqbigdata3:25000)
ERROR: AnalysisException: Failed to load metadata for table: 'total_record'
CAUSED BY: TableLoadingException: Error loading metadata for Kudu table impala::dm_odata_phq.total_record
CAUSED BY: ImpalaRuntimeException: Error opening Kudu table 'impala::dm_odata_phq.total_record', Kudu error: cannot re-acquire authentication token after 5 attempts
I1009 17:17:20.229892 48700 Frontend.java:935] Analyzing query: select * from cust_info limit 10
I1009 17:17:20.334491 48700 jni-util.cc:230] org.apache.impala.common.AnalysisException: Failed to load metadata for table: 'cust_info'
at org.apache.impala.analysis.Analyzer.resolveTableRef(Analyzer.java:581)
at org.apache.impala.analysis.FromClause.analyze(FromClause.java:59)
at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:155)
at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:424)
at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:393)
at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:946)
at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:156)
Caused by: org.apache.impala.catalog.TableLoadingException: Error loading metadata for Kudu table impala::dm_odata_phq.cust_info
CAUSED BY: ImpalaRuntimeException: Error opening Kudu table 'impala::dm_odata_phq.cust_info', Kudu error: cannot re-acquire authentication token after 5 attempts
at org.apache.impala.catalog.IncompleteTable.loadFromThrift(IncompleteTable.java:113)
at org.apache.impala.catalog.Table.fromThrift(Table.java:311)
at org.apache.impala.catalog.ImpaladCatalog.addTable(ImpaladCatalog.java:405)
at org.apache.impala.catalog.ImpaladCatalog.addCatalogObject(ImpaladCatalog.java:294)
at org.apache.impala.catalog.ImpaladCatalog.updateCatalog(ImpaladCatalog.java:201)
at org.apache.impala.service.Frontend.updateCatalogCache(Frontend.java:228)
at org.apache.impala.service.JniFrontend.updateCatalogCache(JniFrontend.java:175)
at ========.<Remote stack trace on catalogd>: org.apache.impala.catalog.TableLoadingException: Error loading metadata for Kudu table impala::dm_odata_phq.cust_info
at org.apache.impala.catalog.KuduTable.load(KuduTable.java:233)
at org.apache.impala.catalog.TableLoader.load(TableLoader.java:80)
at org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:241)
at org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:238)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.impala.common.ImpalaRuntimeException: Error opening Kudu table 'impala::dm_odata_phq.cust_info', Kudu error: cannot re-acquire authentication token after 5 attempts
at org.apache.impala.catalog.KuduTable.loadSchemaFromKudu(KuduTable.java:200)
at org.apache.impala.catalog.KuduTable.load(KuduTable.java:230)
... 7 more
()
I1009 17:17:20.381866 48700 status.cc:125] AnalysisException: Failed to load metadata for table: 'cust_info'
CAUSED BY: TableLoadingException: Error loading metadata for Kudu table impala::dm_odata_phq.cust_info
CAUSED BY: ImpalaRuntimeException: Error opening Kudu table 'impala::dm_odata_phq.cust_info', Kudu error: cannot re-acquire authentication token after 5 attempts
@ 0x9da88a impala::Status::Status()
@ 0xe7e51d impala::JniUtil::GetJniExceptionMsg()
@ 0xd96ce0 impala::Frontend::GetExecRequest()
@ 0xdb4e74 impala::ImpalaServer::ExecuteInternal()
@ 0xdc085f impala::ImpalaServer::Execute()
@ 0xdf84d5 impala::ImpalaServer::query()
@ 0x126e6d5 beeswax::BeeswaxServiceProcessor::process_query()
@ 0x126db8d beeswax::BeeswaxServiceProcessor::dispatchCall()
@ 0x9b869a apache::thrift::TDispatchProcessor::process()
@ 0xcee239 apache::thrift::server::TAcceptQueueServer::Task::run()
@ 0xce82b9 impala::ThriftThread::RunRunnable()
@ 0xce9132 boost::detail::function::void_function_obj_invoker0<>::invoke()
@ 0xeeefcf impala::Thread::SuperviseThread()
@ 0xeefad3 boost::detail::thread_data<>::run()
@ 0x14a500a thread_proxy
@ 0x7f984dac6e25 start_thread
@ 0x7f984d7f434d __clone
I1009 17:17:20.381980 48700 impala-server.cc:1007] UnregisterQuery(): query_id=4741df2a3472748f:82f4fb300000000
I1009 17:17:20.381997 48700 impala-server.cc:1094] Cancel(): query_id=4741df2a3472748f:82f4fb300000000
Created 10-09-2019 04:15 AM
Hi
Can you try restarting Impala service and regenerate Kerberos ticket and try to access tables. Check if that helps.
https://cloudera-portal.force.com/articles/KB_Article/TSB-2018-297
Regards,
Bhuvan