SQL Parsing issue in DB Query Reader node ?

KNIME Analytics Platform
1

Hi,
I’m using Knime 4.0.2 on MacOS Mojave. I’m using the DB Query Reader node to run some substructure searches against a PostgreSQL database with the RDKit cartridge . When trying out various queries, I noticed some odd behaviour when commenting out lines of test SQL in the node.

This first query evaluates fine…

42
42736×335 35.8 KB

But just put an extra blank line after the query and the parser gets confused…

40
40727×352 28.5 KB

I originally noticed the issue when commenting out other queries in the node…

57
57727×375 39.6 KB

If there is a better place to report an issue like this, please let me know :slight_smile:

Drew

2

Hello Drew,

The DB Query Reader sends the SQL query to the database without modifications, except for the evaluation of the statement. If the node fails execution, the native parser of the database throws an error.

The DB Query Reader can handle only one SQL statement. If you drop the semicolons in the statement the database parser and the evaluation will succeed.

Best regards,
Michael

2 Likes
3

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