Zach Amsden has posted comments on this change. Change subject: IMPALA-4729: Implement REPLACE() ......................................................................
Patch Set 9: Added support for saving StringSearcher for complicated queries. *********************************************************************************** [localhost:21000] > select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem; Query: select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem Query submitted at: 2017-02-01 03:21:19 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=a49fad015129539:afa30da00000000 +-----------------------------------------------------+ | count(regexp_replace(l_comment, 'complicated', '')) | +-----------------------------------------------------+ | 6001215 | +-----------------------------------------------------+ Fetched 1 row(s) in 7.55s [localhost:21000] > select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem; Query: select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem Query submitted at: 2017-02-01 03:21:31 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=3946a55a95c4529f:6739435000000000 +-----------------------------------------------------+ | count(regexp_replace(l_comment, 'complicated', '')) | +-----------------------------------------------------+ | 6001215 | +-----------------------------------------------------+ Fetched 1 row(s) in 1.54s [localhost:21000] > select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem; Query: select count(regexp_replace(l_comment, 'complicated', '')) from tpch.lineitem Query submitted at: 2017-02-01 03:21:35 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=3f41480452d08ce1:21ebac3500000000 +-----------------------------------------------------+ | count(regexp_replace(l_comment, 'complicated', '')) | +-----------------------------------------------------+ | 6001215 | +-----------------------------------------------------+ Fetched 1 row(s) in 1.53s [localhost:21000] > select count(replace(l_comment, 'complicated', '')) from tpch.lineitem; Query: select count(replace(l_comment, 'complicated', '')) from tpch.lineitem Query submitted at: 2017-02-01 03:21:44 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=d24d13228c8c8833:110700e300000000 +----------------------------------------------+ | count(replace(l_comment, 'complicated', '')) | +----------------------------------------------+ | 6001215 | +----------------------------------------------+ Fetched 1 row(s) in 1.33s [localhost:21000] > select count(replace(l_comment, 'complicated', '')) from tpch.lineitem; Query: select count(replace(l_comment, 'complicated', '')) from tpch.lineitem Query submitted at: 2017-02-01 03:21:48 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=ea4d6cd631e38ce2:75984bb600000000 -- To view, visit http://gerrit.cloudera.org:8080/5776 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: I1780a7d8fee6d0db9dad148217fb6eb10f773329 Gerrit-PatchSet: 9 Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-Owner: Zach Amsden <zams...@cloudera.com> Gerrit-Reviewer: Alex Behm <alex.b...@cloudera.com> Gerrit-Reviewer: Dan Hecht <dhe...@cloudera.com> Gerrit-Reviewer: Michael Ho <k...@cloudera.com> Gerrit-Reviewer: Tim Armstrong <tarmstr...@cloudera.com> Gerrit-Reviewer: Zach Amsden <zams...@cloudera.com> Gerrit-HasComments: No