You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE EXTERNAL TABLE test_table
(
`id` string,
`timestamp` timestamp,
`foo` string
) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES ("explicit.null"="true");
When querying using the JSON_EXTRACT_SCALAR functions the null is treated as a string "null" rather than null. For example the query below would return no results:
SELECT * FROM test_table WHERE JSON_EXTRACT_SCALAR(foo, '$.foo.key1') IS NULL
The text was updated successfully, but these errors were encountered:
Given a JSON file:
Using the following table create:
When querying using the JSON_EXTRACT_SCALAR functions the null is treated as a string "null" rather than
null
. For example the query below would return no results:SELECT * FROM test_table WHERE JSON_EXTRACT_SCALAR(foo, '$.foo.key1') IS NULL
The text was updated successfully, but these errors were encountered: