SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database [Hortonworks][HiveODBC] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.

[#1]

Hello Experts,

we are trying to access a virtual table VT_ADDRESS_HIVE.

Trying to issue the following scripts:

-- 1 select "countrycode", "citycode", count(*) from "COM_DATA_HDPH01_ROC"."VT_ADDRESS_HIVE" groupby "countrycode", "citycode";

-- 2 Schema w/o Double Quotes select "countrycode", "citycode", count(*) from COM_DATA_HDPH01_ROC."VT_ADDRESS_HIVE" groupby "countrycode", "citycode";

-- 3 Schema, Table w/o Double Quotes

select "countrycode", "citycode", count(*) from COM_DATA_HDPH01_ROC.VT_ADDRESS_HIVE groupby "countrycode", "citycode";

-- 4 W/o Count, w/o Double Quotes

select "countrycode", "citycode" from COM_DATA_HDPH01_ROC.VT_ADDRESS_HIVE groupby "countrycode", "citycode";

lead to:

Could not execute 'select "countrycode", "citycode", count(*) from "COM_DATA_HDPH01_ROC"."VT_ADDRESS_HIVE" ...' in 3:40.971 minutes .

SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database [Hortonworks][HiveODBC] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'. for query "SELECT COUNT(*), VT_ADDRESS_HIVE.countrycode, VT_ADDRESS_HIVE.citycode FROM HIVE.roc.address VT_ADDRESS_HIVE GROUP BY VT_ADDRESS_HIVE.countrycode,VT_ADDRESS_HIVE.citycode "

All statements are running 3 - 4 minutes and then ending up with the error.

Any advice or idea?

Thanks and best regards, Matthias Maier

[#2]

The quotes don't matter in this case. Is the virtual table a view? If so it's hard to know exactly what SQL is being executed on the back end. You should look at the HiveServer2 logs or Resource Manager UI to see the specific failure.

[#3]

Have looked at the HS2 and RM logs, havent seen any errors in there. We might need to try to turn the log level to DEBUG for Hive and RM to get more details

[#4]

@Matthias Maier are you still having issues with this? Can you accept best answer or provide your own solution?