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

Tablesample uses incorrect logic to pick files corresponding to buckets.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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.01-branch-3.patch
          84 kB
          Deepak Jaiswal
        2. HIVE-19481.1.patch
          26 kB
          Deepak Jaiswal
        3. HIVE-19481.2.patch
          26 kB
          Deepak Jaiswal
        4. HIVE-19481.3.patch
          84 kB
          Deepak Jaiswal
        5. HIVE-19481.4.patch
          84 kB
          Deepak Jaiswal

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment