Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql-a2c-1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/html/wp-includes/wp-db.php on line 2024

Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql-a2c-1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/html/wp-includes/wp-db.php on line 2024
class="post-444094 post type-post status-publish format-standard hentry" id="post-444094">

Can’t query semi-structured data using lateral flatten etc

I’ve got some data in a table, and one of the columns is a Variant which contains a ree of JSON data. I can successfully flatten arrays, and arrays within arrays to access data therein but I’m struggling with flattening key-value pairs to access the value for a given key.

I’ve seen the docs at https://docs.snowflake.net/manuals/user-guide/json-basics-tutorial.html mapping this onto my use case results in NULL values in the results.

My variant is show in part below – In particular it’s values like MatchStatus and the key/values under Variables that I’m interested in extracting.

Thanks for any helpful suggestions.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *