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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chetan Bhat closed CARBONDATA-3794.
-----------------------------------
    Fix Version/s: 2.1.0
       Resolution: Fixed

The issue is resolved in Carbon 2.1.0 version.

0: jdbc:hive2://10.20.251.163:23040/default> show metacache;
+-------------+-------------------+---------------------+-----------------+
| Identifier | Table Index size | CgAndFg Index size | Cache Location |
+-------------+-------------------+---------------------+-----------------+
+-------------+-------------------+---------------------+-----------------+
No rows selected (7.059 seconds)
0: jdbc:hive2://10.20.251.163:23040/default> show metacache;
+-------------+-------------------+---------------------+-----------------+
| Identifier | Table Index size | CgAndFg Index size | Cache Location |
+-------------+-------------------+---------------------+-----------------+
+-------------+-------------------+---------------------+-----------------+
No rows selected (6.52 seconds)

> 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
>            Priority: Minor
>             Fix For: 2.1.0
>
>
> 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.*

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