Aggarwal-Raghav commented on PR #5673: URL: https://github.com/apache/hive/pull/5673#issuecomment-2702940036
@Mr-LiuXu, thanks for the PR. I checked the behaviour of get_json_object and it is treating the "score" value as a array i.e [60, 90]. <img width="793" alt="Screenshot 2025-03-06 at 11 53 15 AM" src="https://github.com/user-attachments/assets/25cb005f-b19d-437e-a312-8acab4790360"; /> **In spark-sql also, get_json_object for "$.respBody.data.score" returns NULL.** I also checked the behaviour in python and [jq](https://jqlang.org/) and both of them are throwing error. <img width="613" alt="Screenshot 2025-03-06 at 11 54 28 AM" src="https://github.com/user-attachments/assets/03acec8f-5387-4364-b587-bf66d704b4fe"; /> <img width="712" alt="python behaviour" src="https://github.com/user-attachments/assets/e734a6c2-e899-41f7-9ac0-a855a115fb57"; /> IMO, we can keep the behaviour inline with python, jq and spark. The Patch in this PR will help in this and won't break backward compatibility as well. CC @okumin , can you provide your insights here. -- 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: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
