lwz9103 opened a new issue, #7747: URL: https://github.com/apache/incubator-gluten/issues/7747
### Backend CH (ClickHouse) ### Bug description Run CI in Arm, test 'function murmur3hash' *** FAILED *** details see https://opencicd.kyligence.com/job/gluten/job/gluten-ci-arm/39/ ### Spark version None ### Spark configurations _No response_ ### System information _No response_ ### Relevant logs ```bash [2024-10-24T10:46:57.046Z] - test 'function murmur3hash' *** FAILED *** [2024-10-24T10:46:57.046Z] Results do not match for query: [2024-10-24T10:46:57.046Z] Timezone: sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]] [2024-10-24T10:46:57.046Z] Timezone Env: [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Parsed Logical Plan == [2024-10-24T10:46:57.046Z] 'Project [unresolvedalias('hash(cast('id as int)), None), unresolvedalias('hash(cast('id as tinyint)), None), unresolvedalias('hash(cast('id as smallint)), None), unresolvedalias('hash(cast('id as bigint)), None), unresolvedalias('hash(cast('id as float)), None), unresolvedalias('hash(cast('id as double)), None), unresolvedalias('hash(cast('id as string)), None), unresolvedalias('hash(cast('id as binary)), None), unresolvedalias('hash(cast('from_unixtime('id) as date)), None), unresolvedalias('hash(cast('from_unixtime('id) as timestamp)), None), unresolvedalias('hash(cast('id as decimal(5,2))), None), unresolvedalias('hash(cast('id as decimal(10,2))), None), unresolvedalias('hash(cast('id as decimal(30,2))), None)] [2024-10-24T10:46:57.046Z] +- 'UnresolvedTableValuedFunction range, [10] [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Analyzed Logical Plan == [2024-10-24T10:46:57.046Z] hash(CAST(id AS INT)): int, hash(CAST(id AS TINYINT)): int, hash(CAST(id AS SMALLINT)): int, hash(CAST(id AS BIGINT)): int, hash(CAST(id AS FLOAT)): int, hash(CAST(id AS DOUBLE)): int, hash(CAST(id AS STRING)): int, hash(CAST(id AS BINARY)): int, hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS DATE)): int, hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS TIMESTAMP)): int, hash(CAST(id AS DECIMAL(5,2))): int, hash(CAST(id AS DECIMAL(10,2))): int, hash(CAST(id AS DECIMAL(30,2))): int [2024-10-24T10:46:57.046Z] Project [hash(cast(id#125622L as int), 42) AS hash(CAST(id AS INT))#125623, hash(cast(id#125622L as tinyint), 42) AS hash(CAST(id AS TINYINT))#125624, hash(cast(id#125622L as smallint), 42) AS hash(CAST(id AS SMALLINT))#125625, hash(cast(id#125622L as bigint), 42) AS hash(CAST(id AS BIGINT))#125626, hash(cast(id#125622L as float), 42) AS hash(CAST(id AS FLOAT))#125627, hash(cast(id#125622L as double), 42) AS hash(CAST(id AS DOUBLE))#125628, hash(cast(id#125622L as string), 42) AS hash(CAST(id AS STRING))#125629, hash(cast(id#125622L as binary), 42) AS hash(CAST(id AS BINARY))#125630, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as date), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS DATE))#125634, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as timestamp), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS TIMESTAMP))#125635, hash(cast(id#125622L as decim al(5,2)), 42) AS hash(CAST(id AS DECIMAL(5,2)))#125631, hash(cast(id#125622L as decimal(10,2)), 42) AS hash(CAST(id AS DECIMAL(10,2)))#125632, hash(cast(id#125622L as decimal(30,2)), 42) AS hash(CAST(id AS DECIMAL(30,2)))#125633] [2024-10-24T10:46:57.046Z] +- Range (0, 10, step=1, splits=None) [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Optimized Logical Plan == [2024-10-24T10:46:57.046Z] Project [hash(cast(id#125622L as int), 42) AS hash(CAST(id AS INT))#125623, hash(cast(id#125622L as tinyint), 42) AS hash(CAST(id AS TINYINT))#125624, hash(cast(id#125622L as smallint), 42) AS hash(CAST(id AS SMALLINT))#125625, hash(id#125622L, 42) AS hash(CAST(id AS BIGINT))#125626, hash(cast(id#125622L as float), 42) AS hash(CAST(id AS FLOAT))#125627, hash(cast(id#125622L as double), 42) AS hash(CAST(id AS DOUBLE))#125628, hash(cast(id#125622L as string), 42) AS hash(CAST(id AS STRING))#125629, hash(cast(id#125622L as binary), 42) AS hash(CAST(id AS BINARY))#125630, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as date), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS DATE))#125634, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as timestamp), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS TIMESTAMP))#125635, hash(cast(id#125622L as decimal(5,2)), 42) AS hash(CAST(id AS DECIMAL(5,2)))#125631, hash(cast(id#125622L as decimal(10,2)), 42) AS hash(CAST(id AS DECIMAL(10,2)))#125632, hash(cast(id#125622L as decimal(30,2)), 42) AS hash(CAST(id AS DECIMAL(30,2)))#125633] [2024-10-24T10:46:57.046Z] +- Range (0, 10, step=1, splits=None) [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Physical Plan == [2024-10-24T10:46:57.046Z] CHNativeColumnarToRow [2024-10-24T10:46:57.046Z] +- ^(9280) ProjectExecTransformer [hash(cast(id#125622L as int), 42) AS hash(CAST(id AS INT))#125623, hash(cast(id#125622L as tinyint), 42) AS hash(CAST(id AS TINYINT))#125624, hash(cast(id#125622L as smallint), 42) AS hash(CAST(id AS SMALLINT))#125625, hash(id#125622L, 42) AS hash(CAST(id AS BIGINT))#125626, hash(cast(id#125622L as float), 42) AS hash(CAST(id AS FLOAT))#125627, hash(cast(id#125622L as double), 42) AS hash(CAST(id AS DOUBLE))#125628, hash(cast(id#125622L as string), 42) AS hash(CAST(id AS STRING))#125629, hash(cast(id#125622L as binary), 42) AS hash(CAST(id AS BINARY))#125630, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as date), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS DATE))#125634, hash(cast(from_unixtime(id#125622L, yyyy-MM-dd HH:mm:ss, Some(America/Los_Angeles)) as timestamp), 42) AS hash(CAST(from_unixtime(id, yyyy-MM-dd HH:mm:ss) AS TIMESTAMP))#125635, hash(cast(id#125622 L as decimal(5,2)), 42) AS hash(CAST(id AS DECIMAL(5,2)))#125631, hash(cast(id#125622L as decimal(10,2)), 42) AS hash(CAST(id AS DECIMAL(10,2)))#125632, hash(cast(id#125622L as decimal(30,2)), 42) AS hash(CAST(id AS DECIMAL(30,2)))#125633] [2024-10-24T10:46:57.046Z] +- ^(9280) InputIteratorTransformer[id#125622L] [2024-10-24T10:46:57.046Z] +- RowToCHNativeColumnar [2024-10-24T10:46:57.046Z] +- *(1) Range (0, 10, step=1, splits=1) [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Results == [2024-10-24T10:46:57.046Z] [2024-10-24T10:46:57.046Z] == Results == [2024-10-24T10:46:57.046Z] !== Correct Answer - 10 == == Gluten Answer - 10 == [-132918897,-132918897,-132918897,-1131184084,-1123866089,-499264197,-1276280174,649883605,-1604776387,282763531,-1089980508,-1089980508,-1263804949] [-132918897,-132918897,-132918897,-1131184084,-1123866089,-499264197,-1276280174,649883605,-1604776387,282763531,-1089980508,-1089980508,-1263804949] ![-1731921111,-1731921111,-1731921111,1504843649,762527407,1012870987,541481139,1388151078,-1604776387,-1307687984,1212240468,1212240468,1824560402] [-1731921111,-1731921111,-1731921111,1504843649,762527407,1012870987,541481139,1388151078,-1604776387,-1307687984,1212240468,1212240468,-1863157295] [-1823081949,-1823081949,-1823081949,519220707,1710391653,1075969934,-1756013582,554525355,-1604776387,952455223,1819572976,1819572976,1581608557] [-1823081949,-1823081949,-1823081949,519220707,1710391653,1075969934,-1756013582,554525355,-1604776387,952455223,1819572976,1819572976,1581608557] [-331964951,-331964951,-331964951,-1767354555,1129458705,1704030368,-1929623325,-1316527394,-1604776387,-1295729983,-919574981,-919574981,2124045356] [-331964951,-331964951,-331964951,-1767354555,1129458705,1704030368,-1929623325,-1316527394,-1604776387,-1295729983,-919574981,-919574981,2124045356] ![-397064898,-397064898,-397064898,1344313940,-1959694433,1290556682,-2142269034,2010742256,-1604776387,-1549854286,-882757274,-882757274,-1133619383] [-397064898,-397064898,-397064898,1344313940,-1959694433,1290556682,-2142269034,2010742256,-1604776387,-1549854286,-882757274,-882757274,1515341057] [-559580957,-559580957,-559580957,-1712319331,-466301895,-460888942,1625004744,-177065843,-1604776387,-1715802514,1114849490,1114849490,-295670906] [-559580957,-559580957,-559580957,-1712319331,-466301895,-460888942,1625004744,-177065843,-1604776387,-1715802514,1114849490,1114849490,-295670906] ![1023896466,1023896466,1023896466,1607884268,653702210,151384375,135093849,602507139,-1604776387,-111824516,160318277,160318277,1223719165] [1023896466,1023896466,1023896466,1607884268,653702210,151384375,135093849,602507139,-1604776387,-111824516,160318277,160318277,-904048404] ![1079293707,1079293707,1079293707,1293116811,2056262044,-1537739192,141897003,267617753,-1604776387,-2064988289,478190634,478190634,-349302160] [1079293707,1079293707,1079293707,1293116811,2056262044,-1537739192,141897003,267617753,-1604776387,-2064988289,478190634,478190634,1352580272] ![1765031574,1765031574,1765031574,-797927272,1199227445,-2030303457,870267989,193033801,-1604776387,1720521376,2103279312,2103279312,-424716282] [1765031574,1765031574,1765031574,-797927272,1199227445,-2030303457,870267989,193033801,-1604776387,1720521376,2103279312,2103279312,-970558394] [933211791,933211791,933211791,-1670924195,933211791,-1670924195,735846435,-1670924195,-1604776387,-1670924195,-1670924195,-1670924195,-783713497] [933211791,933211791,933211791,-1670924195,933211791,-1670924195,735846435,-1670924195,-1604776387,-1670924195,-1670924195,-1670924195,-783713497] ``` -- 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]
