AWS Error Code: ValidationException, AWS Error Message: Consistent reads are not supported on global secondary indexes

Question

I started using Amazon DynamoDB and have an issue with query. I have a table Dev_Testgame1_Mail with id as primary hash key and following three global secondary indexes, - fromPlayerId (Hash Key) - toPlayerId (Hash Key) + isRead (Range Key) - toPlayerId (Hash Key) + endDate(Range Key) I have above code to do the query, ``` **DynamoDBMail hashKObject = new DynamoDBMail(); hashKObject.setToPlayerId(playerId); Condition endDateRangeKeyCondition = new Condition(); //endDateRangeKeyCondition.withComparisonOperator(ComparisonOperator.NULL).withAttributeValueList(new AttributeValue().withB(Utils.convertDateToByteBuffer(DateUtil.getUtcDateTime()))); endDateRangeKeyCondition.withComparisonOperator(ComparisonOperator.NULL); DynamoDBQueryExpression queryExpression = new DynamoDBQueryExpression(); queryExpression.withHashKeyValues(hashKObject).withRangeKeyCondition("endDate", endDateRangeKeyCondition); queryExpression.withIndexName("gsi_tp_enddt").withLimit(pageSize).w…

Accepted Answer

Set the consistent read property of the `queryExpression` to `false`. Put this line:

```
queryExpression.withConsistentRead(false);
```

or

```
queryExpression.setConsistentRead(false);
```

before you call

```
return dynamodbMapper.queryPage(DynamoDBMail.class, queryExpression, new DynamoDBMapperConfig(TableNameOverride.withTableNamePrefix(Utils.getDynamoDBTableNamePrefix(gameId, env))));
```

As an aside, I don't think your `NULL` `RangeKeyCondition` is doing anything for you.

AWS Error Code: ValidationException, AWS Error Message: Consistent reads are not supported on global secondary indexes

Solution

Problem