[ 
https://issues.apache.org/jira/browse/HIVE-24352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bartosz Kotwica updated HIVE-24352:
-----------------------------------
    Description: 
I have encountered a compilation error when issue a CTAS query from beeline, 
but without "create table" query works as expected, *narrowed query to 
reproduce:*
  
{code:java}
create table tab_error as
 with tab2 as (
     select
         id,
         lead(id) over (partition by id order by id) as x
     from
         (select 1 id) a
 )
 select
   lead(x) over (partition by id order by id) = 1
 from
     tab2
 ;{code}

  
 *ERROR:*
{noformat}
Error: Error while compiling statement: FAILED: SemanticException Failed to 
breakup Windowing invocations into Groups. At least 1 group must only depend on 
input columns. Also check for circular dependencies.Underlying error: 
org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid column 
reference '1': (possible column names are: ) (state=42000,code=40000){noformat}

  was:
I have encountered a compilation error when issue a CTAS query from beeline, 
but without "create table" query works as expected, *narrowed query to 
reproduce:*
 
create table tab_error as
with tab2 as (
    select
        id,
        lead(id) over (partition by id order by id) as x
    from
        (select 1 id) a
)
select
  lead(x) over (partition by id order by id) = 1
from
    tab2
;
 
*ERROR:*
Error: Error while compiling statement: FAILED: SemanticException Failed to 
breakup Windowing invocations into Groups. At least 1 group must only depend on 
input columns. Also check for circular dependencies.
Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 
Invalid column reference '1': (possible column names are: ) 
(state=42000,code=40000)


> SQL CTAS query failed on compilation stage
> ------------------------------------------
>
>                 Key: HIVE-24352
>                 URL: https://issues.apache.org/jira/browse/HIVE-24352
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive, Parser, PTF-Windowing, SQL
>    Affects Versions: 3.1.0
>            Reporter: Bartosz Kotwica
>            Priority: Minor
>
> I have encountered a compilation error when issue a CTAS query from beeline, 
> but without "create table" query works as expected, *narrowed query to 
> reproduce:*
>   
> {code:java}
> create table tab_error as
>  with tab2 as (
>      select
>          id,
>          lead(id) over (partition by id order by id) as x
>      from
>          (select 1 id) a
>  )
>  select
>    lead(x) over (partition by id order by id) = 1
>  from
>      tab2
>  ;{code}
>   
>  *ERROR:*
> {noformat}
> Error: Error while compiling statement: FAILED: SemanticException Failed to 
> breakup Windowing invocations into Groups. At least 1 group must only depend 
> on input columns. Also check for circular dependencies.Underlying error: 
> org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid column 
> reference '1': (possible column names are: ) 
> (state=42000,code=40000){noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to