DB SQL Executor node result

KNIME Analytics Platform
1

Hello, I’m having a hard time using queries.
I want to query information about a table in Hive.

So, I wrote the following query in DB SQL Executor Node, but it only runs and I cannot check the results.

image
image1526×1009 43.1 KB

Is there a way to check the results of a query statement other than a select statement?

Any help would be greatly appreciated. Thank you.

2

Hello @mychoi ,
you can use the DB Query Reader to execute almost all queries that return a result table e.g. SHOW TABLES.
Bye
Tobias