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 

1. Downloaded and installed CouderaHiveODBC-2.5.19.1004-1.el6.x86_64.rpm as root
2. Downloaded and installed ClouderaImpalaODBC-2.5.33.1004-1.el6.x86_64.rpm
3. Configure Cloudera Hive ODBC after installation:

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/

1. Set cloudera environment variable:

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:.

1. Edit odbc.ini file in /opt/home/oracle /odbc.ini  (changed only the host, schema, port, and UID under [Cloudera ODBC Driver for Apache Hive (64-bit) DSN] and rename the data source name to HIVEDSN as follows)

[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

1. Source environment file
2. Test connection failed as shown below:

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