Member since 
    
	
		
		
		10-09-2019
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                4
            
            
                Posts
            
        
                0
            
            
                Kudos Received
            
        
                0
            
            
                Solutions
            
        
			
    
	
		
		
		10-12-2019
	
		
		02:33 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Cannot create kudu table after granting database permission 
 How to solve this problem? 
 VERSION:  impala version 3.0.0,kudu version 1.6.0  CDH 6.0.0 
 Cannot create kudu table after granting database permission。 
 [bigdata5:21000] yydp_kudu> show grant role yydp;  Query: show grant role yydp  +----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+  | scope | database | table | column | uri | privilege | grant_option | create_time |  +----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+  | database | yydp_kudu | | | | all | false | Sat, Oct 12 2019 15:45:19.073 |  +----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+  Fetched 1 row(s) in 0.02s  [bigdata5:21000] yydp_kudu> 
 Cannot create kudu table:  [bigdata5:21000] yydp_kudu> CREATE TABLE test_kd4 (  > id INT,  > bk_date STRING,  > PRIMARY KEY (id)  > ) STORED AS kudu TBLPROPERTIES (  > 'kudu.master_addresses' = 'bigdata1,bigdata2'  > );  Query: CREATE TABLE test_kd4 (  id INT,  bk_date STRING,  PRIMARY KEY (id)  ) STORED AS kudu TBLPROPERTIES (  'kudu.master_addresses' = 'bigdata1,bigdata2'  )  ERROR: AuthorizationException: User 'yydp/bigdata5@TEST.COM' does not have privileges to access: server1 
   Ability to create non-kudu tables properly 
 [bigdata5:21000] yydp_kudu> CREATE TABLE test_kd5 (  > id INT,  > bk_date STRING);  Query: CREATE TABLE test_kd5 (  id INT,  bk_date STRING)  +-------------------------+  | summary |  +-------------------------+  | Table has been created. |  +-------------------------+  Fetched 1 row(s) in 0.11s 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Impala
 - 
						
							
		
			Apache Kudu
 - 
						
							
		
			Apache Sentry
 
			
    
	
		
		
		10-09-2019
	
		
		03:19 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 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 
   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Impala
 - 
						
							
		
			Apache Kudu