1. load tpcc data, consider say bucket District which has 1000 items.
2. create index on District as
- PX_DISTRICT - create primary index using gsi
- DI_ID_W_ID - create index on DISTRICT(D_ID, W_ID) using gsi
On the UI both the indexes show about 100 to 60 fewer items.
The getIndex endpoint shows all indexes are up to date and ready.
{
"code": "success",
"status": [
{
"defnId": 6220057689312853000,
"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": 5401487455084683000,
"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": 10197745920919250000,
"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": 2693837423626565600,
"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.164:8091"
],
"completion": 100
}
,
{
"defnId": 18346766360875117000,
"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": 15553475143707144000,
"name": "PX_CUSTOMER",
"bucket": "CUSTOMER",
"isPrimary": true,
"status": "Ready",
"definition": "CREATE PRIMARY INDEX PX_CUSTOMER ON CUSTOMER USING GSI",
"hosts": [
"10.6.2.164:8091"
],
"completion": 100
}
,
{
"defnId": 11089773368897765000,
"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.164:8091"
],
"completion": 100
}
,
{
"defnId": 945442702367929500,
"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.164:8091"
],
"completion": 100
}
,
{
"defnId": 12197375686553686000,
"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": 3440314734524794400,
"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.164:8091"
],
"completion": 100
}
,
{
"defnId": 8947436908802838000,
"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.164:8091"
],
"completion": 100
}
,
{
"defnId": 16688672414267496000,
"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": 3326173210389418500,
"name": "PX_STOCK",
"bucket": "STOCK",
"isPrimary": true,
"status": "Ready",
"definition": "CREATE PRIMARY INDEX PX_STOCK ON STOCK USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
,
{
"defnId": 5432008840470267000,
"name": "PX_WAREHOUSE",
"bucket": "WAREHOUSE",
"isPrimary": true,
"status": "Ready",
"definition": "CREATE PRIMARY INDEX PX_WAREHOUSE ON WAREHOUSE USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
,
{
"defnId": 6384134797828746000,
"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": 10742907495691225000,
"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": 1298302833338187000,
"name": "arrv_dest",
"bucket": "default",
"secExprs": [
"(((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[0]).`DepatureAirport`).`LocationCode`)",
"(((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[0]).`ArrivalAirport`).`LocationCode`)"
],
"status": "Ready",
"definition": "CREATE INDEX arrv_dest ON default((((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[0]).`DepatureAirport`).`LocationCode`),(((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[0]).`ArrivalAirport`).`LocationCode`)) USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
,
{
"defnId": 13599845997881702000,
"name": "PX_DISTRICT",
"bucket": "DISTRICT",
"isPrimary": true,
"status": "Ready",
"definition": "CREATE PRIMARY INDEX PX_DISTRICT ON DISTRICT USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
,
{
"defnId": 14768459523065369000,
"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.167:8091"
],
"completion": 100
}
,
{
"defnId": 13957383377823402000,
"name": "px_history",
"bucket": "HISTORY",
"isPrimary": true,
"status": "Ready",
"definition": "CREATE PRIMARY INDEX px_history ON HISTORY USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
,
{
"defnId": 1548575999650553600,
"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.167:8091"
],
"completion": 100
}
,
{
"defnId": 15784363429392693000,
"name": "I_ID",
"bucket": "ITEM",
"secExprs": [
"`I_ID`"
],
"status": "Ready",
"definition": "CREATE INDEX I_ID ON ITEM(`I_ID`) USING GSI",
"hosts": [
"10.6.2.167:8091"
],
"completion": 100
}
]
}