ExecPlanRequest rpc exception error while COMPUTE STATS

thewayofthinkin — Fri, 16 Sep 2022 10:54:40 GMT

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

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

thewayofthinkin — Thu, 26 Jan 2017 01:11:05 GMT

Is this related to kerberos authentication??

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

thewayofthinkin — Thu, 26 Jan 2017 18:38:06 GMT

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

question Re: ExecPlanRequest rpc exception error while COMPUTE STATS in Archives of Support Questions (Read Only)

ExecPlanRequest rpc exception error while COMPUTE STATS

Re: ExecPlanRequest rpc exception error while COMPUTE STATS

Re: ExecPlanRequest rpc exception error while COMPUTE STATS