You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
branch:
request_map: |- root.sqlQuery = "SELECT neededId FROM \"table-name\".\"table-index\" WHERE id = '1234'"processors:
- aws_dynamodb_partiql:
query: '${! this.sqlQuery }'unsafe_dynamic_query: trueargs_mapping: |- root = []
Getting:
Error while getting data from table-name: failed to process statement (ValidationError): Select statements within BatchExecuteStatement must specify the primary key in the where clause.
Note:
The configuration of index:
Global Secondary Index
Partition key: id
sort key: - (meaning NO sort key, table is pretty simple)
Projected attributes: Include: neededId
So I am having only one partition key for index and as sort key is not mandatory(and I don't have it at all), I should be able to search by index using only index partition key.
And query in DynamoDB.PariQL editor works successfully
SELECT neededId FROM"table-name"."table-index"where id ='1234'
Used similar sql with parametrized args_mapping - having same error
Though while I am trying to access table - everything works correctly.
Didn't find any examples of searching by index either in redpanda connect repo tests or whenever in web.
Any suggestions or workarounds?
It seems like DynamoDB error "Select statements within BatchExecuteStatement must specify the primary key in the where clause. "
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
While trying to search by index
Getting:
Error while getting data from table-name: failed to process statement (ValidationError): Select statements within BatchExecuteStatement must specify the primary key in the where clause.
Note:
The configuration of index:
So I am having only one partition key for index and as sort key is not mandatory(and I don't have it at all), I should be able to search by index using only index partition key.
And query in DynamoDB.PariQL editor works successfully
Used similar sql with parametrized args_mapping - having same error
Though while I am trying to access table - everything works correctly.
Didn't find any examples of searching by index either in redpanda connect repo tests or whenever in web.
Any suggestions or workarounds?
It seems like DynamoDB error "Select statements within BatchExecuteStatement must specify the primary key in the where clause. "
Beta Was this translation helpful? Give feedback.
All reactions