[jira] [Commented] (DRILL-6050) Provide a limit to number of rows fetched for a query in UI

["Bridget Bevens (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-6050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16831300#comment-16831300 ] 

Bridget Bevens commented on DRILL-6050:
---------------------------------------

Hi [~kkhatua],

I added autoLimit to the Request Body example.

Thanks,
Bridget

> Provide a limit to number of rows fetched for a query in UI
> -----------------------------------------------------------
>
>                 Key: DRILL-6050
>                 URL: https://issues.apache.org/jira/browse/DRILL-6050
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Web Server
>            Reporter: Kunal Khatua
>            Assignee: Kunal Khatua
>            Priority: Minor
>              Labels: doc-complete, ready-to-commit, user-experience
>             Fix For: 1.16.0, 1.17.0
>
>
> Currently, the WebServer side needs to process the entire set of results and stream it back to the WebClient. 
> Since the WebUI does paginate results, we can load a larger set for pagination on the browser client and relieve pressure off the WebServer to host all the data.
> e.g. Fetching all rows from a 1Billion records table is impractical and can be capped at 10K. Currently, the user has to explicitly specify LIMIT in the submitted query. 
> An option can be provided in the field to allow for this entry.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)