UnixOdbc Driver Throws Segmentation fault when Executing Impala Queries (Doc ID 1964539.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 3.0 and later
Linux x86-64

Symptoms

Using impala odbc driver(2.5.22) and unixODBC(odbc_config --version) version 2.2.14 on Linux and have the following issues ..

When using LOAD DATA INPATH command on a directory where the impala user does not have the correct permissions, expect to see this error.

ERROR: AccessControlException: Permission denied: user=impala, access=WRITE

Using pyodbc Segmentation fault is returned instead of a valid error.

>>>import pyodbc
>>>cursor_impala=pyodbc.connect(DSN='impala-bda', autocommit=True).cursor()
>>>cursor_impala.execute("LOAD DATA INPATH 'path with wrong permissions' OVERWRITE INTO TABLE table PARTITION ( cal_week_id=20140101)")
Segmentation fault (core dumped)


Using isql in the first call referenced an incorrect partition and it has produced a proper error. The second call is on an existing partition but with the incorrect permissions and no error is being returned at all(At least it doesn't seg fault here).

$ isql -v impala
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> LOAD DATA INPATH 'path with wrong permissions' OVERWRITE INTO TABLE table PARTITION ( cal_week_id=201401011)
[S1000][unixODBC][Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Partition spec does not exist: (cal_week_id=201401011).
[ISQL]ERROR: Could not SQLExecute
SQL> LOAD DATA INPATH 'path with wrong permissions' OVERWRITE INTO TABLE table PARTITION ( cal_week_id=20140101)
[ISQL]ERROR: Could not SQLExecute


On windows and using impala-shell the error is returned as normal and everything works fine. The linux driver seems to be working fine apart from this issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms