Connecting to Impala via Knime error

Hi, I have successfully connected to Impala via Knime but I am having trouble with the database table selector node.

I would like to select a table named ‘email sends’ with the following SQL statement : ‘SELECT * FROM emailsends’ but it results in the following error:

‘ERROR Database Table Selector 0:5 Execute failed: Error while validating SQL query: [Cloudera]ImpalaJDBCDriver ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Could not resolve table reference: ‘emailsends’
), Query: SELECT * FROM (SELECT * FROM emailsends) tempTable_5708293457343988912 LIMIT 0.’

Any guidance or help is highly appreciated, thank you.

I’m guessing here, however I’d bet the SQL is looking for the query in a schema.table format.

FROM schema.table

So without the schema it doesn’t know where to find the table.



Thank you! I managed to get the node working with your help.


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