Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2581

Push down LIMIT past DISTINCT

    XMLWordPrintableJSON

Details

    Description

      In a table t with a column x with no null values, "SELECT DISTINCT x FROM t LIMIT 1" should be roughly instant. Instead, it finds all the distinct values, then returns one of them.

      Attachments

        Activity

          People

            liuyao liuyao
            jbapple Jim Apple
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: