Question

Using OFFSET instead of UNNEST for nested fields in Google Bigquery

score 3k · Answer 1 · 2020-09-28 15:23:14

3k

Views

Using OFFSET instead of UNNEST for nested fields in Google Bigquery

Published on 28 September 2020 at 15:23

score 1.3k · Answer 2 · 2020-09-27 16:34:41

1.3k

Views

getting duplicate values in jsonb query posgresql

Published on 27 September 2020 at 16:34

score 1.8k · Answer 3 · 2020-09-29 10:53:55

1.8k

Views

How to iterate over PostgreSQL jsonb array of objects and modify elements?

Published on 29 September 2020 at 10:53

score 328 · Answer 4 · 2020-09-29 18:44:11

328

Views

How to change a tibble of lists to normal columns and preserve the column names

Published on 29 September 2020 at 18:44

score 1.1k · Answer 5 · 2020-09-30 20:50:51

1.1k

Views

Json Array Column split into Rows SQL

Published on 30 September 2020 at 20:50

score 383 · Answer 6 · 2020-10-09 12:29:59

383

Views

Parsing out JSON column Array data in Mysql 5.7

Published on 09 October 2020 at 12:29

score 48 · Answer 7 · 2020-10-14 16:51:33

48

Views

Join 2 tables with string_id instead of jointable

Published on 14 October 2020 at 16:51

score 1.2k · Answer 8 · 2020-10-16 09:08:01

1.2k

Views

I can't unnest sub arrays on athena

Published on 16 October 2020 at 09:08

score 1.4k · Answer 9 · 2020-10-18 12:16:02

1.4k

Views

ATHENA/PRESTO complex query with multiple unnested tables

Published on 18 October 2020 at 12:16

score 247 · Answer 10 · 2020-10-18 17:48:21

247

Views

R nest/unnest of dataframe results in non-identical objects

Published on 18 October 2020 at 17:48

score 513 · Answer 11 · 2020-10-19 20:16:47

513

Views

Split Text string and make it a aggregated list in Postgres

Published on 19 October 2020 at 20:16

score 97 · Answer 12 · 2020-10-21 23:28:51

97

Views

Is there a way to unnest the dataframes which are nested in a column of another dataframe using R?

Published on 21 October 2020 at 23:28

score 31 · Answer 13 · 2023-10-24 07:56:27

31

Views

Cannot access field criteria on a value with type ARRAY<STRUCT<id STRING, totalResults INT64, resultType STRING, ...>>

Published on 24 October 2023 at 07:56

score 74 · Answer 14 · 2023-11-17 20:04:37

74

Views

Using BigQuery SQL to split nested values on multiple columns

Published on 17 November 2023 at 20:04

score 146 · Answer 15 · 2023-12-12 11:55:53

146

Views

Unnest elements of each object in Trino/Presto

Published on 12 December 2023 at 11:55

score 46 · Answer 16 · 2020-12-05 14:54:00

46

Views

How to merge arrays of different table entries together?

Published on 05 December 2020 at 14:54

score 182 · Answer 17 · 2020-12-08 04:16:37

182

Views

Simplest way to unnest a BQ table

Published on 08 December 2020 at 04:16

score 266 · Answer 18 · 2020-12-08 22:36:14

266

Views

Unlist/unnest list column into several columns

Published on 08 December 2020 at 22:36

score 500 · Answer 19 · 2020-12-10 15:53:46

500

Views

I am working in MySQL Workbench, and am unable to use the UNNEST function; I get an error on the parenthesis

Published on 10 December 2020 at 15:53

score 2.9k · Answer 20 · 2020-12-13 21:36:48

2.9k

Views

ORACLE JSON_TABLE I need to get 2 columns from an array

Published on 13 December 2020 at 21:36

List Question

Using OFFSET instead of UNNEST for nested fields in Google Bigquery

getting duplicate values in jsonb query posgresql

How to iterate over PostgreSQL jsonb array of objects and modify elements?

How to change a tibble of lists to normal columns and preserve the column names

Json Array Column split into Rows SQL

Parsing out JSON column Array data in Mysql 5.7

Join 2 tables with string_id instead of jointable

I can't unnest sub arrays on athena

ATHENA/PRESTO complex query with multiple unnested tables

R nest/unnest of dataframe results in non-identical objects

Split Text string and make it a aggregated list in Postgres

Is there a way to unnest the dataframes which are nested in a column of another dataframe using R?

Cannot access field criteria on a value with type ARRAY<STRUCT<id STRING, totalResults INT64, resultType STRING, ...>>

Using BigQuery SQL to split nested values on multiple columns

Unnest elements of each object in Trino/Presto

How to merge arrays of different table entries together?

Simplest way to unnest a BQ table

Unlist/unnest list column into several columns

I am working in MySQL Workbench, and am unable to use the UNNEST function; I get an error on the parenthesis

ORACLE JSON_TABLE I need to get 2 columns from an array

Trending Questions

Popular # Hahtags

Popular Questions