rtyler commented on issue #7845: URL: https://github.com/apache/arrow-datafusion/issues/7845#issuecomment-1939704217
From a user's standpoint I've run into this now from a Datafusion SQL standpoint. As a SQL user I am hurting mostly by the lack of a [get_json_object()](https://spark.apache.org/docs/latest/api/sql/#get_json_object) function to use in order to extract keys from within strings. For example, Delta Lake has no native JSON type, so my applications rely on String columns which are known a priori to contain JSON data, and then a common query pattern might be: ```sql SELECT id, get_json_object(ctx_data, '$.name') as name FROM sometable WHERE ds = current_date() ``` Where the schema might be: ```` +-------------------+ | id | Int64 | | ctx_data | Utf8 | +-------------------+ ``` In the meantime I might just shove a UDF into place. -- 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]
