Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in unnest
Google BigQuery: UNNEST where each different key becomes a column
Jul 03, 2026
sql
google-bigquery
pivot
unnest
Insert same values for multiple records based on list of ids
Jun 20, 2026
sql
postgresql
sql-insert
unnest
could not find function "unnest_tokens"
Jun 11, 2026
r
tidytext
unnest
Naming columns from a hoisted vector after unnest_wider
May 31, 2026
r
tidyverse
tidyr
unnest
hoist
Any more concise `data.table` way to unnest a nested column in data.table?
Apr 24, 2026
r
nested
data.table
unnest
Concatenate array elements on a joined table PostgreSQL
Apr 12, 2026
arrays
postgresql
concatenation
unnest
select elements from jsonb postgres array
Mar 31, 2026
arrays
json
postgresql
window-functions
unnest
Unnest from Table in Snowflake
Feb 08, 2026
pivot
snowflake-cloud-data-platform
unpivot
flatten
unnest
Expand/Unnest Polars struct into rows, not into columns
Feb 08, 2026
python
dataframe
python-polars
unpivot
unnest
Extracting JSON objects in Athena / Presto for dynamic keys
Jan 20, 2026
sql
json
amazon-athena
presto
unnest
Bigquery SQL - Is it better to unnest in SELECT or JOIN?
Dec 14, 2025
sql
google-bigquery
unnest
AWS Glue - Can't select fields after unnest or relationalize
Nov 26, 2025
json
amazon-web-services
aws-glue
unnest
Can I get unique/distinct values of json column in MySQL?
Nov 01, 2025
mysql
sql
arrays
json
unnest
How to split the GENERATE_DATE_ARRAY in a date for a single row in Google Bigquery to create a date view?
Oct 27, 2025
sql
arrays
google-bigquery
unnest
SQL presto - cross join unnest null value
Oct 22, 2025
sql
null
presto
unnest
trino
SQL: CROSS JOIN UNNEST and include data from rows with NULLs in CROSS JOIN UNNEST column
Oct 22, 2025
sql
presto
trino
cross-join
unnest
What is the equivalent of postgresSQL unnest() in snowflake sql
Oct 17, 2025
snowflake-cloud-data-platform
unnest
Flatten multiple same-sized array columns in BigQuery table
Sep 18, 2025
sql
google-bigquery
flatten
unnest
UNNEST a composite array into rows and columns in Postgres
Sep 07, 2025
postgresql
unnest
Older Entries »