Re: Querying Data with period in name

So, I added a comment on that JIRA... I have a parquet file, I need to explore it... it comes from another user, I want to be able to explore with select * but I don't know the field names... how can I do this? I know it seems like we should always know the column names, but I don't :) On Fri,

Re: Querying Data with period in name

Hi John, Fix for the DRILL-4264 should solve this issue. This error appears when you try to do *select **. But while DRILL-4264 is not fixed, you can try to do *select `**id.orig_h`*. It should

Querying Data with period in name

Hey all, I am querying some json and parquet data that has dots in the name. Not all the data I may be querying will come from Drill, thus dot is a valid character... when I go to initially explore my data, Drill throws the error below when I run a select * query. I understand the error, and I

Re: Non-ascii characters still fails on Drill 1.11

Thanks Arina, It worked after setting the property. Regards, Rahul On Fri, Aug 11, 2017 at 5:03 PM, Arina Yelchiyeva < arina.yelchiy...@gmail.com> wrote: > Hi Rahul, > > you need to update system property *saffron.default.charset* to *UTF-16LE*. > > Kind regards > Arina > > On Fri, Aug 11, 2017

Re: Non-ascii characters still fails on Drill 1.11

We need to add a unit test, the last comment in DRILL-4039 suggests that we add a unit test for that fix. Thanks, Khurram From: Arina Yelchiyeva Sent: Friday, August 11, 2017 5:03:44 PM To: user Subject: Re: Non-ascii characters

Re: Non-ascii characters still fails on Drill 1.11

Hi Rahul, you need to update system property *saffron.default.charset* to *UTF-16LE*. Kind regards Arina On Fri, Aug 11, 2017 at 9:18 AM, Rahul Raj wrote: > Issue persist even with JDBC driver 1.11.0. > > On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj

Re: Non-ascii characters still fails on Drill 1.11

Issue persist even with JDBC driver 1.11.0. On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj wrote: > I have not upgraded the drill client jar to 1.11. Will upgrade and confirm. > > Regards, > Rahul > > On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj

Re: Non-ascii characters still fails on Drill 1.11

I have not upgraded the drill client jar to 1.11. Will upgrade and confirm. Regards, Rahul On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj wrote: > Hi, > > https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It > failed on the following query