Backend
CH (ClickHouse)
Bug description
query sql: select $.a[*].b from test_tbl
test_data: {"a":[1,3,{"b":"y", "a":"x"}]}
valina result: "y"
gluten result: y
query sql: select $.store.basket[0][*].b from test_tbl
test_data:{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"book":[{"author":"Nigel Rees","title":"Sayings of the Century","category":"reference","price":8.95},{"author":"Herman Melville","title":"Moby Dick","category":"fiction","price":8.99, "isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","title":"The Lord of the Rings","category":"fiction","reader":[{"age":25,"name":"bob"},{"age":26,"name":"jack"}],"price":22.99,"isbn":"0-395-19395-8"}],"bicycle":{"price":19.95,"color":"red"}}, "email":"amy@only_for_json_udf_test.net","owner":"amy","zip code":"94025", "fb:testid":"1234"}
valina result: ["y"]
gluten result: y
Spark version
Spark-3.3.x
Spark configurations
No response
System information
No response
Relevant logs
Backend
CH (ClickHouse)
Bug description
query sql:
select $.a[*].bfrom test_tbltest_data:
{"a":[1,3,{"b":"y", "a":"x"}]}query sql:
select $.store.basket[0][*].bfrom test_tbltest_data:
{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"book":[{"author":"Nigel Rees","title":"Sayings of the Century","category":"reference","price":8.95},{"author":"Herman Melville","title":"Moby Dick","category":"fiction","price":8.99, "isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","title":"The Lord of the Rings","category":"fiction","reader":[{"age":25,"name":"bob"},{"age":26,"name":"jack"}],"price":22.99,"isbn":"0-395-19395-8"}],"bicycle":{"price":19.95,"color":"red"}}, "email":"amy@only_for_json_udf_test.net","owner":"amy","zip code":"94025", "fb:testid":"1234"}Spark version
Spark-3.3.x
Spark configurations
No response
System information
No response
Relevant logs