MrFireChow opened a new issue, #13533:
URL: https://github.com/apache/gluten/issues/13533
### Backend
VL (Velox)
### Bug description
gluten 1.7.0 run on centos7 meet this error：
Error Source: USER
Error Code: INVALID_ARGUMENT
Reason: session 'session_timezone' set with invalid value 'Asia/Shanghai'
Retriable: False
Expression: tz::getTimeZoneID(*tz, false) != -1
Function: validateConfig
File:
/home/ubuntu/Gluten/ep/build-velox/build/velox_ep/velox/core/QueryConfig.cpp
Line: 281
```
**Test sql：
use catalog iceberg;
create database testdb1;
use testdb1;
CREATE EXTERNAL TABLE IF NOT EXISTS testtb (
report_time TIMESTAMP_NTZ,
imsi STRING,
msisdn STRING,
voicescenario INT,
cell STRING,
source_ne_type INT,
target_ne_type INT,
call_side INT,
alerting_time BIGINT,
answer_time BIGINT,
usercause_invite INT,
call_fail_end INT,
proceduretype INT,
interface INT,
servicetype INT
)
using iceberg
PARTITIONED BY (reportdate string, reporthour string)
LOCATION '/spark/testdb1/testtb';
INSERT INTO testtb
PARTITION (reportdate='2026-04-17', reporthour='06')
VALUES
(TIMESTAMP_NTZ '2026-04-17 06:10:30', '460001234567890', '13800138000', 1,
'cell_001', 15, 16, 1, 1000, 2000, 0, 0, 5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:15:20', '460001234567890', '13800138000', 1,
'cell_001', 15, 16, 1, 0, 2500, 0, 0, 5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:20:10', '460001234567891', '13800138001', 2,
'cell_002', 15, 16, 1, 0, 0, 1, 0, 5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:25:50', '460001234567891', '13800138001', 2,
'cell_002', 15, 16, 1, 0, 3000, 0, 100,5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:30:40', '460001234567892', '13800138002', 4,
'cell_003', 16, 15, 2, 1200,2200,0,0,5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:35:30', '460001234567892', '13800138002', 4,
'cell_003', 16, 15, 2, 0, 0, 1, 0,5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:40:20', '460001234567893', '13800138003', 1,
'cell_004', 16, 15, 2, 0,2800,0,200,5,14,1),
(TIMESTAMP_NTZ '2026-04-17 06:45:10', '460001234567893', '13800138003', 1,
'cell_004', 15, 16, 1, 0, 0, 0,255,5,14,1);
SELECT
date_trunc('hour', report_time) as clttime,
imsi, msisdn, voicescenario, cell,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 THEN 1 END) as
imsvoicemocallsetuprequesttimes,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 AND (alerting_time>0 OR
answer_time>0) THEN 1 END) as imsvoicemocallsetupsuccesstimes,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 AND alerting_time=0 AND
answer_time=0 THEN 1 END) as imsvoicemocallsetupfailuretimes,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 AND alerting_time=0 AND
answer_time=0 AND usercause_invite=1 THEN 1 END) as
imsvoicemocallsetupuserfailuretimes,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 THEN 1 END) as
imsvoicemtcallsetuprequesttimes,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 AND (alerting_time>0 OR
answer_time>0) THEN 1 END) as imsvoicemtcallsetupsuccesstimes,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 AND alerting_time=0 AND
answer_time=0 THEN 1 END) as imsvoicemtcallsetupfailuretimes,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 AND alerting_time=0 AND
answer_time=0 AND usercause_invite=1 THEN 1 END) as
imsvoicemtcallsetupuserfailuretimes,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 AND answer_time>0 THEN 1
END) as imsvoicemocallanswertimes,
COUNT(CASE WHEN source_ne_type=15 AND call_side=1 AND answer_time>0 AND
call_fail_end !=255 THEN 1 END) as imsvoicemocalldroptimesmw,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 AND answer_time>0 THEN 1
END) as imsvoicemtcallanswertimes,
COUNT(CASE WHEN target_ne_type=15 AND call_side=2 AND answer_time>0 AND
call_fail_end !=255 THEN 1 END) as imsvoicemtcalldroptimesmw
FROM fact_sip_if2_cpo
WHERE reportdate='2026-04-17' AND reporthour='06'
AND voicescenario IN (1,2,4) AND proceduretype=5 AND interface=14
AND ((source_ne_type=15 AND call_side=1) or (target_ne_type=15 AND
call_side=2))
AND servicetype=1
GROUP BY
date_trunc('hour', report_time),
voicescenario, cell, imsi, msisdn;**
```
system info
OS: CentOS 7
Backend: Velox
Gluten: 1.7.0
Spark: 3.4.1
JDK: 21
### Gluten version
_No response_
### Spark version
_No response_
### 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]
