acvictor opened a new issue, #8108:
URL: https://github.com/apache/incubator-gluten/issues/8108

   ### Backend
   
   VL (Velox)
   
   ### Bug description
   
   ```
   val data = Seq(("1234567"), ("000A1234"), ("ABCDE0")) 
   val df = spark.createDataFrame(data.map(Tuple1(_))).toDF("value") 
   
df.write.format("parquet").mode("overwrite").save("file:///home/a/src/sparklocal/tbl)
 
   
spark.read.format("parquet").load("file:///home/a/src/sparklocal/wrong").createOrReplaceTempView("tbl")
 
   val df = sql("select try_cast(value as bigint) from tbl") 
   ```
   Returns
   ```
   E1126 15:27:22.105729 44701 CastExpr-inl.h:43] Cannot cast VARCHAR 
'000A1234' to BIGINT. Encountered a non-digit character 
   I1126 15:27:22.106130 44701 Task.cpp:1879] Terminating task 
Gluten_Stage_2_TID_2_VTID_1 with state Failed after running for 5 ms. 
   I1126 15:27:22.106395 44701 Task.cpp:1136] All drivers (1) finished for task 
Gluten_Stage_2_TID_2_VTID_1 after running for 5 ms. 
   24/11/26 15:27:22 ERROR TaskResources: Task 2 failed by error: 
org.apache.gluten.exception.GlutenException: 
org.apache.gluten.exception.GlutenException: 
   Exception: VeloxUserError 
   Error Source: USER 
   Error Code: INVALID_ARGUMENT 
   Reason: Cannot cast VARCHAR '000A1234' to BIGINT. Encountered a non-digit 
character 
   Retriable: False 
   Context: Top-level 
   Expression: cast((trim(  
                

:VARCHAR, n0_0)) as BIGINT) 
   ```
   While Spark returns Array([1234567], [null], [null])
   
   ### Spark version
   
   Spark-3.5.x
   
   ### Spark configurations
   
   _No response_
   
   ### System information
   
   _No response_
   
   ### Relevant logs
   
   _No response_


-- 
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]

Reply via email to