Details
Description
1. create sample buckets - beer-sample and gamesim-sample
2. Do not create a primary index yet on the buckets.
3. create index on gamesim-sample(hitpoints)
cbq> create index index_hitpoints on `gamesim-sample`(hitpoints) where hitpoints > 23000;
{
"requestID": "7fdab378-e068-45ef-bbd1-5bfdcc2d1b34",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
4. Issue a select on the bucket, to check if certain entries exist . Check screenshot for a valid entry of a record w/ hitpoints>23000.
Check below the result set is incorrect.
cbq> select * from `gamesim-sample` where hitpoints > 23000;
{
"requestID": "88d9766b-c610-40bb-b8d7-ee3cc34b1c15",
"signature":
,
"results": [
],
"status": "success",
"metrics":
}
5. Check for exact record hitpoints = 238322, select does not return the results.
cbq> select * from `gamesim-sample` where hitpoints =23832;
{
"requestID": "65566b23-68ea-4265-94c3-ed0e9facd2d6",
"signature":
,
"results": [
],
"status": "success",
"metrics":
}
The query.log shows some odd output, not sure how to parse/interpret it yet.
_time=2015-02-26T09:30:48-08:00 _level=INFO _msg=Request View: http://127.0.0.1:8092/gamesim-sample/_design/ddl_index_hitpoints/_view/index_hitpoints?limit=1001&stale=ok&startkey=%5B%5B128%2C23000%5D%5D&startkey_docid=%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF
_time=2015-02-26T09:30:48-08:00 _level=INFO _msg=Number of entries fetched from the index 0
_time=2015-02-26T09:31:17-08:00 _level=INFO _msg=Refreshing pool default
_time=2015-02-26T09:31:17-08:00 _level=INFO _msg= Checking keyspace beer-sample
_time=2015-02-26T09:31:17-08:00 _level=INFO _msg= Checking keyspace default
_time=2015-02-26T09:31:17-08:00 _level=INFO _msg= Checking keyspace gamesim-sample
_time=2015-02-26T09:31:19-08:00 _level=INFO _msg=Authenticating for keyspace gamesim-sample
_time=2015-02-26T09:31:19-08:00 _level=INFO _msg= Authenticating for bucket gamesim-sample username gamesim-sample password
_time=2015-02-26T09:31:19-08:00 _level=INFO _msg=Request View: http://127.0.0.1:8092/gamesim-sample/_design/ddl_%23primary/_view/%23primary?limit=1001&stale=ok
_time=2015-02-26T09:31:19-08:00 _level=INFO _msg=Number of entries fetched from the index 586
_time=2015-02-26T09:31:58-08:00 _level=INFO _msg=Authenticating for keyspace gamesim-sample
_time=2015-02-26T09:31:58-08:00 _level=INFO _msg= Authenticating for bucket gamesim-sample username gamesim-sample password
_time=2015-02-26T09:31:58-08:00 _level=INFO _msg=Request View: http://127.0.0.1:8092/gamesim-sample/_design/ddl_index_hitpoints/_view/index_hitpoints?limit=1001&stale=ok&startkey=%5B%5B128%2C2200%5D%5D&startkey_docid=%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF
2015/02/26 09:31:58 Warning: Finalizing a bucket with active connections.
2015/02/26 09
Attachments
Issue Links
- relates to
-
MB-13660 Simple Select with Where clause (which uses gsi index) hangs
- Closed
For Gerrit Dashboard: MB-13650 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
48070,2 | Partial fix for MB-13650. Formalize view index WHERE clause with bucket name. Display index condition in system:indexes. | master | query | Status: MERGED | +2 | +1 |
48084,1 | MB-13650: Store and retrieve condition expression in view design doc This fixes the datastore part of storing and retreiving the where condition for view indexes | master | query | Status: ABANDONED | 0 | +1 |
48110,3 | MB-13650: Store and retrieve condition expression in view design doc This fixes the datastore part of storing and retreiving the where condition for view indexes | master | query | Status: MERGED | +2 | +1 |