drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navin Bhawsar <navin.bhaw...@gmail.com>
Subject Re: Suggestion needed for REST API JSON response format
Date Wed, 15 Apr 2020 05:57:34 GMT
Thanks Charles for your quick response.


We tried casting to float and decimal.
Current drill version used is 1.17.

Fyi ,these are parquet file generated using python.

Please let us know if you need more details.

Thanks,
Navin


On Tue, 14 Apr 2020, 20:27 Charles Givre, <cgivre@gmail.com> wrote:

> Hi Navin,
> Can you try the following query and see what happens?
>
> SELECT id, CAST(sales AS INT) AS sales, name ... FROM dfs.`sample*.parquet
>
> Also what version of Drill are you using?
> -- C
>
> > On Apr 14, 2020, at 10:55 AM, sreeparna bhabani <
> bhabani.sreeparna@gmail.com> wrote:
> >
> > Hi Team,
> >
> > We reach out to you for a specific help. I have given the details below.
> >
> > *Situation :*
> > We have a Web UI which calls Apache Drill Query using REST API. Please
> find
> > below the sample call where we are querying *Parquet** file*.
> >
> > curl -X POST -H "Content-Type: application/json" -d '{"queryType":"SQL",
> > "query": "select * from dfs.`sample*.parquet*`", "autoLimit":1}'
> > http://localhost:8047/query.json
> >
> > *Problem : *
> > The response JSON is successfully received (sample below). There are few
> > columns which are of type Number in Parquet file, e.g - "sales".
> > {
> >   "columns" : [ "id", "name", "sales", ......... ],
> >   "rows" : [ {
> >     "id" : "0001",
> >     "sales" : "65",
> >     "name" : "XYZ",
> >    ................
> >   } ]
> > }
> >
> > But we are getting the Number values in  "" like highlighted above, which
> > is creating problem in Web UI.
> >
> > *Expectation :*
> > We would need the same response with Number values without "", like
> below.
> > {
> >   "columns" : [ "id", "name", "sales", ......... ],
> >   "rows" : [ {
> >     "id" : "0001",
> >     "sales" : 65,
> >     "name" : "XYZ",
> >    ................
> >   } ]
> > }
> >
> > Please suggest us how to resolve the same.
> >
> > Thanks in advance for your assistance.
> >
> > *Sreeparna Bhabani*
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message