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.

ExecPlanRequest rpc exception error while COMPUTE STATS

Solved Go to solution

ExecPlanRequest rpc exception error while COMPUTE STATS

Contributor

Hello,

 

Today, when I run "compute stats" command in Impala, I got this kind of error.

Can you tell me what I need to check to root-cause the issue?

 

I've restart Impala cluster in case, but still doesn't work.

 

Thank you

Gatsby

 

 

Query (id=e14f8e09bc61152e:edb3c88b00000000):
  Summary:
    Session ID: ec4783541c02a53b:94e307a26bcc719e
    Session Type: BEESWAX
    Start Time: 2017-01-12 17:17:13.717774000
    End Time: 2017-01-12 17:17:14.027669000
    Query Type: DDL
    Query State: EXCEPTION
    Query Status: ExecPlanRequest rpc query_id=fb4b42b5b270a117:f7b20fe800000000 instance_id=fb4b42b5b270a117:f7b20fe800000001 failed: RPC Error: No more data to read.


    Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (build )
    User: root
    Connected User: root
    Delegated User: 
    Network Address: ::ffff:10.168.16.16:44184
    Default Db: default
    Sql Statement: compute STATS onlinemarketing_201701
    Coordinator: hadoop2-wn2.dwarehouse.internal:22000
    Query Options (non default): 
    DDL Type: COMPUTE_STATS
    : 0.000ns
    Query Timeline: 310.440ms
       - Start execution: 68.354us (68.354us)
       - Planning finished: 2.602ms (2.533ms)
       - Request finished: 265.917ms (263.315ms)
       - Unregister query: 309.901ms (43.983ms)
  ImpalaServer:
     - ClientFetchWaitTimer: 0.000ns
     - RowMaterializationTimer: 0.000ns

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

Contributor

I found out what caused this issue in this case.

 

Nodes have different Impala version, such as 2.8, 2.4 etc.

The interesting thing is that `compute stats` operation didn't work if run in Impala 2.8,

but the operation works in Impala 2.4.

 

Anyway, I hope this can help you solve your problem.

 

Thank you

Gatsby

2 REPLIES 2
Highlighted

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

Contributor

Is this related to kerberos authentication??

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

Contributor

I found out what caused this issue in this case.

 

Nodes have different Impala version, such as 2.8, 2.4 etc.

The interesting thing is that `compute stats` operation didn't work if run in Impala 2.8,

but the operation works in Impala 2.4.

 

Anyway, I hope this can help you solve your problem.

 

Thank you

Gatsby

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