Hi!
I use Hive 3.1.0 and beeline.
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)
Please confirm the issue then I will create a Jira ticket.
Kind regards,
Bartosz Kotwica
