Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3794

show metacache command takes significantly more time 1st time when compared to 2nd time.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 2.1.0
    • data-query
    • None
    • Spark 2.3.2 compatible carbon

    Description

      show metacache command takes significantly more time 1st time when compared to 2nd time.

      1st time

      0: jdbc:hive2://10.20.255.171:23040/show metacache;
      ---------------------------------------+------------------------------+-

      Identifier Index size Datamap size Cache Location

      ---------------------------------------+------------------------------+-

      TOTAL 745 B 0 B DRIVER
      1_6_1.uniqdata_comp_nosort 745 B 0 B DRIVER

      ---------------------------------------+------------------------------+-
      2 rows selected (8.233 seconds)

       

      2nd time
      0: jdbc:hive2://10.20.255.171:23040/default> show metacache;
      ---------------------------------------+------------------------------+-

      Identifier Index size Datamap size Cache Location

      ---------------------------------------+------------------------------+-

      TOTAL 745 B 0 B DRIVER
      1_6_1.uniqdata_comp_nosort 745 B 0 B DRIVER

      ---------------------------------------+------------------------------+-
      2 rows selected (1.46 seconds)

       

      Sometimes the 1st time show metacache takes upto 25 seconds compared to 3-4 seconds for 2nd time show metacache.

      Attachments

        Activity

          People

            Unassigned Unassigned
            chetdb Chetan Bhat
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: