Mailing-List: contact reviews-help@impala.incubator.apache.org; run by ezmlm
Precedence: bulk
Message-Id: <201705182128.v4ILS1el020488@ip-10-146-233-104.ec2.internal>
Date: Thu, 18 May 2017 21:28:01 +0000
From: "John Russell (Code Review)" <gerrit@cloudera.org>
To: impala-cr@cloudera.com, reviews@impala.incubator.apache.org
CC: Jim Apple <jbapple-impala@apache.org>, zi+zicl@cloudera.com,
        Michael Brown <mikeb@cloudera.com>,
        Zoltan Ivanfi <zi+gerrit@cloudera.com>
Reply-To: jrussell@cloudera.com
Subject: =?UTF-8?Q?=5BImpala-ASF-CR=5D_IMPALA-3973=3A_optional_3rd_and_4th_arguments_for_instr=28=29=2E=0A?=
In-Reply-To: <gerrit.1483468973000.I17268bdb480230938f94559fe1eabe34ac2448b7@gerrit.cloudera.org>
References: <gerrit.1483468973000.I17268bdb480230938f94559fe1eabe34ac2448b7@gerrit.cloudera.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
User-Agent: Gerrit/2.12.7
archived-at: Thu, 18 May 2017 21:28:06 -0000

John Russell has posted comments on this change.

Change subject: IMPALA-3973: optional 3rd and 4th arguments for instr().
......................................................................


Patch Set 2:

(2 comments)

Added one example that had gotten lost from previous patch set. Clarified one other example that used 2 negative arguments; wasn't clear which negative arg was causing the behavior shown in the example.

http://gerrit.cloudera.org:8080/#/c/5589/2/docs/topics/impala_string_functions.xml
File docs/topics/impala_string_functions.xml:

PS2, Line 335: 1
> What line? I don't see it.
From patch set 5 (note "or zero" text and first example with final param 0):

The fourth argument cannot be negative or zero. A non-positive value for this argument causes an error:


select instr('foo bar bletch', 'b', 1, 0);
ERROR: UDF ERROR: Invalid occurrence parameter to instr function: 0

select instr('aaaaaaaaa','aa',-1,-1);
ERROR: UDF ERROR: Invalid occurrence parameter to instr function: -1

I was mistaken in original reply thinking that the 0 would be accepted and give a 0 return value.

I will change the -1,-1 final 2 args of the second example above to 1,-1 to make it clear which negative arg is causing the error.


Line 406: select instr('hello world','o',-1);
> What line is the negative position argument and an occurence argument on? 4
Line 413 of patch set 6. I included it in the examples for the occurrence argument because otherwise the meaning of that final argument hadn't been explained.


-- 
To view, visit http://gerrit.cloudera.org:8080/5589
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-MessageType: comment
Gerrit-Change-Id: I17268bdb480230938f94559fe1eabe34ac2448b7
Gerrit-PatchSet: 2
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-Owner: John Russell <jrussell@cloudera.com>
Gerrit-Reviewer: Jim Apple <jbapple-impala@apache.org>
Gerrit-Reviewer: John Russell <jrussell@cloudera.com>
Gerrit-Reviewer: Michael Brown <mikeb@cloudera.com>
Gerrit-Reviewer: Zoltan Ivanfi <zi+gerrit@cloudera.com>
Gerrit-Reviewer: zi+zicl@cloudera.com
Gerrit-HasComments: Yes