Quanlong Huang created IMPALA-14844:
---------------------------------------
Summary: 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
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]
