Consuming Returned Results

[Loubna Ghamlouche <lb...@gmail.com>]

Hi,

I have a quick question regarding Apache Drill.

All the tutorials and documentation show how to get the results in the
shell, but what I want to do is to make use of the returned query records
in some other processing, such as displaying it on an HTML page. I need to
get raw data and then feed it to a data grid which will be displayed on an
HTML page.

Could you please give me some advice?

Thanks

Loubna

Re: Consuming Returned Results

[Gautam Parai <gp...@mapr.com>]

Hi Loubna,


I tried a sample query which returns approximately 10,000 records and it works for me. I am not familiar with your use case but maybe using LIMIT/OFFSET to achieve pagination might help instead of requesting the entire data. I am assuming your data would not be constrained to 100K records.


Gautam

________________________________
From: Loubna Ghamlouche <lb...@gmail.com>
Sent: Saturday, November 4, 2017 2:58:46 AM
To: user@drill.apache.org
Subject: Re: Consuming Returned Results

I actually found the answer... It is using the REST APIs

But let us assume I have a text file with 100,000 records. Is it feasible
to run a query to fetch all the records in order to display them in an HTML
data grid?

On Sat, Nov 4, 2017 at 7:51 PM, Loubna Ghamlouche <lb...@gmail.com>
wrote:

> Hi,
>
> I have a quick question regarding Apache Drill.
>
> All the tutorials and documentation show how to get the results in the
> shell, but what I want to do is to make use of the returned query records
> in some other processing, such as displaying it on an HTML page. I need to
> get raw data and then feed it to a data grid which will be displayed on an
> HTML page.
>
> Could you please give me some advice?
>
> Thanks
>
> Loubna
>

Re: Consuming Returned Results

[Loubna Ghamlouche <lb...@gmail.com>]

I actually found the answer... It is using the REST APIs

But let us assume I have a text file with 100,000 records. Is it feasible
to run a query to fetch all the records in order to display them in an HTML
data grid?

On Sat, Nov 4, 2017 at 7:51 PM, Loubna Ghamlouche <lb...@gmail.com>
wrote:

> Hi,
>
> I have a quick question regarding Apache Drill.
>
> All the tutorials and documentation show how to get the results in the
> shell, but what I want to do is to make use of the returned query records
> in some other processing, such as displaying it on an HTML page. I need to
> get raw data and then feed it to a data grid which will be displayed on an
> HTML page.
>
> Could you please give me some advice?
>
> Thanks
>
> Loubna
>