[HIVE-24352] SQL CTAS query failed on compilation stage

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: Hive, Parser, PTF-Windowing, SQL
• Assignee: Unassigned Assign to me
• Reporter: Bartosz Kotwica
• Created: 03/Nov/20 14:48
• Updated: 03/Nov/20 14:50

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:
 

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)