Error in batchGetItem API in java

Question

The entity i am querying has a HashKey & a RangeKey (Number). When i use batchGetItem on it, i get the following error:

AWS Error Code: ValidationException, AWS Error Message: One or more parameter values were invalid: Mismatching attribute types between location and schema

Schema:

Table: Daily

Hash Key: CustId (String)

Range Key: Dated (Number)

Data:

CustId : VisioNerdy

Dated : 1329071400000

Code:

  List<Key> fkeys = new ArrayList<Key>(); //tableName="Daily", keys=["VisioNerdy"], ranges=[1329071400000]
    Map<String, KeysAndAttributes> requestItems = new HashMap<String, KeysAndAttributes>();
    for(int i = 0; i < keys.size(); i++)
    {
        String key = keys.get(i);
        if(ranges == null)
            fkeys.add(new Key().withHashKeyElement(new AttributeValue().withS(key)));
        else
            fkeys.add(new Key().withHashKeyElement(new AttributeValue().withS(key))
                    .withRangeKeyElement(new AttributeValue().withS(ranges.get(i).toString())));
    }
    requestItems.put(tableName, new KeysAndAttributes().withKeys(fkeys));
    BatchGetItemRequest batchGetItemRequest = new BatchGetItemRequest().withRequestItems(requestItems);
    BatchGetItemResult result = client.batchGetItem(batchGetItemRequest);

Any clues?

Could you please add your (eventually condensed) schema and the code fragment executing your query to ease analysis? Thanks! — Steffen Opel
– Steffen Opel, Commented Feb 13, 2012 at 9:29
You have "if(ranges == null)" but if a Table has a range key, a value is required; you can't omit it. — Adam Vandenberg
– Adam Vandenberg, Commented Feb 14, 2012 at 4:49
@AdamVandenberg This is a generic code that works for all Tables without or with range key. In this case, if(ranges == null) will not be executed, since "Daily" is executed with "ranges=[1329071400000]". — Réti Opening
– Réti Opening, Commented Feb 14, 2012 at 7:05

Steffen Opel · Accepted Answer · 2012-04-24 08:28:43Z

8

You have defined the range attribute of your Hash and Range Type Primary Key as type Number, yet prepare its attribute value via withS() as type String for your request:

fkeys.add(new Key().withHashKeyElement(new AttributeValue().withS(key))
        .withRangeKeyElement(new AttributeValue().withS(ranges.get(i).toString())));

Changing withS(String s) to withN(String s) should remedy your problem accordingly (confusingly both methods require a parameter of type String):

fkeys.add(new Key().withHashKeyElement(new AttributeValue().withS(key))
        .withRangeKeyElement(new AttributeValue().withN(ranges.get(i).toString())));

Admittedly, the implicit weak typing of the DynamoDB data types submission based on String parameters only doesn't exactly ease developing ;)

edited Apr 24, 2012 at 8:28

answered Feb 14, 2012 at 11:35

Steffen Opel

64.9k11 gold badges195 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steffen Opel Over a year ago

@Mani: Glad I could help - could you please upvote and especially accept the answer, if it solved your problem? This is desired here, both to get your issue out of sight and make room for open problems of others, as well as ensuring users stay motivated to help each other ;) See the FAQ What is reputation? for details - thanks!

Collectives™ on Stack Overflow

Error in batchGetItem API in java

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related