[
https://issues.apache.org/jira/browse/IMPALA-14844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18066978#comment-18066978
]
Quanlong Huang commented on IMPALA-14844:
-----------------------------------------
Rerun of the same job passed:
[https://jenkins.impala.io/job/ubuntu-20.04-dockerised-tests/4849/]
So this might be a flaky issue. Maybe some recent changes on binary data type
or complex types are related. CC [~csringhofer] , [~prozsa]
> TestNestedTypesStarExpansion.test_star_expansion fails in struct result
> -----------------------------------------------------------------------
>
> Key: IMPALA-14844
> URL: https://issues.apache.org/jira/browse/IMPALA-14844
> Project: IMPALA
> Issue Type: Bug
> Reporter: Quanlong Huang
> Priority: Critical
>
> TestNestedTypesStarExpansion.test_star_expansion fails in the following query
> {code:sql}
> select t1.id, *
> from complextypes_structs t1, complextypes_structs t2
> where t1.id = t2.id and t1.id = 4;{code}
> [https://jenkins.impala.io/job/ubuntu-20.04-dockerised-tests/4847]
> {code:java}
> query_test.test_nested_types.TestNestedTypesStarExpansion.test_star_expansion["table_format:
> parquet/none" | "protocol: hs2" | "exec_option: {'disable_codegen': 'False',
> 'convert_legacy_hive_parquet_utc_timestamps': 'true', 'timezone':
> '"Europe/Budapest"'}"]{code}
> The expected and actual results:
> {noformat}
> -- 2026-03-19 16:43:45,866 ERROR MainThread: Comparing QueryTestResults
> (expected vs actual):
> 4,4,'fourth
> item','{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
> 00:00:00.123400000","s1":"random string","s2":"","c1":"c","c2":"d
> ","vc":"addsdrr","de1":33357,"de2":null}','{"b":null}','{"i":null,"s":"str"}',4,'fourth
>
> item','{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
> 00:00:00.123400000","s1":"random string","s2":"","c1":"c","c2":"d
> ","vc":"addsdrr","de1":33357,"de2":null}','{"b":null}','{"i":null,"s":"str"}'
> != 4,4,'fourth
> item','b'{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
>
> 00:00:00.123400000","s1":"\\x9da\\\\u0010u@\\xa5\\xa3\\xe6\\x8d\\x86\\xdfhz","s2":"","c1":"c","c2":"d
>
> ","vc":"addsdrr","de1":33357,"de2":null}'','{"b":null}','{"i":null,"s":"str"}',4,'fourth
>
> item','{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
> 00:00:00.123400000","s1":"random string","s2":"","c1":"c","c2":"d
> ","vc":"addsdrr","de1":33357,"de2":null}','{"b":null}','{"i":null,"s":"str"}'{noformat}
> The difference is at the 't1.alltypes' struct column. The expect result is
> {noformat}
> '{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
> 00:00:00.123400000","s1":"random string","s2":"","c1":"c","c2":"d
> ","vc":"addsdrr","de1":33357,"de2":null}'{noformat}
> But the actual result is
> {noformat}
> 'b'{"ti":90,"si":30482,"i":1664336,"bi":23567459873,"b":true,"f":0.5600000023841858,"do":NaN,"da":"2000-12-31","ts":"2024-01-01
>
> 00:00:00.123400000","s1":"\\x9da\\\\u0010u@\\xa5\\xa3\\xe6\\x8d\\x86\\xdfhz","s2":"","c1":"c","c2":"d
> ","vc":"addsdrr","de1":33357,"de2":null}''{noformat}
> It seems the actual result is printed as binary type. Interestingly,
> 't2.alltypes' is printed correctly.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
