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
Datastage 11.5 to Impala ODBC Socket closed error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue Oct 10, 2017 12:32 pm
-
- Participant
- Posts: 6
- Joined: Tue Oct 10, 2017 12:32 pm
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
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