How to read a table from dynamodb using Java?

Question

I created a table in Amazon dynamodb with primary key Issue(String) which has data stored in it.I want to read the values from my table. I'm using the following code..

@DynamoDBTable(tableName="Incident")
 AmazonDynamoDBClient dynamoDBClient = new AmazonDynamoDBClient();
 String tableName = "Incident";
 Table table = dynamoDBClient.getTable("Incident");
 Item getItem=dynamoDBClient.getItem();

I'm getting an error when calling the getTable method.... is it a predefined method just like createTable() or do we need to write our own..if so how? And also what method should be used to read all items in the table..? I used this link to write some of the code... http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/JavaDocumentAPIItemCRUD.html#JavaDocumentAPIGetItem

I'm new to Java please help..

notionquest · Accepted Answer · 2017-04-10 08:52:58Z

5

Scan API can be used to get all the items from the table.

The scan should be done until LastEvaluatedKey is not null which is very important to get all the items. Otherwise, you will not get all the items if the table has many items i.e. the API will return 1 MB of data per scan.

A Scan operation performs eventually consistent reads by default, and it can return up to 1 MB (one page) of data.

Scan API

Map<String, AttributeValue> lastKeyEvaluated = null;
do {
    ScanRequest scanRequest = new ScanRequest()
        .withTableName("ProductCatalog")
        .withLimit(10)
        .withExclusiveStartKey(lastKeyEvaluated);

    ScanResult result = client.scan(scanRequest);
    for (Map<String, AttributeValue> item : result.getItems()){
        printItem(item);
    }
    lastKeyEvaluated = result.getLastEvaluatedKey();
} while (lastKeyEvaluated != null);

answered Apr 10, 2017 at 8:52

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

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

3 Comments

Giridhari Over a year ago

thanks a lot @notionquest....i was able to retrieve all the items could you also help me with a code on how to retrieve a single item based on primary key..

notionquest Over a year ago

Use getItem Api.. docs.aws.amazon.com/amazondynamodb/latest/developerguide/….. Refer retrieveItem() method.

Arefe Over a year ago

I use this code and can confirm that this is working well.

Divyesh Kanzariya · Accepted Answer · 2017-04-10 08:58:04Z

0

Here is example how to read data using Scan API :

@Override
protected ArrayList<String> doInBackground(String... params) {
    String tableName = params[0];

    ArrayList<String> tempList = new ArrayList<String>();

    AmazonDynamoDBClient dynamoDBClient = new AmazonDynamoDBClient (
            new BasicAWSCredentials(Constants.ACCESS_KEY_ID,
                    Constants.SECRET_KEY));

    ScanRequest scanRequest = new ScanRequest()
        .withTableName(tableName);
        //.withAttributesToGet("name");
    com.amazonaws.services.dynamodb.model.ScanResult result = dynamoDBClient.scan(scanRequest);


    for (Map<String, AttributeValue> item : result.getItems()) {
        tempList.add(item.toString());
        //analizeItem(tempList, item);
    }

    return tempList;
}

Reference from programcreeks

edited Apr 10, 2017 at 8:58

answered Apr 10, 2017 at 8:47

Divyesh Kanzariya

3,8093 gold badges48 silver badges47 bronze badges

1 Comment

CustardBun Over a year ago

Won't this only get the first set of items from the scan? If there's more than a page's worth, it will not get the entire table unless you use withExclusiveStartKey , correct? docs.aws.amazon.com/amazondynamodb/latest/APIReference/…

vipin kumar patel · Accepted Answer · 2021-08-24 06:38:12Z

0

AmazonDynamoDB client = AmazonDynamoDBClientBuilder.standard().withRegion(Regions.AP_SOUTH_1).build(); DynamoDB dynamoDB = new DynamoDB(client);

    Table table = dynamoDB.getTable("Student");

    Item item = table.getItem("PK", "portion Key","SK","Sort Key");
    System.out.println(item.toJSONPretty());

answered Aug 24, 2021 at 6:38

vipin kumar patel

11 bronze badge

Collectives™ on Stack Overflow

How to read a table from dynamodb using Java?

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related