[IMPALA-6234] COMPUTE INCREMENTAL STATS with partition specs fails if no partition found

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: Impala 2.8.0, Impala 2.9.0, Impala 2.10.0
• Component/s: Frontend
• Labels: newbie
• Environment: Impala-Shell: v2.8.0-cdh5.11.1 (3382c1c) ; Linux 2.6.32-504.8.1.el6.x86_64 Centos 6 ; ; Impala JDBC: 2.5.29
• Epic Color: ghx-label-8
• Assignee: Yongzhi Chen
• Reporter: Antoni Ivanov
• Created: 22/Nov/17 07:02
• Updated: 08/Mar/19 21:43
• Resolved: 08/Mar/19 21:43

Description

I noticed that if no partition matches the "query" the compute stats fails (and hangs it doesn't get clean up):
E.g COMPUTE INCREMENTAL STATS `foo` PARTITION (partition_column != partition_column) - no partition would be matched
returns the following error:
AnalysisException: Syntax error in line 1:
...M history.astro_ui WHERE () GROUP BY pa__arrival_day, ...
^
Encountered: )
Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, REPLACE, SELECT, TRUNCATE, TRUE, VALUES, WITH, IDENTIFIER
CAUSED BY: Exception: Syntax error

Also when using JDBC Impala Driver the query hangs until the connection is closed (and not just the statement) We are using Impala JBDC version 2.5.29. The query is in state "waiting to be closed" (as seen in Impala Deamon Web UI)

Note that this behaviour happens only for COMPUTE INCREMENTAL STATS and not for DROP INCREMENTAL STATS. DROP finishes successfully with no issues.