Connecting to Impala via Knime error

[adnanmajidy]

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.

[bve]

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

SELECT *
FROM schema.table

@adnanmajidy

Could not resolve table reference: ‘emailsends’

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

HTH

[adnanmajidy]

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