Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12586 Support for Performance regression test suite
  3. HIVE-11107

Support for Performance regression test suite with TPCDS

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.1.0
    • None
    • None

    Description

      Support to add TPCDS queries to the performance regression test suite with Hive CBO turned on.

      This benchmark is intended to make sure that subsequent changes to the optimizer or any hive code do not yield any unexpected plan changes. i.e. the intention is to not run the entire TPCDS query set, but just "explain plan" for the TPCDS queries.
      As part of this jira, we will manually verify that expected hive optimizations kick in for the queries (for given stats/dataset). If there is a difference in plan within this test suite due to a future commit, it needs to be analyzed and we need to make sure that it is not a regression.

      The test suite can be run in master branch from itests by

      mvn test -Dtest=TestPerfCliDriver 
      

      Attachments

        1. HIVE-11107.1.patch
          1.11 MB
          Hari Sankar Sivarama Subramaniyan
        2. HIVE-11107.2.patch
          13.23 MB
          Hari Sankar Sivarama Subramaniyan
        3. HIVE-11107.3.patch
          1.20 MB
          Hari Sankar Sivarama Subramaniyan
        4. HIVE-11107.4.patch
          1.20 MB
          Hari Sankar Sivarama Subramaniyan
        5. HIVE-11107.5.patch
          1.96 MB
          Hari Sankar Sivarama Subramaniyan
        6. HIVE-11107.6.patch
          1.97 MB
          Hari Sankar Sivarama Subramaniyan
        7. HIVE-11107.7.patch
          1.97 MB
          Hari Sankar Sivarama Subramaniyan
        8. HIVE-11107.8.patch
          1.87 MB
          Hari Sankar Sivarama Subramaniyan

        Activity

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

          People

            hsubramaniyan Hari Sankar Sivarama Subramaniyan Assign to me
            hsubramaniyan Hari Sankar Sivarama Subramaniyan
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment