Hi All,
I followed up all the specified steps in the discussion: https://community.oracle.com/tech/developers/discussion/4417863/how-to-query-hive-and-impala-from-oracle-using-odbc-heterogeneous-gateway
but finally I got a message that:
SQL Error [28500] [99999]: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Cloudera][Hardy] (101) Incorrect database facts specified. Please check your configuration. {HY000,NativeErr = 101}
ORA-02063: preceding 2 lines from testdblink
when I change in the file odbc.ini Schema=default and query any table it reply that
QL Error [942] [42000]: ORA-00942: table or view does not exist
[Cloudera][SQLEngine] (31740) Table or view not found: HIVE.FACTS.TEST_TABLE{42S02,NativeErr = 31740}
ORA-02063: preceding 2 lines from testdblink
while everything is running smoothly on isql
Please advise.
Hassan