Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19481

Tablesample uses incorrect logic to pick files corresponding to buckets.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.1.0, 4.0.0-alpha-1
    • Hive
    • None

    Description

      Ran "mvn test -Dtest=TestMiniLlapLocalCliDriver -Dqfile=sample10.q " after changing the table to be
      insert-only transactional.

      The following queries returns couple of rows whereis no row results returns for non-ACID table.
      query: select ds, count(1) from srcpartbucket tablesample (bucket 2 out of 4 on key) where ds is not null group by ds ORDER BY ds ASC

      2008-04-08 14
      2008-04-09 14
      ..
      query: select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 on key) where ds is not null group by ds ORDER BY ds ASC

      2008-04-08 4
      2008-04-09 4

      Attachments

        1. HIVE-19481.4.patch
          84 kB
          Deepak Jaiswal
        2. HIVE-19481.3.patch
          84 kB
          Deepak Jaiswal
        3. HIVE-19481.2.patch
          26 kB
          Deepak Jaiswal
        4. HIVE-19481.1.patch
          26 kB
          Deepak Jaiswal
        5. HIVE-19481.01-branch-3.patch
          84 kB
          Deepak Jaiswal

        Issue Links

          Activity

            People

              djaiswal Deepak Jaiswal
              steveyeom2017 Steve Yeom
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: