Mykhailo Surnyk created DRILL-7818:
--------------------------------------
Summary: SplitPart (SPLIT_PART) UDF work correct only with one-row
data
Key: DRILL-7818
URL: https://issues.apache.org/jira/browse/DRILL-7818
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 1.18.0
Reporter: Mykhailo Surnyk
Fix For: 1.18.0
SPLIT_PART UDF from
[https://github.com/apache/drill/blob/eb63eadda9a7836d70513e10caec4664c42a1237/exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/StringFunctions.java#L389]
Don't work for the query that returns two or more rows, for example:
SELECT SPLIT_PART(A, ' ', 1) FROM (SELECT 'key1 value1' as A UNION SELECT 'key2
value2'
will throw an error, but
SELECT SPLIT_PART(A, ' ', 1) FROM (SELECT 'key1 value1' as A UNION SELECT 'key2
value2') limit 1
Will return the correct result.
It's reproducing also for real data without `union`, I add it's just for
example.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
