You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Chetan Bhat (Jira)" <ji...@apache.org> on 2020/10/07 09:12:00 UTC
[jira] [Closed] (CARBONDATA-3794) show metacache command takes
significantly more time 1st time when compared to 2nd time.
[ 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)