[jira] [Created] (CARBONDATA-3794) show metacache command takes significantly more time 1st time when compared to 2nd time.

[Akash R Nilugal (Jira)]

Chetan Bhat created CARBONDATA-3794:
---------------------------------------

             Summary: show metacache command takes significantly more time 1st time when compared to 2nd time.
                 Key: CARBONDATA-3794
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3794
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 2.0.0
         Environment: Spark 2.3.2 compatible carbon
            Reporter: Chetan Bhat


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 metcshow 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.*



--
This message was sent by Atlassian Jira
(v8.3.4#803005)