[
https://issues.apache.org/jira/browse/DRILL-3951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Charles Givre resolved DRILL-3951.
----------------------------------
Resolution: Resolved
> 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
> Priority: Major
>
> 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
(v8.3.4#803005)
