hive query error syntax when using with clause

When using Hive query using the with clause, occurs the following error

TesteHIveWithSQL.knwf (249.5 KB)

is there any other way to use the with clause using hive?

Thanks,
Anderson

Hi @Anderson,
welcome to the KNIME community.
Unfortunately it is not possible to use WITH as we use the given query as subquery in a “SELECT * FROM” query.
Hive does not support WITH in a subquery: https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expression

The WITH clause is not supported within SubQuery Blocks
How do you want to use WITH (For the example query it is obviously not needed)? Maybe we can find a workaround…
best Mareike

The WITH clause is not supported within SubQuery Blocks

2 Likes