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

JDBC DatabaseMetaData.getTables with large no of tables call leads to HS2 OOM

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
    • None
    • 1.3.0, 2.0.0
    • HiveServer2
    • None

    Description

      With around 7000 tables having around 1500 columns each, and 512MB of HS2 memory, I am able to reproduce this OOM .
      Most of the memory is consumed by the datanucleus objects.

      Reducing the number of tables for which metadata is fetched at a time via metastore get_multi_table limits the memory footprint.

      Attachments

        1. HIVE-11407-branch-1.0.patch
          7 kB
          Thejas Nair
        2. HIVE-11407.1.patch
          8 kB
          Thejas Nair

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-11959 add simple test case for TestTableIterable

        • Major - Major loss of function.
        • Closed

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

          People

            sushanth Sushanth Sowmyan Assign to me
            thejas Thejas Nair
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment