How to get data of large number of unit from DB?

KNIME Analytics Platform
1

Hi, All,
I’m a beginner of KNIME and SQL.
I’m getting some data from a database of a large system of my company.
The data base contains performance data of each machine unit.

I use Impala Connector to access the database, DB Table Selector to get some data for step1, and then DB Row Filter to limit time span of the data.

I can pick up some data of a unit comprising the system using DB ROW Filter. However, I’d like to pick up more data of many units, like 100 through 1000 units, which leads cumbersome using DB Row Filter defining each unit one by one. Using a tabe would be better way, but I’m not sure how to use it with DB Row Filter.

My question is how to get data of large number of unit from the database?
What repository I have to use, not DB Row Filter?
How to write SQL command in it, if neccessary?

Thank you in advance.

2

I think you already gave the answer. You probably want to write an sql query with your filters
SELECT * FROM db WHERE … IN (…)
or sth like that
br

3

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