lgbo-ustc commented on PR #8558: URL: https://github.com/apache/incubator-gluten/pull/8558#issuecomment-2655721934
> ### 性能测试 > ``` > 性能测试：测试数据量6千万行，分别执行三次，查看端到端执行时间 > > get_json_object: select count(1) from test_tbl1 where get_json_object(get_json_object(d, '$.a'), '$.b') = 'c'; > 优化前：53.194s, 52.18s, 51.603s > 优化后：24.894s, 25.042s, 24.724s > > and: select count(1) from test_tbl34 where id = 1 and d != 'axx' and d != 'cxx' and d != 'zxx'; > 优化前： 3.918s，4.106s，3.835s > 优化后： 3.123s, 3.303s, 3.288s > > or： select count(1) from test_tbl34 where id = 1 or d != 'axx' or d != 'cxx' or d != 'zxx'; > 优化前：2.611s，2.765s， 2.484s > 优化后：2.3s, 2.409s, 2.283s; > > get_struct_field: select count(1) from test_tbl31 where d.e.d.y = 'y123'; > 优化前：80.819s， 80.517s，83.3s > 优化后：80.885s, 80.108s, 81.121s; > ``` For `get_struct_field`, the coalesce is not necessary. `get_struct_field` is just to extract one of the nested column, the cost is tiny for a batch. I prefer to keep it not changed -- 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]
