How to Add Filter in DynamoDB Query with Number Set using Java SDK/PartiQL?

Question

Hi.

I have a table that has Number Set attribute, Field1.

Sample items
| Field1 (Number Set) | Field2 | Field3 |
| --- | --- | --- |
| [1,2,3] | Data | Data |
| [2] | Data | Data |
| [3] | Data | Data |
| [2,4] | Data | Data |

How to Add Filter in DynamoDB Query with Number Set using Java SDK/PartiQL? The search sets only 1 param to get the items.

Sample scenario:
* Include 2 as Field1 filter, the result should have rows #1, #2, #4.
* Include 3 as Field1 filter. the result should have rows #1, #3.

Thank you!

Accepted Answer

In the PartiQL query editor the queries would look like:

```sql
SELECT * FROM "tablename" WHERE contains("field1", 2)

SELECT * FROM "tablename" WHERE contains("field1", 3)
```

I have never created any JAVA client but reading the docs it would be someting like

```java
statement = new ParameterizedStatement()
     .withStatement("SELECT * FROM 'tablename' WHERE contains('field1', ?)")
     .withParameters(new AttributeValue(2))
```

How to Add Filter in DynamoDB Query with Number Set using Java SDK/PartiQL?

相关内容