You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Csaba Ringhofer (JIRA)" <ji...@apache.org> on 2018/07/09 16:46:00 UTC
[jira] [Commented] (IMPALA-1577) Improve from_utc_timestamp perf
which is unpredictable and slow
[ https://issues.apache.org/jira/browse/IMPALA-1577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16537222#comment-16537222 ]
Csaba Ringhofer commented on IMPALA-1577:
-----------------------------------------
IMPALA-3307 replaced the timezone implementation, which became generally faster and should be more consistent. The old implementation looked up timezone aliases much slower than canonical timezone names, while there shouldn't be any difference in the new one (many aliases were removed, while some were added to a map for fast lookups).
> Improve from_utc_timestamp perf which is unpredictable and slow
> ---------------------------------------------------------------
>
> Key: IMPALA-1577
> URL: https://issues.apache.org/jira/browse/IMPALA-1577
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.0
> Reporter: Skye Wanderman-Milne
> Priority: Minor
> Labels: performance
>
> The performance of from_utc_timestamp, besides being extremely poor compared to that of other builtin functions such as from_unixtime, depends greatly on the input timezone. Given that evaluating this function can dominate the total query time, it would be good to at least make its performance more consistent, and even better to improve its performance overall.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org