Re: Drill 1.8.0 Error: RESOURCE ERROR: Failed to create schema tree.

[Abhishek Girish]

Hi Kartik,

Can you take a look at the logs (or turn on verbose errors) and share the
relevant stack trace? Also what platform is this on?

-Abhishek

On Thu, Sep 15, 2016 at 4:26 PM, Kartik Bhatia  wrote:

> When I run the following
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 5;
> It gives me java expection with  Error: RESOURCE ERROR: Failed to create
> schema tree.
>
> ~~
> This e-mail message from State Compensation Insurance Fund and all
> attachments transmitted with it
> may be privileged or confidential and protected from disclosure. If you
> are not the intended recipient,
> you are hereby notified that any dissemination, distribution, copying, or
> taking any action based on it
> is strictly prohibited and may have legal consequences. If you have
> received this e-mail in error,
> please notify the sender by reply e-mail and destroy the original message
> and all copies.
> ~~
>

Drill 1.8.0 Error: RESOURCE ERROR: Failed to create schema tree.

[Kartik Bhatia]

When I run the following
0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 5;
It gives me java expection with  Error: RESOURCE ERROR: Failed to create schema 
tree.

~~
This e-mail message from State Compensation Insurance Fund and all attachments 
transmitted with it
may be privileged or confidential and protected from disclosure. If you are not 
the intended recipient,
you are hereby notified that any dissemination, distribution, copying, or 
taking any action based on it
is strictly prohibited and may have legal consequences. If you have received 
this e-mail in error, 
please notify the sender by reply e-mail and destroy the original message and 
all copies.
~~

Re: NULL values for DATE type columns using JDBC connector

[Khurram Faraaz]

This is related to DRILL-4842

On Wed, Sep 14, 2016 at 12:31 AM, Sudheesh Katkam 
wrote:

> Hi Dan,
>
> Per documentation , I
> don’t think sql4es is in the list of actively tested JDBC drivers. But a
> “WHERE something IS NOT NULL” returning NULL looks like a bug to me. Can
> you open a ticket ?
>
> Thank you,
> Sudheesh
>
> > On Sep 12, 2016, at 8:04 AM, Dan Markhasin  wrote:
> >
> > Hi all,
> >
> > I'm using Drill to query ElasticSearch using the sql4es driver (
> > https://github.com/Anchormen/sql4es) and I've run into an issue where
> Drill
> > returns NULL values for Date columns:
> >
> > 0: jdbc:drill:zk=local> select Date_01 from
> > ES23.`data-generator-poc-async`.arm where Date_01 IS NOT NULL limit 1;
> > +--+
> > | Date_01  |
> > +--+
> > | null |
> > +--+
> >
> > The DESCRIBE command returns the correct data type (DATE).
> >
> > Using other JDBC clients (Squirrel / WorkbenchJ) I am able to run the
> exact
> > same query on the exact source, and get the correct data (which is in the
> > form of 2016-03-21, for example).
> >
> > Any idea why it's returning null?
>
>

drill rest api converts all data types to string

[Niek Bartholomeus]

Hi,

I'm using the drill rest api to query my parquet files that were generated by 
spark.

I noticed that numeric and boolean data types are all converted to string in 
the results. Nested data however is returned with the original data types 
intact.

Probably this is happening here: 
https://github.com/apache/drill/blob/2d9f9abb4c47d08f8462599c8d6076a61a1708fe/exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/QueryWrapper.java#L158

Is there any way how to fix this?

I'm using the latest version of drill.

Thanks in advance,

Niek.