[ 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)