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)
