How to fetch list of databases and tables in knime?

KNIME Analytics Platform
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