Support Questions

Find answers, ask questions, and share your expertise

Ozzie Workflow for CTE and Insert Statement

Explorer

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

 

 

 

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