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