Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query using filter expression flow example gives error #358

Open
shrutimantri opened this issue Jan 26, 2024 · 0 comments
Open

Query using filter expression flow example gives error #358

shrutimantri opened this issue Jan 26, 2024 · 0 comments
Labels
area/plugin Plugin-related issue or feature request bug Something isn't working kind/cooldown Great candidate for the cooldown period

Comments

@shrutimantri
Copy link
Contributor

Expected Behavior

I dont understand if there is actual need for filter expression, as key condition expression is mandatory, and that reduces the filtered output to only one row. We should ideally be using Scan task for filtering. Let me know if this example should be removed.

Actual Behaviour

The second example on this page with the title: "Query items from a table with a filter expression." gives the following error:

Value provided in ExpressionAttributeValues unused in expressions: keys: {:lastname} (Service: DynamoDb, Status Code: 400, Request ID: FI3F09BD1SSN285GI8EB8J472RVV4KQNSO5AEMVJF66Q9ASUAAJG)

The error is correct as we are only making the assignment to :lastname and not actually using it anywhere in the task. How should this filter expression be actually used in this Query task.

Steps To Reproduce

Use this example, and run it on a DynamoDB table "persons" having "id" as the partition key.

Environment Information

  • Kestra Version: 0.14.0
  • Plugin version: 0.14.0
  • Operating System (OS / Docker / Kubernetes): Docker
  • Java Version (If not docker): N/A

Example flow

id: "query"
type: "io.kestra.plugin.aws.dynamodb.Query"
accessKeyId: "<access-key>"
secretKeyId: "<secret-key>"
region: "eu-central-1"
tableName: "persons"
keyConditionExpression: id = :id
expressionAttributeValues:
  :id: "1"
  :lastname: "Doe"
@shrutimantri shrutimantri added the bug Something isn't working label Jan 26, 2024
@anna-geller anna-geller added this to the v0.16.0 milestone Jan 28, 2024
@anna-geller anna-geller modified the milestones: v0.16.0, v0.17.0 Feb 5, 2024
@anna-geller anna-geller modified the milestones: v0.17.0, v0.19.0 Apr 17, 2024
@github-project-automation github-project-automation bot moved this to Backlog in Issues Jun 10, 2024
@anna-geller anna-geller removed this from the v0.19.0 milestone Aug 15, 2024
@anna-geller anna-geller added kind/cooldown Great candidate for the cooldown period area/plugin Plugin-related issue or feature request labels Aug 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/plugin Plugin-related issue or feature request bug Something isn't working kind/cooldown Great candidate for the cooldown period
Projects
Status: Backlog
Development

No branches or pull requests

2 participants