Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
1 vote
0 answers
71 views

I have a table with the follow definition: CREATE TABLE "test" ( id UUID PRIMARY KEY, created TIMESTAMPTZ NOT NULL, description TEXT, permissions TEXT[] ); I want to bulk ...
F21's user avatar
  • 33.6k
2 votes
2 answers
199 views

I have a dataset that originally was a json file which is converted to a data.table with data.table(jsonlite::fromJSON(data)). The resulting data.table is complex with nested data containing not only ...
3 votes
4 answers
245 views

I have a dataset where the column to unnest contains data with unequal rows and columns rather than data with equal dimensions. I'm looking for a fast approach to unnest this dataset using data.table. ...
0 votes
0 answers
43 views

My spring boot query looks like this: @Query(value = "WITH input_points AS (SELECT ST_GeomFromText(unnest(:locations), :srid) AS geom)" + "SELECT ST_AsText(ip.geom) AS point_wkt FROM ...
0 votes
1 answer
87 views

Hi I have following json and would like to unnest filed.So, I have an old order and new order for products. There could be more field to the json but level of nesting remains the same. Is it possible ...
2 votes
1 answer
55 views

I have this value with data type array<struct<id:string,name:string,values:array<string>> [ {id=gid://test/1234, name=Size, values=[L, M, S, XS]}, {id=gid://test/12345, name=...
0 votes
0 answers
73 views

I have a postgresql function, that takes multiple varchar arrays in input. function my_function ( p_attr1 in varchar[], p_attr2 in varchar[], ...
xi20's user avatar
  • 153
0 votes
1 answer
71 views

Hi and thanks for reading me. I have a data frame that have the next structure: # A tibble: 6 ×ばつ 2 customerId transactionHistory ...
0 votes
2 answers
86 views

Let's say I have three tables: t1: client_id transmission_id timestamp column_A 1 AAA1 2024年10月16日 10:31:27 Banana 1 AAA2 2024年10月16日 11:31:27 Citrus 2 BBB1 2024年10月16日 09:12:14 Apple t2: client_id ...
Shotey's user avatar
  • 3
1 vote
2 answers
675 views

Trying to load a nested JSON file into Duckdb. Here is the JSON contents: { "MainLevel":[ { "More":{ } }, { "More":{ ...
1 vote
1 answer
203 views

I'm encountering issues when attempting to unnest a dataframe containing list columns. The dataframe structure and the unnesting code I'm using are as follows: library(dplyr) library(tidyr) df = ...
Mostafa90's user avatar
  • 1,706
0 votes
1 answer
559 views

I have a products table with an array column tags that contains up to 700 elements. I want to efficiently search for specific tag names for a given user to be used in a search bar. Here's my query: ...
3 votes
2 answers
273 views

I have this DataFrame import polars as pl df = pl.DataFrame({ 'as_of': ['2024-08-01', '2024-08-02', '2024-08-03', '2024-08-04'], 'quantity': [{'A': 10, 'B': 5}, {'A': 11, 'B': 7}, {'A': 9, ...
1 vote
1 answer
168 views

This is for PrestoSQL Assuming col1, col2, col3 are of same cardinality, and assuming the Table has N rows SELECT c1 from Table, UNNEST(col1) AS t(c1) SELECT c1, c2 from Table, UNNEST(col1, col2) ...
1 vote
1 answer
44 views

As simple example I want to calculate the matrix product of two vectors. a <- tibble(n=c("A", "B"), y=c(10,20)) b <- tibble(x=c(5, 15)) res <- a %>% mutate(rotated =...
MPB_2022's user avatar
  • 303

15 30 50 per page
1
2 3 4 5
...
33

AltStyle によって変換されたページ (->オリジナル) /