Details
Description
1. create bucket default
2. create primary index using gsi
3. load 100 doucments on default
4. Check index stats - something odd about "total committed items" =1 , when I expect this to be actual document number of 100?
attached screenshot
Refer below information only for default bucket indexes.
Ketakis-MacBook-Pro:dev_sabre ketaki$ curl -v -u Administrator:password 10.6.2.164:9102/getIndexStatus | jq '.'
- About to connect() to 10.6.2.164 port 9102 (#0)
- Trying 10.6.2.164...
- Adding handle: conn: 0x7fd54a803a00
- Adding handle: send: 0
- Adding handle: recv: 0
- Curl_addHandleToPipeline: length: 1
- - Conn 0 (0x7fd54a803a00) send_pipe: 1, recv_pipe: 0
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 -::- -::- -::- 0* Connected to 10.6.2.164 (10.6.2.164) port 9102 (#0) - Server auth using Basic with user 'Administrator'
> GET /getIndexStatus HTTP/1.1
> Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==
> User-Agent: curl/7.30.0
> Host: 10.6.2.164:9102
> Accept: /
>
< HTTP/1.1 200 OK
< Content-Type: application/json
< Date: Tue, 02 Jun 2015 20:17:10 GMT
< Transfer-Encoding: chunked
<
{ [data not shown]
100 5282 0 5282 0 0 11767 0 -::- -::- -::- 11763 - Connection #0 to host 10.6.2.164 left intact
{
"code": "success",
"status": [
{ "defnId": 9883803739493546000, "name": "CU_ID_D_ID_W_ID", "bucket": "CUSTOMER", "secExprs": [ "`C_ID`", "`C_D_ID`", "`C_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX CU_ID_D_ID_W_ID ON CUSTOMER(`C_ID`,`C_D_ID`,`C_W_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 },
{ "defnId": 10247099293776420000, "name": "PX_NEW_ORDER", "bucket": "NEW_ORDER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_NEW_ORDER ON NEW_ORDER USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 14985575270346473000, "name": "PX_ORDER_LINE", "bucket": "ORDER_LINE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDER_LINE ON ORDER_LINE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 1270260835808626000, "name": "PX_STOCK", "bucket": "STOCK", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_STOCK ON STOCK USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 2701673555643606500, "name": "PX_WAREHOUSE", "bucket": "WAREHOUSE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_WAREHOUSE ON WAREHOUSE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 6381697991753504000, "name": "WH_ID", "bucket": "WAREHOUSE", "secExprs": [ "`W_ID`" ], "status": "Ready", "definition": "CREATE INDEX WH_ID ON WAREHOUSE(`W_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 9185192370830670000, "name": "px_default", "bucket": "default", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_default ON default USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 9811785622606940000, "name": "PX_DISTRICT", "bucket": "DISTRICT", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_DISTRICT ON DISTRICT USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 2566741460479319000, "name": "px_history", "bucket": "HISTORY", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_history ON HISTORY USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 11137462188741675000, "name": "PX_ITEM", "bucket": "ITEM", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ITEM ON ITEM USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 2192640717247959800, "name": "PX_ORDERS", "bucket": "ORDERS", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDERS ON ORDERS USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 2846474247137516000, "name": "DI_ID_W_ID", "bucket": "DISTRICT", "secExprs": [ "`D_ID`", "`D_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX DI_ID_W_ID ON DISTRICT(`D_ID`,`D_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 1691336714202497300, "name": "IT_ID", "bucket": "ITEM", "secExprs": [ "`I_ID`" ], "status": "Created", "definition": "CREATE INDEX IT_ID ON ITEM(`I_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 0 }
,
{ "defnId": 11887412344709894000, "name": "ST_W_ID_I_ID1", "bucket": "STOCK", "secExprs": [ "`S_W_ID`", "`S_I_ID`" ], "status": "Ready", "definition": "CREATE INDEX ST_W_ID_I_ID1 ON STOCK(`S_W_ID`,`S_I_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 16652031546379360000, "name": "#primary", "bucket": "default", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX #primary ON default USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 422366478685375300, "name": "seq_num", "bucket": "default", "secExprs": [ "`SequenceNumber`" ], "status": "Ready", "definition": "CREATE INDEX seq_num ON default(`SequenceNumber`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 17863168309128114000, "name": "PX_CUSTOMER", "bucket": "CUSTOMER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_CUSTOMER ON CUSTOMER USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 12527636432321680000, "name": "CU_W_ID_D_ID_LAST", "bucket": "CUSTOMER", "secExprs": [ "`C_W_ID`", "`C_D_ID`", "`C_LAST`" ], "status": "Ready", "definition": "CREATE INDEX CU_W_ID_D_ID_LAST ON CUSTOMER(`C_W_ID`,`C_D_ID`,`C_LAST`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 2601635105994920000, "name": "OL_O_ID_D_ID_W_ID", "bucket": "ORDER_LINE", "secExprs": [ "`OL_O_ID`", "`OL_D_ID`", "`OL_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX OL_O_ID_D_ID_W_ID ON ORDER_LINE(`OL_O_ID`,`OL_D_ID`,`OL_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 10968411149123822000, "name": "NO_D_ID_W_ID", "bucket": "NEW_ORDER", "secExprs": [ "`NO_O_ID`", "`NO_D_ID`", "`NO_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX NO_D_ID_W_ID ON NEW_ORDER(`NO_O_ID`,`NO_D_ID`,`NO_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 12730247324206440000, "name": "OR_O_ID_D_ID_W_ID", "bucket": "ORDERS", "secExprs": [ "`O_ID`", "`O_D_ID`", "`O_W_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_O_ID_D_ID_W_ID ON ORDERS(`O_ID`,`O_D_ID`,`O_W_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 4717892513257628000, "name": "OR_W_ID_D_ID_C_ID", "bucket": "ORDERS", "secExprs": [ "`O_W_ID`", "`O_D_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_W_ID_D_ID_C_ID ON ORDERS(`O_W_ID`,`O_D_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }]
}