How to extract, in a list, all keys from a bucket in couchbase

Question

I am totally new in couchbase. I am using the java api and i want somehow to view all available keys in a bucket. Is this possible? Thanks in advance.

Mayer06, you might be right, but have in mind, that not all people are devs, that can grasp easy all the info.For example, i am a qa engineer.I use dev tools and i code, but due to my nature of my work, i cannot always go as deep, as you probably can. — stelios.p, Jan 12 '14 at 08:54
Agreed, no problem there - but StackOverflow questions are supposed to show a little bit of effort on your part :) — theMayer, Jan 12 '14 at 13:03

score 11 · Answer 1 · edited Jan 11 '14 at 10:27

11

It is possible but you will need to create a view to do this (secondary index).

You can create a view in the couchbase webconsole like so:

function (doc, meta) {
  if(meta.type == "json") {
     emit(null);
  }
}

This will emit all the keys (keys are automatically emitted anyway so no need to include anything extra).

Then you can query the view like below using the java sdk. (Obviously you need to instantiate the couchbase client etc)

View view = couchbaseClient.getView("DESIGN_VIEW NAME", "VIEW_NAME");
Query query = new Query();
ViewResponse viewResponse = couchbaseClient.query(view, query);

List<String> keys = new ArrayList<String>();
for (ViewRow viewRow : viewResponse) {
   keys.add(viewRow.getKey());
}

edited Jan 11 '14 at 10:27

DaveR

9,540
3
39
58

answered Jan 10 '14 at 18:33

scalabilitysolved

2,473
1
26
31

is there a way without a VIEW? – Benoy Prakash Jul 30 '15 at 11:42
Hi @BenoyPrakash this is the only way to access all keys within Couchbase. – scalabilitysolved Jul 30 '15 at 12:06
Hey @stelios.p if this answered your question would you mind marking it as correct? Thanks! – scalabilitysolved Jan 22 '16 at 19:20

How to extract, in a list, all keys from a bucket in couchbase

1 Answers1