hive query error syntax when using with clause

hive
#1

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

0 Likes

#2

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