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

HS2 materialized view registry init loading all tables from metastore

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0, 2.3.0
    • Fix Version/s: 3.0.0
    • Component/s: HiveServer2, Metastore
    • Labels:
      None
    • Environment:

      Hadoop 2.7.3 on EMR

      Description

      We're pointing the hive to a remote MySQL metastore with tons of DBs and tables (10k+ tables). When HS2 starts it tries to init the materialized views and currently the metastore API tries to do a full load for every database. It times out after 20 min then HS2 starts without loading MV.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                liusztc09 Songzhi Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: