impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zach Amsden (Code Review)" <ger...@cloudera.org>
Subject [Impala-ASF-CR] IMPALA-4729: Implement REPLACE()
Date Wed, 01 Feb 2017 03:28:04 GMT
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 <zamsden@cloudera.com>
Gerrit-Reviewer: Alex Behm <alex.behm@cloudera.com>
Gerrit-Reviewer: Dan Hecht <dhecht@cloudera.com>
Gerrit-Reviewer: Michael Ho <kwho@cloudera.com>
Gerrit-Reviewer: Tim Armstrong <tarmstrong@cloudera.com>
Gerrit-Reviewer: Zach Amsden <zamsden@cloudera.com>
Gerrit-HasComments: No

Mime
View raw message