Created on 01-12-2017 06:18 PM - edited 09-16-2022 03:54 AM
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
Created 01-26-2017 10:38 AM
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
Created 01-25-2017 05:11 PM
Is this related to kerberos authentication??
Created 01-26-2017 10:38 AM
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