Support Questions

Find answers, ask questions, and share your expertise

Ozzie Workflow for CTE and Insert Statement


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




Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.