DSXchange

Hi Team

We are trying to implement a job which reads from Hadoop using Impala and write to a seq file using simple username & password authentication
For this we have edited the odbc.ini file as below

[Impala_Test]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMimpala00.so
Description=DataDirect Impala Wire Protocol Driver
ArraySize=16384
AuthenticationMethod=0
Database=consume_acm
DefaultLongDataBuffLen=1024
DefaultOrderByLimit=-1
EnableDescribeParam=0
HostName=xxx.com
LoginTimeout=30
LogonID=
MaxVarcharSize=
Password=
PortNumber=21050
RemoveColumnQualifiers=0
StringDescribeType=12
TransactionMode=0
UseCurrentSchema=0

While we are testing the connection we are getting the below error :

SQLSTATE = 08S01
NATIVE ERROR = 0
MSG = [IBM(DataDirect OEM)][ODBC Impala Wire Protocol driver]Socket closed.

Please let me know for any suggestions.

Thanks
Tanumoy

As noted here and here it's a pretty generic "something went wrong" error without any knowledge of what actually happened other than the connection terminated. Both mention setting up a trace to try to narrow the issue down.

We enabled trace and got the below errors while testing the ODBC DSN :
Have replaced the username with XXXXX

ENTER SQLAllocConnect
HENV 0x0000000104a270
HDBC * 0x007ffe790a6998

EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x0000000104a270
HDBC * 0x007ffe790a6998 ( 0x000000010595d0)

ENTER SQLConnect
HDBC 0x000000010595d0
UCHAR * 0x007ffe790a6900 [4294967293] "Impala_Test"
SWORD -3
UCHAR * 0x007ffe790a6960 [4294967293] "XXXXXX"
SWORD -3
UCHAR * 0x007f9c551c5a04 [4294967293] "******"
SWORD -3

EXIT SQLConnect with return code -1 (SQL_ERROR)
HDBC 0x000000010595d0
UCHAR * 0x007ffe790a6900 [4294967293] "Impala_Test"
SWORD -3
UCHAR * 0x007ffe790a6960 [4294967293] "XXXXXX"
SWORD -3
UCHAR * 0x007f9c551c5a04 [4294967293] "******"
SWORD -3

ENTER SQLError
HENV 0x0000000104a270
HDBC 0x000000010595d0
HSTMT (nil)
UCHAR * 0x007ffe790a6230 (NYI)
SDWORD * 0x007ffe790a602c
UCHAR * 0x007ffe790a6030
SWORD 511
SWORD * 0x007ffe790a602a

EXIT SQLError with return code 0 (SQL_SUCCESS)
HENV 0x0000000104a270
HDBC 0x000000010595d0
HSTMT (nil)
UCHAR * 0x007ffe790a6230 [ 5] "08S01"
SDWORD * 0x007ffe790a602c (0)
UCHAR * 0x007ffe790a6030 [ 69] "[IBM(DataDirect OEM)][ODBC Impala Wire Protocol driver]Socket closed."
SWORD 511
SWORD * 0x007ffe790a602a (69)

ENTER SQLError
HENV 0x0000000104a270
HDBC 0x000000010595d0
HSTMT (nil)
UCHAR * 0x007ffe790a6230 (NYI)
SDWORD * 0x007ffe790a602c
UCHAR * 0x007ffe790a6030
SWORD 511
SWORD * 0x007ffe790a602a

EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
HENV 0x0000000104a270
HDBC 0x000000010595d0
HSTMT (nil)
UCHAR * 0x007ffe790a6230 (NYI)
SDWORD * 0x007ffe790a602c
UCHAR * 0x007ffe790a6030
SWORD 511
SWORD * 0x007ffe790a602a

Well... this is where you would typically involve support, people versed in reading trace logs like this. Not my forte, sadly.