[
https://issues.apache.org/jira/browse/IMPALA-1106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17156546#comment-17156546
]
Akshath Hegde commented on IMPALA-1106:
---------------------------------------
I can see the issue is marked as Resolved. But not able to see any resolution
steps. How can we resolve this issue?
I am getting the same error for some of our queries in cloudera setup. Issue we
started facing after upgrading cloudera to 6.3.
This is impacting a lot of our queries, not able to find the solution for this,
please let me know how to resolve this issue.
> AnalysisException: Table does not exist, when using deeply nested WITH clauses
> ------------------------------------------------------------------------------
>
> Key: IMPALA-1106
> URL: https://issues.apache.org/jira/browse/IMPALA-1106
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 2.0
> Reporter: casey
> Assignee: Dimitris Tsirogiannis
> Priority: Major
> Fix For: Impala 2.0
>
>
> The query below is valid and runs fine in postgres but in impala it fails
> with an analysis error.
> Query:
> {noformat}
> WITH with_1 AS (select 1 as int_col_1),
> with_2 AS (
> SELECT 1 as int_col_1
> FROM (
> WITH with_3 AS (SELECT 1 AS int_col_1 FROM with_1)
> SELECT 1 AS int_col_1 FROM with_3
> ) AS t1
> )
> SELECT 1 AS int_col_1 FROM with_2
> {noformat}
> Impala:
> {noformat}
> [localhost:21000] > WITH with_1 AS (select 1 as int_col_1),
> > with_2 AS (
> > SELECT 1 as int_col_1
> > FROM (
> > WITH with_3 AS (SELECT 1 AS int_col_1 FROM
> with_1)
> > SELECT 1 AS int_col_1 FROM with_3
> > ) AS t1
> > )
> > SELECT 1 AS int_col_1 FROM with_2;
> Query: with with_1 AS (select 1 as int_col_1), with_2 AS ( SELECT 1 as
> int_col_1 FROM ( WITH with_3 AS (SELECT 1 AS int_col_1 FROM with_1) SELECT 1
> AS int_col_1 FROM with_3 ) AS t1 ) SELECT 1 AS int_col_1 FROM with_2
> ERROR: AnalysisException: Table does not exist: randomness.with_1
> {noformat}
> Postgresql:
> {noformat}
> psql --username=postgres randomness
> psql (9.1.13)
> Type "help" for help.
> randomness=# WITH with_1 AS (select 1 as int_col_1),
> randomness-# with_2 AS (
> randomness(# SELECT 1 as int_col_1
> randomness(# FROM (
> randomness(# WITH with_3 AS (SELECT 1 AS int_col_1 FROM with_1)
> randomness(# SELECT 1 AS int_col_1 FROM with_3
> randomness(# ) AS t1
> randomness(# )
> randomness-# SELECT 1 AS int_col_1 FROM with_2;
> int_col_1
> -----------
> 1
> (1 row)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
