Ozzie Workflow for CTE and Insert Statement

newbieone — Fri, 15 Jul 2022 07:49:06 GMT

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

Re: Ozzie Workflow for CTE and Insert Statement

ggangadharan — Tue, 03 Oct 2023 09:15:43 GMT

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.

question Ozzie Workflow for CTE and Insert Statement in Support Questions

Ozzie Workflow for CTE and Insert Statement

Re: Ozzie Workflow for CTE and Insert Statement