为什么在DynamoDB中通过失败订单查询?
我有一个查询,我按预期_delivery value订购,该值是一个数字(UNIX TIMESTAMP),但由于此错误而失败:
验证exception:在使用订单时,必须在wery子句中至少具有一个非访问的关键条件。
这是查询:
SELECT * FROM "transactions"."composite_pk_1-index"
WHERE begins_with(composite_pk_1, '0#3#435634652#69992528')
ORDER BY expected_delivery ASC
如果我在没有订单的情况下运行它,那么它将成功运行并返回数据:
SELECT * FROM "transactions"."composite_pk_1-index"
WHERE begins_with(composite_pk_1, '0#3#435634652#69992528')
我尝试在查询中添加其他条件,但它会持续返回相同的错误。显然,错误不是说出问题所在,但我不知道它是什么。
有人可以帮忙吗?我是DynamoDB的新手。
I have a query where I ORDER BY expected_delivery value which is a number (UNIX timestamp) but it fails with this error:
ValidationException: Must have at least one non-optional hash key condition in WHERE clause when using ORDER BY clause.
Here is the query:
SELECT * FROM "transactions"."composite_pk_1-index"
WHERE begins_with(composite_pk_1, '0#3#435634652#69992528')
ORDER BY expected_delivery ASC
if I run it without the ORDER BY part then it runs successfully and returns data:
SELECT * FROM "transactions"."composite_pk_1-index"
WHERE begins_with(composite_pk_1, '0#3#435634652#69992528')
I tried adding other conditions in the query but it keeps returning the same error. Obviously the error is not stating what's the problem but I dont get it what it is.
Can someone help? I am new to DynamoDB.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论