Hi Charles, You can execute the command "locale" in the terminal and it should be displayed. Also, are you using a driver manager? I think for pyodbc on Mac OS X, iODBC is recommended. Typically a driver manager helps to handle encoding issues.
Norris -----Original Message----- From: Charles Givre [mailto:[email protected]] Sent: Wednesday, July 08, 2015 7:13 PM To: [email protected] Subject: Re: Strange Error when Querying Hi Parth, I couldn’t find the locale settings. Where are they located? Thanks, — C > On Jul 8, 2015, at 16:27, Parth Chandra <[email protected]> wrote: > > Hi Charles, > > What is your locale setting? It is probably some character encoding issue > and may be a bug. As Jason suggested, please log a JIRA for this and add as > much information about your environment as you can. > > Parth > > On Wed, Jul 8, 2015 at 11:30 AM, Jason Altekruse <[email protected]> > wrote: > >> It certainly does look like an issue with encoding, but you can see in his >> code the query he is trying to run. There are not unicode characters that I >> can see. It is possible that this is getting corrupted somehow in the ODBC >> driver. Please file a JIRA with this case, I don't have a suggestion for a >> fix myself, but it is something we should take a look at soon. >> >> employee_query = """SELECT position_title, COUNT( employee_id ) as >> employee_count >> FROM cp.`employee.json` >> GROUP BY position_title >> ORDER BY COUNT( employee_id ) DESC""" >> >> On Wed, Jul 8, 2015 at 10:52 AM, Abhishek Girish < >> [email protected]> >> wrote: >> >>> I'm not quite sure what is happening, but I could guess it's due to >> unicode >>> characters in the query text. I faced a somewhat similar issue before - >>> DRILL-987 <https://issues.apache.org/jira/browse/DRILL-987> >>> >>> Just to give it a try, can you copy your query text into a text editor >> that >>> can display invisible characters (such as TextWrangler) or rewrite the >>> query to get rid of these? >>> >>> Let us know if this resolves. Others can comment if they know better. >>> >>> -Abhishek >>> >>> On Tue, Jul 7, 2015 at 2:21 PM, Charles Givre <[email protected]> wrote: >>> >>>> All, >>>> I'm trying to write some python code to interact with Drill and I'm >>> getting >>>> a strange error. I'm able to connect, and the SQL query is valid, but >>> the >>>> query does not execute. I tried the query via the web interface, and >> it >>>> worked...I've tried googling and not really gotten anywhere. I'm >> running >>>> Drill 1.0.0. Any help would be greatly appreciated. >>>> Thanks, >>>> -Charles >>>> >>>> >>>> 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) >>>> >>>> employee_query = """SELECT position_title, COUNT( employee_id ) as >>>> employee_count >>>> FROM cp.`employee.json` >>>> GROUP BY position_title >>>> ORDER BY COUNT( employee_id ) DESC""" >>>> >>>> data = pd.read_sql( employee_query, conn ) >>>> >>>> >>>> Error: ('HY000', '[HY000] [MapR][Drill] (1040) Drill failed to execute >>>> the query: >>>> >>> >> ������������������������������\U000a0074�����������\U000a0060������������\n\n[30027]Query >>>> execution error. Details:[ \nPARSE ERROR: Lexical error at line 1, >>>> column 1. Encoun (1040) (SQLExecDirectW)') >>>> >>>> During handling of the above exception, another exception occurred: >>>> >>>> >>>> >>>> DatabaseError: Execution failed on sql 'SELECT position_title, COUNT( >>>> employee_id ) as employee_count >>>> FROM cp.`employee.json` >>>> GROUP BY position_title >>>> ': ('HY000', '[HY000] [MapR][Drill] (1040) Drill failed to execute the >>>> query: >>>> >>> >> ������������������������������\U000a0074�����������\U000a0060������������\n\n[30027]Query >>>> execution error. Details:[ \nPARSE ERROR: Lexical error at line 1, >>>> column 1. Encoun (1040) (SQLExecDirectW)') >>>> >>> >>
