Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id C1822200CB4 for ; Mon, 12 Jun 2017 22:56:04 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id C03CA160BDE; Mon, 12 Jun 2017 20:56:04 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B5BAD160BD9 for ; Mon, 12 Jun 2017 22:56:03 +0200 (CEST) Received: (qmail 60413 invoked by uid 500); 12 Jun 2017 20:56:02 -0000 Mailing-List: contact issues-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@impala.incubator.apache.org Delivered-To: mailing list issues@impala.incubator.apache.org Received: (qmail 60404 invoked by uid 99); 12 Jun 2017 20:56:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Jun 2017 20:56:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 70F05C0118 for ; Mon, 12 Jun 2017 20:56:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id bCbyxWZdZFbI for ; Mon, 12 Jun 2017 20:56:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 162485F568 for ; Mon, 12 Jun 2017 20:56:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 8639BE0A2F for ; Mon, 12 Jun 2017 20:56:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 31E9E21E0D for ; Mon, 12 Jun 2017 20:56:00 +0000 (UTC) Date: Mon, 12 Jun 2017 20:56:00 +0000 (UTC) From: "Tim Armstrong (JIRA)" To: issues@impala.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (IMPALA-2659) ODBC driver not relocatable MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 12 Jun 2017 20:56:04 -0000 [ https://issues.apache.org/jira/browse/IMPALA-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Armstrong resolved IMPALA-2659. ----------------------------------- Resolution: Not A Problem > ODBC driver not relocatable > --------------------------- > > Key: IMPALA-2659 > URL: https://issues.apache.org/jira/browse/IMPALA-2659 > Project: IMPALA > Issue Type: Bug > Components: Clients > Affects Versions: Impala 2.2.4 > Environment: Debian/Ubuntu > Reporter: Michael Koenig > Priority: Minor > Labels: impala, odbc > > Impala's ODBC driver only seems to work when the {{libclouderaimpalaodbc64.so}} driver binary is placed in the default installation directory {{/opt/cloudera/impalaodbc/lib/64}}. I tried to change the location of the driver by > * Copying the {{*.so}} file to a different folder > * Symbolically linking the {{*.so}} file from a different folder > In both cases, the copied/linked driver works for simple cases - provided {{export LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libodbcinst.so}} is executed before using the driver. However, it seems to ignore the content of the {{CLOUDERAIMPALAINI}} environment variable. This influences a number of things: > * Activating driver-side logging is not possible > * Switching to {{UTF-16}} mode for unixODBC support is not possible > * Specifying the {{ErrorMessagesPath}} option is not possible, rendering all error messages issued by the driver into {{The error message XXX could not be found in the en-US locale}} > h2. Cross-checks > I tried to make sure that I did not mess up on a trivial level (misspelling things etc.). Hence, I played around with the {{CLOUDERAIMPALAINI}} environment variable and the driver installed at its original location. > It turns out all settings in the file specified by {{CLOUDERAIMPALAINI}} are fully respected. This means I can relocate the error message files (copying them somewhere else, even changing messages), fix unixODBC unicode compatibility, and enable logging for debugging. > The only change from this well-documented situation to the one above is that I use the driver via a copied binary or a symbolic link. > h2. Why this bug is important for me > In our company we mainly rely on Python wheels to let users install binary software in Python virtual environments without requiring root access. In the context of ODBC drivers, this procedure worked well so far, allowing us to package ODBC drivers for MySQL, PostgreSQL, Oracle, Teradata, MonetDB, etc. Impala's ODBC driver is the first to show this most confusing and annoying behavior. > h2. System environment > I toyed around with the Impala ODBC driver (v 2.5.30) for Debian (64bit) on my Ubuntu 12.04 machine. Asking a system administrator I installed the provided {{.deb}} package into my system. -- This message was sent by Atlassian JIRA (v6.4.14#64029)