[ https://issues.apache.org/jira/browse/IMPALA-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16930989#comment-16930989 ]
Tim Armstrong commented on IMPALA-2579: --------------------------------------- IMPALA-8096 added the option for a limit. I don't think we want to have an implicit limit - clients should do that if they want it, but we're not really in the business of truncating result sets. > Limiting the number of records to be fetched/returned by default > ---------------------------------------------------------------- > > Key: IMPALA-2579 > URL: https://issues.apache.org/jira/browse/IMPALA-2579 > Project: IMPALA > Issue Type: Improvement > Components: Backend > Affects Versions: Impala 2.2.4 > Reporter: Eric Lin > Priority: Minor > > It would be nice to have a feature to limit the resultset to be returned back > to client side, either impala-shell or tableau or others. > This can be achieved by setting a default limit on the following: > 1) number of rows > 2) data size > This is particularly useful when dealing with tables that have millions or > billions of records (which is in most cases), and users usually forget to > manually LIMIT the result and it will either crash the client software or > have to end up manually killing the query. > Thanks -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org