drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Charles Givre (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3951) Lexical Errors in ODBC Queries
Date Mon, 19 Oct 2015 17:33:05 GMT
Charles Givre created DRILL-3951:

             Summary: Lexical Errors in ODBC Queries
                 Key: DRILL-3951
                 URL: https://issues.apache.org/jira/browse/DRILL-3951
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - ODBC
    Affects Versions: 1.1.0, 1.2.0
         Environment: Mac OS 10.11, Apache Drill v. 1.2, Python 3.4, 
            Reporter: Charles Givre

I followed the instructions to install the latest version of Apache Drill, and the Mapr ODBC
drivers, but when I attempt to query a data source via ODBC, I get the following errors:

Error: ('HY000', '[HY000] [MapR][Drill] (1040) Drill failed to execute the query: ����������������`\n[30027]Query
execution error. Details:[ \nPARSE ERROR: Lexical error at line 1, column 1.  Encountered:
"\\ufffd" (65533), after : ""\n\n\n[Error Id: 8e1f4049-f3e9-477f-9e3f-5df62c (1040) (SQLExecDirectW)')

Here is the code which generates the errors:

import pyodbc
import pandas as pd
MY_DSN = "DRIVER=/opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib;Host=localhost;Port=31010;ConnectionType=Direct;Catalog=Drill;Schema=mfs.views;AuthenticationType=No
conn = pyodbc.connect(MY_DSN, autocommit=True)
cursor = conn.cursor()

employee_query = "SELECT * FROM dfs.`employee.json`"
data = pd.read_sql( employee_query, conn )

This message was sent by Atlassian JIRA

View raw message