[ https://issues.apache.org/jira/browse/IMPALA-6234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
bharath v resolved IMPALA-6234. ------------------------------- Resolution: Not A Problem > COMPUTE INCREMENTAL STATS with partition specs fails if no partition found > -------------------------------------------------------------------------- > > Key: IMPALA-6234 > URL: https://issues.apache.org/jira/browse/IMPALA-6234 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 2.8.0, Impala 2.9.0, Impala 2.10.0 > 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 > Reporter: Antoni Ivanov > Assignee: Yongzhi Chen > Priority: Major > Labels: newbie > > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)