DB Query Reader Error

[KPLowes]

Hi,

I am getting this error while running the query mentioned below - ERROR DB Query Reader 11:154 Execute failed: The query did not generate a result set!

The query however runs in Dbeaver.

Query
create table np_enterpriseinsights.dt_00_pre_dtl
as
(select distinct srv.surveyid
,srv.cal_dt
,srv.lct_nbr
,srv.ivo_nbr
,sd.mas_sal_tns_nbr
from np_enterpriseinsights.bib_survey_details srv
inner join lowes_vm.i1695e_sls_dtl sd
on srv.cal_dt =sd.cal_dt
and srv.lct_nbr=sd.lct_nbr
and srv.ivo_nbr=sd.ivo_nbr
where srv.lct_nbr = 3
)

[mlauber71]

@KPLowes you have to use the SQL Executor.

DB SQL Executor

KNIME, Databases and SQL

[KPLowes]

Thanks for your reply. I used SQL Executor. Getting the following error now.

ERROR DB Query Reader 13:326 Execute failed: org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=9ec0b41f-c8d3-44b6-84cb-b2a65d1e5443]

[KPLowes]

I used SQL Executor. Getting the following error now.

ERROR DB Query Reader 13:326 Execute failed: org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=9ec0b41f-c8d3-44b6-84cb-b2a65d1e5443]

[Daniel_Weikert]

Have you tried a simple query just to see whether that runs in general?
br

[mlauber71]

@KPLowes it seems you are trying to query a Hive table. Do you have a proper connection and can you for example see other hive tables and query them before you create new ones.

Also maybe you can provide more information about your workflow and setup and maybe a log in debug mode.

[KPLowes]

The query runs if I put a limiting condition to reduce the data .