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.