[jira] [Created] (DRILL-3951) Lexical Errors in ODBC Queries

["Charles Givre (JIRA)" <ji...@apache.org>]

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 Authentication"
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
(v6.3.4#6332)