python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - partiql

Pivoting AWS Redshift SUPER data

I have a following table structure: server_id server_databases 1 [{"name": "mssql", "count": 12},{"name": "postgresql", "count": 1}]...
test-img

Denis Solovev

sql

pivot

amazon-redshift

partiql

Votes: 0

Answers: 2

Latest Answer

Use ISNULL in count : SELECT server_id, ( select '{' || listagg('"' || x.name || '":' || x.count, ',') || '}' as clientdatabases from ( selec...
test-img

Piyush Kachhadiya

Run AWS batch-execute-statement on the entire table in DynamoDB

I have a table in DynamoDB and I need to update all the items in it. Each item has a key and multiple columns with boolean values. It looks a bit like this: Key BooleanOne BooleanTwo key-one t...
test-img

erol_smsr

amazon-web-services

amazon-dynamodb

partiql

Votes: 0

Answers: 1

Latest Answer

There is no way in DynamoDB to do a mass update by providing only a short declarative command specifying the criteria of the items to update. Given this schema you have, you'll need to do a scan with ...
test-img

hunterhacker

Posts

Questions

Blogs

Jobs