[jira] [Commented] (LENS-1332) Fetching large set of queries from Lens state store shouldn't allowed

["Puneet Gupta (JIRA)" <ji...@apache.org>]

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

Puneet Gupta commented on LENS-1332:
------------------------------------

Can we cap the number of rows returned by this REST API.
If the cap is 1000 rows, we can add 1001 as limit in the SQL query and If we indeed get 1001 rows we can either fail this REST call with appropriate message or we can choose to return 1000 rows and indicate partial result.


> Fetching large set of queries from Lens state store shouldn't allowed
> ---------------------------------------------------------------------
>
>                 Key: LENS-1332
>                 URL: https://issues.apache.org/jira/browse/LENS-1332
>             Project: Apache Lens
>          Issue Type: Improvement
>    Affects Versions: 2.7
>            Reporter: Srikanth Sundarrajan
>            Assignee: Srikanth Sundarrajan
>             Fix For: 2.7
>
>
> Currently when we query the Lens server to get a list of queries, it can result in a deluge of results if appropriate and sane filters aren't applied (particularly for finished queries). The proposal is to apply restrictions on the filter conditions being used.
> For ex:
> * One of user name, query name should be present if time & status filters aren't applied
> * If only time filter is present, it can't exceed (say 3 months)
> * If status before queried is exclusively unfinished queries, these restrictions need not apply



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)