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