Problems with tHiveInput

Anonymous — Sat, 16 Nov 2024 11:14:47 GMT

Hi.
I have a little problem:
In properties of tHiveInput i can try "Guess schema". From documentation i know that this schout give db schema of hive database.
But i don't works. After pressing "Guess schema" Talend open studio hangs. It can be only killed via Widows Task Manager. In hiveserver2 log i see this error:

2015-04-20 11:26:29,163 ERROR org.apache.thrift.server.TThreadPoolServer: Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Invalid status -128
    at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:227)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: Invalid status -128
    at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:230)
    at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
    at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125)
    at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:262)
    at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
    at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
    ... 4 more
2015-04-20 11:27:59,677 WARN org.apache.hive.service.cli.thrift.ThriftCLIService: Error getting schemas: 
org.apache.hive.service.cli.HiveSQLException: Invalid SessionHandle: SessionHandle 
    at org.apache.hive.service.cli.session.SessionManager.getSession(SessionManager.java:222)
    at org.apache.hive.service.cli.CLIService.getSchemas(CLIService.java:280)
    at org.apache.hive.service.cli.thrift.ThriftCLIService.GetSchemas(ThriftCLIService.java:422)
    at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetSchemas.getResult(TCLIService.java:1433)
    at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetSchemas.getResult(TCLIService.java:1418)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)

This happens with both db's in hive. Test(bigint id, string text) and tweets(db like here github.com/cloudera/cdh-twitter-example).
How can i fix this.

Re: Problems with tHiveInput

Anonymous — Tue, 21 Apr 2015 09:24:53 GMT

Hi,
What's your query in tHiveInput? Could you please show us tHiveInput component setting screenshot?
Best regards
Sabrina

Re: Problems with tHiveInput

Anonymous — Wed, 22 Apr 2015 15:20:32 GMT

Hi. Here is it:

When i press Guess schema Openstudio hangs and i get in hiveserver2 log error.

topic Re: Problems with tHiveInput in Talend Studio

Problems with tHiveInput

Re: Problems with tHiveInput

Re: Problems with tHiveInput