Hi everyone,
I am using the Knime 4.2.2 version and when I am trying to run DB Query reader I get the following error:
ERROR DB Query Reader 0:2805 Execute failed: org/antlr/v4/runtime/CharStream
Can you please help me?
Hello @IlariaL,
welcome to KNIME Community!
Can you share a bit more details? Like what is the database you connecting to? How does you query looks like? How does your workflow design looks like?
Br,
Ivan
1 Like
Hi Ivan,
It is a DB connector connected to a query reader with a standard SQL query connected to a redshift DB.
Does that help you?
Hello @IlariaL,
maybe it helps. For Redshift database there is a dedicated connector to use - Amazon Redshift Connector. Also you’ll need to install database driver plug-in. See this section of database guide on how to do that: Third-party Database Driver Plug-in
If you are already using dedicated connector and have installed driver can you share SQL statement from DB Query node that is giving you this error? Also is it only this statement giving you problems or every statements you enter produces error?
Br,
Ivan