Mihaly Szjatinya has uploaded a new patch set (#11). ( http://gerrit.cloudera.org:8080/21735 )
Change subject: IMPALA-7086: Cache timezone in *_utc_timestamp() ...................................................................... IMPALA-7086: Cache timezone in *_utc_timestamp() Added Prepare - Close routine around from/to_utc standard functions. This gives a consistent time improvement for constant timezones. Given sample table with 600M timestamp rows, on all-default environment the query below gives a stable 2-3 seconds improvement. SELECT count(*) FROM a_table where from_utc_timestamp(ts, "a_timezone") > "a_date"; Averaged results for Release, SET MT_OP=1, SET DISABLE_CODEGEN=TRUE: from_utc: 16,53s -> 12,53s to_utc: 14,02 - > 11,53 Change-Id: Icdf5ff82c5d0554333aef1bc3bba034a4cf48230 --- M be/src/exprs/timestamp-functions.cc M be/src/exprs/timestamp-functions.h M common/function-registry/impala_functions.py 3 files changed, 55 insertions(+), 22 deletions(-) git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/35/21735/11 -- To view, visit http://gerrit.cloudera.org:8080/21735 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: newpatchset Gerrit-Change-Id: Icdf5ff82c5d0554333aef1bc3bba034a4cf48230 Gerrit-Change-Number: 21735 Gerrit-PatchSet: 11 Gerrit-Owner: Mihaly Szjatinya <[email protected]> Gerrit-Reviewer: Csaba Ringhofer <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Mihaly Szjatinya <[email protected]> Gerrit-Reviewer: Peter Rozsa <[email protected]>
