I have a csv file with 25 lac rows, Can create a local database in Kinme and use SQL query

jaydeb91 · October 2, 2020, 5:30pm

wkhan · October 2, 2020, 7:26pm

Hey jaydeb91,

From what I understand, you’re asking if you can upload the 2,500,000 records into a database in KNIME. KNIME itself does not contain a database, but you could also look into using the 'Create Local Big Data Environment’, load the data, and then running queries.

You could also create a local database such as SQLLite or MYSQL and load the data in via KNIME.

Regards,
Wali Khan

mlauber71 · October 3, 2020, 8:37am

Yes that is possible

If you want to read more about KNIME and (large) databases here is a collection

jaydeb91 · October 15, 2020, 9:55am

Thanks for you quick help

system · April 15, 2021, 9:55pm

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