Ozzie Workflow for CTE and Insert Statement

[#1]

Hi all,

Have hit a snag when trying to setup a Ozzie workflow with combination of CTE and Insert Statement, not sure why, please help me look at the code, thanks.

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

insert into table A partition(date)

with test as
(select col1 as name1 , col2 as name2, col3 as name3 from table B),

select * from test

[#2 · Accepted solution]

It seems that the query involves dynamic partitioning, but the dynamic partition column is not included in either the select statement or the Common Table Expression (CTE).

Please add the dynamic partition column 'date' to the select statement and validate it in Beeline.