How to fetch list of databases and tables in knime?

KNIME Analytics Platform
1

I have connected to hive db and i am able to do a select query. But I am not able to fetch list of tables and databases using (show tables in dbname / show databases). Is there a way to fetch table metadata.
Also is there a way to extract db spec from db table selector like extract table spec?

2

@harsh you could show all the table with a command like SHOW:

SHOW TABLES IN `default` LIKE "sample_1*"

To see the structure of a table you could use DESCRIBE

DESCRIBE EXTENDED `default`.`sample_01`

To explore further the possibilities of Hive and the local Big Data environment you might want to refer to this sample workflow:

2 Likes
3

The issue is not the query. I just found out that doing evaluate in node configuration uses select * from( query) which fails. But if you save the query without evaluating and test it, it runs perfectly fine.

Thanks

4

Yes, you can execute the query but not evaluate it.

5

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.