[
https://issues.apache.org/jira/browse/IMPALA-6234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788330#comment-16788330
]
bharath v commented on IMPALA-6234:
-----------------------------------
I'm not able to repro this either. This is on the master.
{noformat}
[0d66cd6004b4:21000] default> show partitions functional.alltypes;
Query: show partitions functional.alltypes
+-------+-------+-------+--------+----------+--------------+-------------------+--------+-------------------+-------------------------------------------------------------------+
| year | month | #Rows | #Files | Size | Bytes Cached | Cache Replication
| Format | Incremental stats | Location
|
+-------+-------+-------+--------+----------+--------------+-------------------+--------+-------------------+-------------------------------------------------------------------+
| 2009 | 1 | 310 | 1 | 19.95KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=1 |
| 2009 | 2 | 280 | 1 | 18.12KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=2 |
| 2009 | 3 | 310 | 1 | 20.06KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=3 |
| 2009 | 4 | 300 | 1 | 19.61KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=4 |
| 2009 | 5 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=5 |
| 2009 | 6 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=6 |
| 2009 | 7 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=7 |
| 2009 | 8 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=8 |
| 2009 | 9 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=9 |
| 2009 | 10 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=10 |
| 2009 | 11 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=11 |
| 2009 | 12 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2009/month=12 |
| 2010 | 1 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=1 |
| 2010 | 2 | 280 | 1 | 18.39KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=2 |
| 2010 | 3 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=3 |
| 2010 | 4 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=4 |
| 2010 | 5 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=5 |
| 2010 | 6 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=6 |
| 2010 | 7 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=7 |
| 2010 | 8 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=8 |
| 2010 | 9 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=9 |
| 2010 | 10 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=10 |
| 2010 | 11 | 300 | 1 | 19.71KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=11 |
| 2010 | 12 | 310 | 1 | 20.36KB | NOT CACHED | NOT CACHED
| TEXT | false |
hdfs://localhost:20500/test-warehouse/alltypes/year=2010/month=12 |
| Total | | 7300 | 24 | 478.45KB | 0B |
| | |
|
+-------+-------+-------+--------+----------+--------------+-------------------+--------+-------------------+-------------------------------------------------------------------+
Fetched 25 row(s) in 5.27s
[0d66cd6004b4:21000] default> compute incremental stats functional.alltypes
partition(year=2000, month=2);
Query: compute incremental stats functional.alltypes partition(year=2000,
month=2)
ERROR: AnalysisException: No matching partition(s) found.
[0d66cd6004b4:21000] default>
{noformat}
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
