Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Tableau - Impala - Malformed THandleIdentifier error

Tableau - Impala - Malformed THandleIdentifier error

New Contributor

Hi There,

 

One of my user has been facing an issue whicle refreshing a tableau extract from Tableau server.

The query will produce around 10M row when executed. The same query runs from Tableau Desktop but unable to run it from the Tableau Server.

On Tableau backgrounder logs we have below entry

scheduled-background-job-runner-1 : ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: RefreshExtracts
java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.DataSourceException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [HY000] : Malformed THandleIdentifier (guid size: 0, expected 16, secret size: 0, expected 16)

at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob_aroundBody2(BackgroundJobRunner.java:319)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure3.run(BackgroundJobRunner.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob(BackgroundJobRunner.java:248)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs_aroundBody0(BackgroundJobRunner.java:236)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure1.run(BackgroundJobRunner.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs(BackgroundJobRunner.java:213)
at com.tableausoftware.backgrounder.config.BackgroundJobRunnerSchedulingConfig.lambda$scheduleTask$0(BackgroundJobRunnerSchedulingConfig.java:42)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
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: com.tableausoftware.nativeapi.dll.DataSourceException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [HY000] : Malformed THandleIdentifier (guid size: 0, expected 16, secret size: 0, expected 16)

 

At the same time in Cloudera Manager impala query failed with "session closed" error.
Impala log has below entries. 
impala.log.INFO.20190528.773315:I0529 00:02:11.016881 773875 admission-controller.cc:510] Schedule for id=eb48d3ce4b6fbe21:d2b22c7c00000000 in
.impala.log.INFO.20190528.773315:I0529 00:02:11.016963 773875 admission-controller.cc:531] Admitted query id=eb48d3ce4b6fbe21:d2b22c7c00000000
.impala.log.INFO.20190528.773315:I0529 00:02:11.018854 773875 coordinator.cc:117] Exec() query_id=eb48d3ce4b6fbe21:d2b22c7c00000000 stmt=SELECT
.impala.log.INFO.20190528.773315:I0529 00:02:11.033738 773875 coordinator.cc:369] starting execution on 22 backends for query eb48d3ce4b6fbe21:d2b22c7c00000000
.impala.log.INFO.20190528.773315:I0529 00:02:11.262265 952495 impala-internal-service.cc:44] ExecQueryFInstances(): query_id=eb48d3ce4b6fbe21:d2b22c7c00000000
.impala.log.INFO.20190528.773315:I0529 00:02:11.263146 952495 query-exec-mgr.cc:46] StartQueryFInstances() query_id=eb48d3ce4b6fbe21:d2b22c7c00000000 coord=.:22000
.impala.log.INFO.20190528.773315:I0529 00:02:11.263162 952495 query-state.cc:164] Buffer pool limit for eb48d3ce4b6fbe21:d2b22c7c00000000: 109951162777
.impala.log.INFO.20190528.773315:I0529 00:02:11.263233 952495 initial-reservations.cc:60] Successfully claimed initial reservations (1.10 GB) for query eb48d3ce4b6fbe21:d2b22c7c00000000
.impala.log.INFO.20190528.773315:I0529 00:02:11.264153 1938666 query-state.cc:278] StartFInstances(): query_id=eb48d3ce4b6fbe21:d2b22c7c00000000 #instances=105
.impala.log.INFO.20190528.773315:I0529 00:02:11.284452 1938666 query-state.cc:291] descriptor table for query=eb48d3ce4b6fbe21:d2b22c7c00000000
.impala.log.INFO.20190528.773315:I0529 00:02:11.288002 1938670 query-state.cc:364] Executing instance. instance_id=eb48d3ce4b6fbe21:d2b22c7c00000000 fragment_idx=0 per_fragment_instance_idx=0 coord_state_idx=0 #in-flight=6
.impala.log.INFO.20190528.773315:I0529 00:02:11.535611 1938740 query-exec-mgr.cc:148] ReleaseQueryState(): query_id=eb48d3ce4b6fbe21:d2b22c7c00000000 refcnt=77

 

Error Malformed THandleIdentifier leads to no where. does anyone faced this error before and taken any steps to resolve?

Tableau version is 10.5.1 & Impala Version is 2.10.0-cdh5.13.3 

2 REPLIES 2

Re: Tableau - Impala - Malformed THandleIdentifier error

Master Collaborator

This seems likely to be a bug in the ODBC driver - this happens if the client uses an invalid handle to access a session or query.

Re: Tableau - Impala - Malformed THandleIdentifier error

New Contributor

Thanks Tim for the reply.Below is Impala Version.
May 29 13:57:53.033 DEBUG 28528 DSProductHelper::LogProductInfo: Driver version: 2.6.2.1002

Do You have the link related to this bug or this needs to be reported as a new bug. This error doesn't make any sense. Client submits a query and Impala runs it before client fetch the results session is either closed/crashed.
This do not happen all the time but freq it happens.

https://github.com/apache/impala/blob/master/be/src/service/impala-server.inline.h  --> check this

Don't have an account?
Coming from Hortonworks? Activate your account here