In addition to the sample buckets supplied with Couchbase Server, the Analytics documentation also uses the Commerce example data described below.
The Commerce example data is used in most of the examples for the SQL++ for Analytics language reference.
It consists of two collections: customers and orders.
To install the Commerce example data, refer to Installation below.
Customers
The customers collection contains the following data:
[
{
"custid": "C13",
"name": "T. Cody",
"address": {
"street": "201 Main St.",
"city": "St. Louis, MO",
"zipcode": "63101"
},
"rating": 750
},
{
"custid": "C25",
"name": "M. Sinclair",
"address": {
"street": "690 River St.",
"city": "Hanover, MA",
"zipcode": "02340"
},
"rating": 690
},
{
"custid": "C31",
"name": "B. Pruitt",
"address": {
"street": "360 Mountain Ave.",
"city": "St. Louis, MO",
"zipcode": "63101"
}
},
{
"custid": "C35",
"name": "J. Roberts",
"address": {
"street": "420 Green St.",
"city": "Boston, MA",
"zipcode": "02115"
},
"rating": 565
},
{
"custid": "C37",
"name": "T. Henry",
"address": {
"street": "120 Harbor Blvd.",
"city": "Boston, MA",
"zipcode": "02115"
},
"rating": 750
},
{
"custid": "C41",
"name": "R. Dodge",
"address": {
"street": "150 Market St.",
"city": "St. Louis, MO",
"zipcode": "63101"
},
"rating": 640
},
{
"custid": "C47",
"name": "S. Logan",
"address": {
"street": "Via del Corso",
"city": "Rome, Italy"
},
"rating": 625
}
]Orders
The orders collection contains the following data:
[
{
"orderno": 1001,
"custid": "C41",
"order_date": "2020-04-29",
"ship_date": "2020-05-03",
"items": [
{
"itemno": 347,
"qty": 5,
"price": 19.99
},
{
"itemno": 193,
"qty": 2,
"price": 28.89
}
]
},
{
"orderno": 1002,
"custid": "C13",
"order_date": "2020-05-01",
"ship_date": "2020-05-03",
"items": [
{
"itemno": 460,
"qty": 95,
"price": 100.99
},
{
"itemno": 680,
"qty": 150,
"price": 8.75
}
]
},
{
"orderno": 1003,
"custid": "C31",
"order_date": "2020-06-15",
"ship_date": "2020-06-16",
"items": [
{
"itemno": 120,
"qty": 2,
"price": 88.99
},
{
"itemno": 460,
"qty": 3,
"price": 99.99
}
]
},
{
"orderno": 1004,
"custid": "C35",
"order_date": "2020-07-10",
"ship_date": "2020-07-15",
"items": [
{
"itemno": 680,
"qty": 6,
"price": 9.99
},
{
"itemno": 195,
"qty": 4,
"price": 35
}
]
},
{
"orderno": 1005,
"custid": "C37",
"order_date": "2020-08-30",
"items": [
{
"itemno": 460,
"qty": 2,
"price": 99.98
},
{
"itemno": 347,
"qty": 120,
"price": 22
},
{
"itemno": 780,
"qty": 1,
"price": 1500
},
{
"itemno": 375,
"qty": 2,
"price": 149.98
}
]
},
{
"orderno": 1006,
"custid": "C41",
"order_date": "2020-09-02",
"ship_date": "2020-09-04",
"items": [
{
"itemno": 680,
"qty": 51,
"price": 25.98
},
{
"itemno": 120,
"qty": 65,
"price": 85
},
{
"itemno": 460,
"qty": 120,
"price": 99.98
}
]
},
{
"orderno": 1007,
"custid": "C13",
"order_date": "2020-09-13",
"ship_date": "2020-09-20",
"items": [
{
"itemno": 185,
"qty": 5,
"price": 21.99
},
{
"itemno": 680,
"qty": 1,
"price": 20.5
}
]
},
{
"orderno": 1008,
"custid": "C13",
"order_date": "2020-10-13",
"items": [
{
"itemno": 460,
"qty": 20,
"price": 99.99
}
]
},
{
"orderno": 1009,
"custid": "C13",
"order_date": "2020-10-13",
"items": []
}
]Installation
To install the Commerce example data:
-
First, use the following links to download the example data to your local system.
-
If necessary, at the command line, use the bucket-create tool to create a bucket for the example Analytics data:
couchbase-cli bucket-create \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --bucket-type couchbase \ --bucket-ramsize 100
-
Use the collection-manage tool to create a scope for the
Commercedata:couchbase-cli collection-manage \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --create-scope Commerce
-
Use the collection-manage tool to create a collection for the
customersdata:couchbase-cli collection-manage \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --create-collection Commerce.customers
-
Similarly, create a collection for the
ordersdata:couchbase-cli collection-manage \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --create-collection Commerce.orders
-
Use the cbimport tool to import the
customersdata to the Data service:cbimport json \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --scope-collection-exp Commerce.customers \ --format list \ --generate-key id::#UUID# \ --dataset file:///path/to/CommerceCustomers.json
-
Similarly, import the
ordersdata to the Data service:cbimport json \ --cluster http://node1:8091 \ --username Administrator \ --password password \ --bucket analytics \ --scope-collection-exp Commerce.orders \ --format list \ --generate-key id::#UUID# \ --dataset file:///path/to/CommerceOrders.json
-
Now, using the Analytics service via the Analytics Workbench or the
cbqshell, create an Analytics scope to shadow theCommercescope:CREATE ANALYTICS SCOPE Commerce IF NOT EXISTS;
-
Create an Analytics collection for the
customersdata:CREATE ANALYTICS COLLECTION Commerce.customers ON analytics.Commerce.customers;
-
Create an Analytics collection for the
ordersdata:CREATE ANALYTICS COLLECTION Commerce.orders ON analytics.Commerce.orders;
The Analytics service ingests the data.
You can now use the Commerce scope.
Sample Buckets
The travel-sample bucket is used in the Analytics tutorial and the examples for the Data Definition Language.
To install the travel-sample bucket, refer to Sample Buckets.