[jira] [Updated] (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 updated CARBONDATA-3794:
------------------------------------
    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.*

  was:
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.*

> 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
>
> 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)