Support Questions

Find answers, ask questions, and share your expertise

Ozzie Workflow for CTE and Insert Statement

avatar
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

 

 

 

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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.

View solution in original post

1 REPLY 1

avatar
Super Collaborator

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.