Questions tagged [partiql]
78 questions
0
votes
1 answer
AWS Redshift UNPIVOT semi structured data will skip blank values
following is my data set and table structure
create table students (
student_id varchar(255),
contact_numbers super
)
student_id, contact_numbers
1 {"mobile":111,"office":222}
2 {"mobile":4444}
3 …
WAEX
- 115
- 1
- 9
0
votes
1 answer
DynamoDB PartiQL select statement with IN operator on both partition key and sort key - How RCU is calculated?
use case:
Need to retrieve data from Dynamodb for multiple pk(PartitionKey)+sk(SortKey) combination. So leveraging the IN operator in partiql on both pk and sk.
I did small poc on how much RCU is getting consumed for 2 types of partiql…
mariz
- 509
- 1
- 7
- 13
0
votes
1 answer
How to convert Amazon Ion object to JSON object in Go Lang?
I'm looking for a way to convert the Amazon Ion object to JSON in Go Lang.
This problem came while I was implementing a DAO layer for Amazon QLDB. What I've done so far is using a Go Struct with both json and ion aliases as follows.
type Passport…
Chamin Wickramarathna
- 1,672
- 2
- 20
- 34
0
votes
1 answer
DynamoDB PartiQL Request Parameter In Select
I am attempting to use PartiQL to query a set of data that looks like this:
{
"userId": {
"S": "someuserID"
},
"mapWithData": {
"M": {
"1": {
"M": {
"neededVal": {
"S": "A Needed Value1"
…
Francis Bartkowiak
- 1,374
- 2
- 11
- 28
0
votes
2 answers
Pivoting AWS Redshift SUPER data
I have a following table structure:
server_id
server_databases
1
[{"name": "mssql", "count": 12},{"name": "postgresql", "count": 1}]
2
[]
3
null
What I want to receive as a result(I want to keep servers 2 and 3 if it would be null or…
Denis Solovev
- 79
- 1
- 11
0
votes
1 answer
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…
erol_smsr
- 1,454
- 4
- 24
- 49
0
votes
1 answer
How do I add a value for a new field in AWS DynamoDB?
My team added a new field in our DynamoDB and I need to add an integer for all entries that do not currently contain the field.
I've tried using the Update example here, however I am getting a ValidationException: Where clause does not contain a…
Ryan T.
- 197
- 1
- 15
0
votes
1 answer
Limited number of rows in QLDB
I need limited number of rows while fetch the data from QLDB. Unfortunately, QLDB does not support Limit function in it's queries. However, MySQL supports the feature of limited number of rows from table.
But, I have seen the Reserve Words in QLDB.…
Bilal Shahid
- 173
- 1
- 2
- 8
0
votes
1 answer
Will this SELECT QLDB query using index be optimized or not
I have one table with some indexes and some different columns. I am running this query to get the result of a user's data, not all the user data.
The user field is defined by UID
The time field is defined by TimeValue (i am entering time in numbers…
Sulman Azhar
- 977
- 1
- 9
- 26
0
votes
1 answer
How to validate if output of a SQL predicate intersects with output of another SQL predicate before actually querying on the data?
Is there any known algorithm or library which can help in determining if a SQL predicate is contained in another SQL predicate?
These predicate will come after this statement
SELECT * FROM table1 WHERE ...
For example, let's see this…
Aditya Abhas
- 174
- 11
0
votes
1 answer
Select a certain map element in a list using PartiQL (DynamoDB)
Although I understood how to select a list item in a map using document paths (eg Devices.FireStick.DateWatched[0]),I cannot figure out how to do it the other way round.
Say, I have an attribute containing a list of maps:
"Text": [
{
"Right":…
Werner
- 196
- 2
- 5
0
votes
1 answer
DynamoDB PartiQL error: "ValidationException: Overlapping conditions with range keys are not supported in where clause"
I'm getting the following error when I try to run a query in DynamoDB's PartiQL:
An error occurred during the execution of the command.
ValidationException: Overlapping conditions with range keys are not supported in where clause
The query looks…
Aaron
- 2,154
- 5
- 29
- 42
0
votes
1 answer
Redshift Super Data type Querying
Redshift's new super data type uses partiql for querying. I have an array of data that is not nested eg: [0,1,2,3,4]
What is the best way to query this data? All the documentation talks about nested arrays, but this is at the root level and there is…
Dan
- 21
- 1
- 4
0
votes
2 answers
How to specify parameters for DynamoDB PartiQL in Nodejs
I want to execute a SELECT query on DynamoDb with PartiQL in NodeJs, and getting errors.
a simple statement works with no problem.
const r = await client.send(
new ExecuteStatementCommand({
Statement: `SELECT * FROM Users WHERE…
Baron.K
- 1
- 1
- 1
0
votes
1 answer
Index inference on a DynamoDB PartiQL select statement
When doing a PartiQL select statement over a DynamoDB table:
Do we need to explicitly define which index to use, or can that be inferred from the WHERE condition? I.e, if an index is not defined on the FROM but the condition uses an indexed column…
Pedro Felix
- 1,056
- 1
- 8
- 12