Skip to Main Content

NoSQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I get the total number of records meeting the query conditions using Table API?

zechang SunApr 10 2015 — edited Apr 15 2015

Hi,

A TableIterator<Row> is returned when I do query operations using a tables's index.If I want to get the total number of records ,I have to count one by one using the TableIterator<Row> returned.


Can I get the total number of records directly meeting the query conditions?

I can get the total number of records directly meeting the query conditions from CLI using command aggregate table -name tableName -count -index indexName -field fieldName -start startValue -end endValue.

Can I get the same results using Table API?

I have used MongoDB and Oracle NoSQL for about one year.According to the experience of the use of these dbs,I think the query interface of mongoDB is powerful .In contras,the query interface is relatively simple resulting in that there are many works which are usually time-consuming to do in the client side.

This post has been answered by Gmfeinberg-Oracle on Apr 13 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2015
Added on Apr 10 2015
2 comments
1,408 views