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
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: Common Table Expression - Apache Hive - Apache Software Foundation
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.