Styjun

Cisco 3750X Power Cable

Gravitational Force Between Numbers

Are cells guaranteed to get at least one mitochondrion when they divide?

Is a world with one country feeding everyone possible?

Split into three!

Visual Block Mode edit with sequential number

Why was this character made Grand Maester?

Why do the i8080 I/O instructions take a byte-sized operand to determine the port?

How to deceive the MC

Is superuser the same as root?

Why A=2 and B=1 in the call signs for Spirit and Opportunity?

Flatten not working

Why is unzipped directory exactly 4.0K (much smaller than zipped file)?

Can a UK national work as a paid shop assistant in the USA?

Are runways booked by airlines to land their planes?

Ribbon Cable Cross Talk - Is there a fix after the fact?

What is Orcus doing with Mind Flayers in the art on the last page of Volo's Guide to Monsters?

Team has team lunch everyday, am I forced to go?

Status of proof by contradiction and excluded middle throughout the history of mathematics?

Time complexity of an algorithm: Is it important to state the base of the logarithm?

Why did other houses not demand this?

Can I render satellite deployment impossible, or at least impractical, by exploiting the Kessler syndrome?

Possibility of faking someone's public key

How does Dreadhorde Arcanist interact with split cards?

How can I select subset of attributes from an Nosql database with a condition using spring data repository?

How do you query DynamoDB?Structure a dynamoDB table to enable ASC or DESC ordered pagination on * items in a tableHow to structure a DynamoDB database to allow queries for trending posts?DynamoDB API: How can I build an “add JSON attribute if not present” update request?DynamoDB query on boolean keyQuestions around Primary Key and Sort Keys in DynamoDBList comprehensions in FilterExpression in boto3 for DynamodbHow to select from multiple tables based on conditionHow to query items from DynamoDB that only have unique attribute values?How to handle many to many in DynamoDB

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

In a NoSQL DB(DynamoDB), the table has 10 attributes. I only need to get 3 attributes from it. Two of them are the composite primary key(id, name), the rest one is isCreated. If I want to select all the items which isCreated is true, how can I define the name of the method in the repository of spring data? which annotation should I use？
In the relational database, the SQL would be like this:
"select id, name from table_name where isCreated=true".
1. In this way, I can get two attributes，but it can't get rid of the items whose isCreated is false.

@Query(string = "id, name")
public findByIdAndName(String id, String name);

2. This way will throw an exception. it said, "can't scan table or using @EnableScan to enable it".

@Query(string = "id, name")
public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

3. 
   

   This way can get rid of the items whose isCreated is false. but it selected all the ten attributes. But I only need two.

   
   
   

   @Query(string = "id, name")
   @EnableScan
   public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

   
   

What is the correct answer?

java spring attributes nosql repository

share|improve this question

asked Mar 23 at 21:57

GeorgeGeorge

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think projections can help you docs.spring.io/spring-data/jpa/docs/current/reference/html/…
  
  – seti
  Mar 24 at 2:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, Seti. That's really helpful.
  
  – George
  Mar 25 at 6:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  finally, I use Dynamodb API called query() + Dynamodb projections API solved the problem. This is the easiest way for it. Thanks.
  
  – George
  Apr 9 at 6:19
  

  
  
  
  

add a comment | 

0

In a NoSQL DB(DynamoDB), the table has 10 attributes. I only need to get 3 attributes from it. Two of them are the composite primary key(id, name), the rest one is isCreated. If I want to select all the items which isCreated is true, how can I define the name of the method in the repository of spring data? which annotation should I use？
In the relational database, the SQL would be like this:
"select id, name from table_name where isCreated=true".
1. In this way, I can get two attributes，but it can't get rid of the items whose isCreated is false.

@Query(string = "id, name")
public findByIdAndName(String id, String name);

2. This way will throw an exception. it said, "can't scan table or using @EnableScan to enable it".

@Query(string = "id, name")
public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

3. 
   

   This way can get rid of the items whose isCreated is false. but it selected all the ten attributes. But I only need two.

   
   
   

   @Query(string = "id, name")
   @EnableScan
   public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

   
   

What is the correct answer?

java spring attributes nosql repository

share|improve this question

asked Mar 23 at 21:57

GeorgeGeorge

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think projections can help you docs.spring.io/spring-data/jpa/docs/current/reference/html/…
  
  – seti
  Mar 24 at 2:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, Seti. That's really helpful.
  
  – George
  Mar 25 at 6:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  finally, I use Dynamodb API called query() + Dynamodb projections API solved the problem. This is the easiest way for it. Thanks.
  
  – George
  Apr 9 at 6:19
  

  
  
  
  

add a comment | 

In a NoSQL DB(DynamoDB), the table has 10 attributes. I only need to get 3 attributes from it. Two of them are the composite primary key(id, name), the rest one is isCreated. If I want to select all the items which isCreated is true, how can I define the name of the method in the repository of spring data? which annotation should I use？
In the relational database, the SQL would be like this:
"select id, name from table_name where isCreated=true".
1. In this way, I can get two attributes，but it can't get rid of the items whose isCreated is false.

@Query(string = "id, name")
public findByIdAndName(String id, String name);

2. This way will throw an exception. it said, "can't scan table or using @EnableScan to enable it".

@Query(string = "id, name")
public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

3. 
   

   This way can get rid of the items whose isCreated is false. but it selected all the ten attributes. But I only need two.

   
   
   

   @Query(string = "id, name")
   @EnableScan
   public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

   
   

What is the correct answer?

java spring attributes nosql repository

share|improve this question

asked Mar 23 at 21:57

GeorgeGeorge

11

@Query(string = "id, name")
public findByIdAndName(String id, String name);

@Query(string = "id, name")
public findByIdAndNameAndIsCreated(String id, String name, boolean isCreated);

share|improve this question

asked Mar 23 at 21:57

GeorgeGeorge

11

share|improve this question

asked Mar 23 at 21:57

GeorgeGeorge

11

asked Mar 23 at 21:57

GeorgeGeorge

11

asked Mar 23 at 21:57

GeorgeGeorge

11