Member since
12-09-2015
1
Post
0
Kudos Received
0
Solutions
12-09-2015
09:19 AM
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
... View more
Labels:
- Labels:
-
Apache Hive