zhanglistar opened a new issue, #8723:
URL: https://github.com/apache/incubator-gluten/issues/8723
### Backend
CH (ClickHouse)
### Bug description
[Expected behavior] and [actual behavior].
Reproduce SQL:
```
create table t (full_user_agent string);
insert into t values(NULL);
select slice(split(full_user_agent, ';'), 2, size(split(full_user_agent,
';'))) AS finge from t;
```
Crash info:
```
Error: org.apache.hive.service.cli.HiveSQLException: Error running query:
org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in
stage 211.0 failed 1 times, most recent failure: Lost task 0.0 in stage 211.0
(TID 1828) (202.168.115.34 executor driver):
org.apache.gluten.exception.GlutenException:
org.apache.gluten.exception.GlutenException: Unexpected value for length: while
executing 'FUNCTION
throwIf(less(ifNull(length(splitByRegexpSpark(;_1423,full_user_agent,-1_1424)),1844674407_1427),0_1428)
: 2, Unexpected_1430 :: 5) ->
throwIf(less(ifNull(length(splitByRegexpSpark(;_1423,full_user_agent,-1_1424)),1844674407_1427),0_1428),Unexpected_1430)
UInt8 : 3'
0. ? @ 0x00007f97c740b6b2
1. ? @ 0x00007f97bda262b9
2. ? @ 0x00007f97bb982b2c
3. ? @ 0x00007f97bb9810d0
4. ? @ 0x00007f97c0a02cfa
5. ? @ 0x00007f97c09fdc32
6. ? @ 0x00007f97c09fedb0
7. ? @ 0x00007f97c09ffe75
8. ? @ 0x00007f97c1db4841
9. ? @ 0x00007f97c41700ac
10. ? @ 0x00007f97bde493f3
11. ? @ 0x00007f97c3eb834f
12. ? @ 0x00007f97c3ed5481
13. ? @ 0x00007f97c3ec91a5
14. ? @ 0x00007f97c3ec8cdd
15. ? @ 0x00007f97c3edaaf4
16. ? @ 0x00007f97c3edac59
17. ? @ 0x00007f97bde1ae11
18. ? @ 0x00007f97b74bd9b7
at
org.apache.gluten.iterator.ClosableIterator.hasNext(ClosableIterator.java:41)
at
org.apache.gluten.backendsapi.clickhouse.CollectMetricIterator.hasNext(CHIteratorApi.scala:341)
at
org.apache.gluten.vectorized.CloseableCHColumnBatchIterator.$anonfun$hasNext$1(CloseableCHColumnBatchIterator.scala:42)
at
scala.runtime.java8.JFunction0$mcZ$sp.apply(JFunction0$mcZ$sp.java:23)
at
org.apache.gluten.metrics.GlutenTimeMetric$.withNanoTime(GlutenTimeMetric.scala:41)
at
org.apache.gluten.vectorized.CloseableCHColumnBatchIterator.hasNext(CloseableCHColumnBatchIterator.scala:42)
at
org.apache.spark.InterruptibleIterator.hasNext(InterruptibleIterator.scala:37)
at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:491)
at
org.apache.spark.sql.execution.SparkPlan.$anonfun$getByteArrayRdd$1(SparkPlan.scala:364)
at
org.apache.spark.rdd.RDD.$anonfun$mapPartitionsInternal$2(RDD.scala:890)
at
org.apache.spark.rdd.RDD.$anonfun$mapPartitionsInternal$2$adapted(RDD.scala:890)
at
org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:52)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:365)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:329)
at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)
at org.apache.spark.scheduler.Task.run(Task.scala:136)
at
org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:548)
at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1504)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:551)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
```
### Spark version
Spark-3.3.x
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
```bash
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]