Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6032 Configuration knobs to automatically reject and fail queries
  3. IMPALA-8096

Limit on #rows returned from query

    XMLWordPrintableJSON

Details

    • ghx-label-9

    Description

      Sometimes users accidentally run queries that return a large number of rows, e.g.

      SELECT * FROM table

      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.

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-5550 Session level SET LIMIT in ODBC/JDBC connections

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-2579 Limiting the number of records to be fetched/returned by default

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Activity

            People

              poojanilangekar Pooja Nilangekar
              tarmstrong Tim Armstrong
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: