Re: drill rest api converts all data types to string

[Niek Bartholomeus]

Hi Sudheesh,

Thanks for confirming this is a bug. I logged in to the Drill jira project but 
it looks like I only got read only access. Any idea how I get permission to 
raise issues?

Thanks,

Niek.

> On 16 Sep 2016, at 20:25, Sudheesh Katkam  wrote:
> 
> This is different.
> 
>> Nested data however is returned with the original data types intact.
> 
> .. which makes sense, looking at the code.
> 
> Thank you,
> Sudheesh
> 
>> On Sep 16, 2016, at 11:18 AM, Jacques Nadeau  wrote:
>> 
>> FYI, it is already filed: https://issues.apache.org/jira/browse/DRILL-2373
>> 
>> --
>> Jacques Nadeau
>> CTO and Co-Founder, Dremio
>> 
>> On Fri, Sep 16, 2016 at 8:56 AM, Sudheesh Katkam 
>> wrote:
>> 
>>> Hi Niek,
>>> 
>>> That is a bug; thank you for digging out the exact location. Please open a
>>> ticket . Let’s start
>>> tracking the details of the fix in that ticket.
>>> 
>>> Thank you,
>>> Sudheesh
>>> 
 On Sep 15, 2016, at 2:49 AM, Niek Bartholomeus 
>>> wrote:
 
 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.
>>> 
>>> 
> 

Re: drill rest api converts all data types to string

[Sudheesh Katkam]

This is different.

> Nested data however is returned with the original data types intact.

.. which makes sense, looking at the code.

Thank you,
Sudheesh

> On Sep 16, 2016, at 11:18 AM, Jacques Nadeau  wrote:
> 
> FYI, it is already filed: https://issues.apache.org/jira/browse/DRILL-2373
> 
> --
> Jacques Nadeau
> CTO and Co-Founder, Dremio
> 
> On Fri, Sep 16, 2016 at 8:56 AM, Sudheesh Katkam 
> wrote:
> 
>> Hi Niek,
>> 
>> That is a bug; thank you for digging out the exact location. Please open a
>> ticket . Let’s start
>> tracking the details of the fix in that ticket.
>> 
>> Thank you,
>> Sudheesh
>> 
>>> On Sep 15, 2016, at 2:49 AM, Niek Bartholomeus 
>> wrote:
>>> 
>>> 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.
>> 
>> 

Re: drill rest api converts all data types to string

[Jacques Nadeau]

FYI, it is already filed: https://issues.apache.org/jira/browse/DRILL-2373

--
Jacques Nadeau
CTO and Co-Founder, Dremio

On Fri, Sep 16, 2016 at 8:56 AM, Sudheesh Katkam 
wrote:

> Hi Niek,
>
> That is a bug; thank you for digging out the exact location. Please open a
> ticket . Let’s start
> tracking the details of the fix in that ticket.
>
> Thank you,
> Sudheesh
>
> > On Sep 15, 2016, at 2:49 AM, Niek Bartholomeus 
> wrote:
> >
> > 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.
>
>

Re: drill rest api converts all data types to string

[Sudheesh Katkam]

Hi Niek,

That is a bug; thank you for digging out the exact location. Please open a 
ticket . Let’s start tracking the 
details of the fix in that ticket.

Thank you,
Sudheesh

> On Sep 15, 2016, at 2:49 AM, Niek Bartholomeus  wrote:
> 
> 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.