Datastage 11.5 to Impala ODBC Socket closed error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tanumoy2017
Participant
Posts: 6
Joined: Tue Oct 10, 2017 12:32 pm

Datastage 11.5 to Impala ODBC Socket closed error

Post by tanumoy2017 »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
tanumoy2017
Participant
Posts: 6
Joined: Tue Oct 10, 2017 12:32 pm

Post by tanumoy2017 »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply