[ https://issues.apache.org/jira/browse/IMPALA-8096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763104#comment-16763104 ]
ASF subversion and git services commented on IMPALA-8096: --------------------------------------------------------- Commit 6601327af6088def7d880940a5712719fe46acb2 in impala's branch refs/heads/master from poojanilangekar [ https://gitbox.apache.org/repos/asf?p=impala.git;h=6601327 ] IMPALA-8096: Add rows produced limit per query This patch limits the number of rows produced by a query by tracking it at the PlanRootSink level. When the NUM_ROWS_PRODUCED_LIMIT is set, it cancels a query when its execution produces more rows than the specified limit. This limit only applies when the results are returned to a client, e.g. for a SELECT query, but not an INSERT query. Testing: Added tests to query-resource-limits.test to verify that the rows produced limit is honored. Manually tested on various combinations of tables, fileformats and ROWS_RETURNED_LIMIT values. Change-Id: I7b22dbe130a368f4be1f3662a559eb9aae7f0c1d Reviewed-on: http://gerrit.cloudera.org:8080/12328 Reviewed-by: Tim Armstrong <tarmstr...@cloudera.com> Tested-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com> > Limit on #rows returned from query > ---------------------------------- > > Key: IMPALA-8096 > URL: https://issues.apache.org/jira/browse/IMPALA-8096 > Project: IMPALA > Issue Type: Sub-task > Components: Backend > Reporter: Tim Armstrong > Assignee: Pooja Nilangekar > Priority: Major > Labels: resource-management > > Sometimes users accidentally run queries that return a large number of rows, > e.g. > {code} > SELECT * FROM table > {code} > When they really only need to look at a subset of the rows. It would be > useful to have a guardrail to fail queries the return more rows than a > particular limit. Maybe it would make sense to integrate with IMPALA-4268 so > that the query is failed when the buffer fills up, but it may also be useful > to have an easier-to-understand option based on #rows. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org