Skip to content

Instantly share code, notes, and snippets.

@daschl

daschl/cheatsheet.sql

Last active October 11, 2016 08:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save daschl/3447e66f8076c0ec75359272c8d0b012 to your computer and use it in GitHub Desktop.
Save daschl/3447e66f8076c0ec75359272c8d0b012 to your computer and use it in GitHub Desktop.
Download ZIP
Eclipse MAT Couchbase SDK 2.x OQL Cheat Sheet
Raw
cheatsheet.sql
-- Finds all "Nodes", prints their hostname and their connection state
SELECT n.currentState.name.toString() AS state, n.hostname.holder.hostName.toString() AS hostname
FROM com.couchbase.client.core.node.CouchbaseNode n
-- Find all KV Endpoints, prints their hostname and their connection state and the bucket name
SELECT e.currentState.name.toString() AS state,
e.channel.requestedRemoteAddress.holder.addr.holder.hostName.toString() AS hostname,
e.bucket.toString() AS bucket
FROM com.couchbase.client.core.endpoint.kv.KeyValueEndpoint e
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment