Created on 06-07-2017 08:26 PM - edited 09-16-2022 04:43 AM
I am working on a ‘approve of concept’ project to see how we can query/transfer data between oracle and our corporate data lake.
I installed Cloudera ODBC Hive and Impala drivers, when I tried to test 'isql'onnections, it failed with the following error:
[S1000][unixODBC][Cloudera][Hardy] (34) Error from server: connect() failed: Connection refused.
[ISQL]ERROR: Could not SQLConnect
Here is the detailed steps I followed, any input would be appreicated.
Linda
Environment: RedHat Linux 6.9 with UnixODBC in place
Oracle DB: 12.1.02 with SID Name: lvdma01 wiht hivetest schema name created
Cd /opt/cloudera/hiveodbc/Setup
mkdir -p /usr/local/odbc
cp /opt/cloudera/hiveodbc/Setup/odbc.ini /opt/home/oracle/ --Note: oracle home dir is /opt/home/oracle
cp /opt/cloudera/hiveodbc/lib/64/cloudera.hiveodbc.ini /etc/
export ORACLE_SID=lvdma01
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2
export ODBCINI=~/odbc.ini
export ODBCSYSINI=/usr/local/odbc
export CLOUDERAHIVEINI=/etc/cloudera.hiveodbc.ini
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=/usr/bin:/usr/ucb:/usr/sbin:/etc:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/bin:/usr/ccs/bin:/usr/local/bin:.
[HiveDSN]
HOST=uslv-sdbx-ora02
PORT=10000
# The name of the database schema to use when a schema is not explicitly specified in a query.
Schema=hivetest
# Set the UID with the user name to use to access Hive when using AuthMech 2 to 8.
UID=cloudera
uslv-sdbx-ora02.amgen.com:oracle[lvdma01]$ isql -v hivedsn
[S1000][unixODBC][Cloudera][Hardy] (34) Error from server: connect() failed: Connection refused.
[ISQL]ERROR: Could not SQLConnect