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

Do not retrieve Materialized View definitions for rebuild if query is test SQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • None
    • None
    • Hive-3.1.2

    Description

      for the query like select 1, select current_timestamp, select current_date

      hive retrieve all the Materialized view from metastore, if the one of databases are too large then this call take lots of time, the situation becomes worse if there are too frequent if hive server receives frequent "select 1" query ( connection pool uses it to check if the connection is valid or not).

      Attachments

        1. HIVE-22630.patch
          1 kB
          Rajkumar Singh
        2. HIVE-22630.02.patch
          1 kB
          Rajkumar Singh
        3. HIVE-22630.01.patch
          1 kB
          Rajkumar Singh

        Activity

          People

            Rajkumar Singh Rajkumar Singh
            Rajkumar Singh Rajkumar Singh
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: