/opt/couchbase/bin/cbq -engine=http://10.112.190.101:8091/ -q -u Administrator -p password cbq> begin work; { "requestID": "a0664e12-d70e-4cb9-b23c-69a716cf5744", "signature": "json", "results": [ { "txid": "07a40641-773f-41db-977b-0809d7024294" } ], "status": "success", "metrics": { "elapsedTime": "892.095µs", "executionTime": "815.443µs", "resultCount": 1, "resultSize": 62, "serviceLoad": 25 } } cbq> SAVEPOINT a0; { "requestID": "6035df00-b460-4aa9-9dc0-773ab9f7abfb", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "254.717µs", "executionTime": "175.616µs", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> INSERT INTO default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` t WHERE job_title='Pre-Sales' LIMIT 10 RETURNING *; { "requestID": "bcd11950-6d26-4421-ae5c-06524cd16055", "signature": { "*": "*" }, "results": [ { "_default": { "Working_country": "CANADA", "citizen_of": "USA", "emp_id": 9593, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 7, "join_mo": 3, "join_yr": 2011, "languanges_known": "Portuguese", "name": "Adrianne Julian", "salary": 112463, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 815, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 26, "join_mo": 12, "join_yr": 2011, "languanges_known": "Quechua", "name": "Kacila Wood", "salary": 144676, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 7148, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 26, "join_mo": 8, "join_yr": 2010, "languanges_known": "Hindi", "name": "Salina Howard Jr.", "salary": 48036, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 8370, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 16, "join_mo": 6, "join_yr": 2010, "languanges_known": "Thai", "name": "Ambika Phillips", "salary": 80249, "skills": "Development" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4481, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 27, "join_mo": 5, "join_yr": 2013, "languanges_known": "Italian", "name": "Mia cox", "salary": 51316, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 5704, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 17, "join_mo": 2, "join_yr": 2013, "languanges_known": "German", "name": "Trista Cook", "salary": 83530, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 2037, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 17, "join_mo": 10, "join_yr": 2012, "languanges_known": "English", "name": "Lysha Lee", "salary": 176890, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 3259, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 8, "join_mo": 7, "join_yr": 2012, "languanges_known": "Italian", "name": "Lilith Carter", "salary": 19103, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "USA", "emp_id": 9370, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 18, "join_mo": 6, "join_yr": 2015, "languanges_known": "Arabic", "name": "Adrianne Brown", "salary": 180170, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 592, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 9, "join_mo": 3, "join_yr": 2015, "languanges_known": "Arabic", "name": "Treva Nicolas", "salary": 22384, "skills": "Testing" } } ], "status": "success", "metrics": { "elapsedTime": "6.115446ms", "executionTime": "6.067402ms", "resultCount": 10, "resultSize": 4327, "serviceLoad": 6, "mutationCount": 10 } } cbq> SAVEPOINT a1; { "requestID": "2f23863a-5b3e-40de-a49e-b97cf6a7bccc", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "245.755µs", "executionTime": "193.617µs", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> UPDATE default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` USE KEYS ['test_collections-226', 'test_collections-1082', 'test_collections-1677', 'test_collections-1626', 'test_collections-1602', 'test_collections-839', 'test_collections-917', 'test_collections-1520', 'test_collections-1064', 'test_collections-1305', 'test_collections-1969', 'test_collections-1242', 'test_collections-663', 'test_collections-775', 'test_collections-1355', 'test_collections-752', 'test_collections-994', 'test_collections-615', 'test_collections-1461', 'test_collections-422'] SET rating='exceeded_expectation' RETURNING meta().id; { "requestID": "c5984029-cbcf-47a0-923e-2a01e8eb4d9c", "signature": { "id": "json" }, "results": [ { "id": "test_collections-226" }, { "id": "test_collections-1082" }, { "id": "test_collections-1677" }, { "id": "test_collections-1626" }, { "id": "test_collections-1602" }, { "id": "test_collections-839" }, { "id": "test_collections-917" }, { "id": "test_collections-1520" }, { "id": "test_collections-1064" }, { "id": "test_collections-1305" }, { "id": "test_collections-1969" }, { "id": "test_collections-1242" }, { "id": "test_collections-663" }, { "id": "test_collections-775" }, { "id": "test_collections-1355" }, { "id": "test_collections-752" }, { "id": "test_collections-994" }, { "id": "test_collections-615" }, { "id": "test_collections-1461" }, { "id": "test_collections-422" } ], "status": "success", "metrics": { "elapsedTime": "3.824252ms", "executionTime": "3.726097ms", "resultCount": 20, "resultSize": 891, "serviceLoad": 6, "mutationCount": 20 } } cbq> SELECT * from default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` WHERE META().id in ['test_collections-226', 'test_collections-1082', 'test_collections-1677', 'test_collections-1626', 'test_collections-1602', 'test_collections-839', 'test_collections-917', 'test_collections-1520', 'test_collections-1064', 'test_collections-1305', 'test_collections-1969', 'test_collections-1242', 'test_collections-663', 'test_collections-775', 'test_collections-1355', 'test_collections-752', 'test_collections-994', 'test_collections-615', 'test_collections-1461', 'test_collections-422']; { "requestID": "82074aaf-353a-4975-bd68-92b51cafdfbd", "signature": { "*": "*" }, "results": [ { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 9477, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 21, "join_mo": 7, "join_yr": 2016, "languanges_known": "Sinhalese", "name": "Basha Sebastian", "rating": "exceeded_expectation", "salary": 70783, "skills": "Development" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1732, "is_manager": 0, "job_title": "Sales", "join_day": 19, "join_mo": 7, "join_yr": 2010, "languanges_known": "Dutch", "name": "Killian Howard Jr.", "rating": "exceeded_expectation", "salary": 116409, "skills": "C++" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1986, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 18, "join_mo": 8, "join_yr": 2011, "languanges_known": "German", "name": "Bryn Phillips", "rating": "exceeded_expectation", "salary": 63727, "skills": "Testing" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 499, "is_manager": 0, "job_title": "Sales", "join_day": 14, "join_mo": 4, "join_yr": 2010, "languanges_known": "English", "name": "Salina Tomas", "rating": "exceeded_expectation", "salary": 100985, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 1577, "is_manager": 1, "job_title": "Training", "join_day": 23, "join_mo": 2, "join_yr": 2015, "languanges_known": "German", "name": "Adena Green", "rating": "exceeded_expectation", "salary": 176631, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 5254, "is_manager": 1, "job_title": "Engineer", "join_day": 13, "join_mo": 1, "join_yr": 2011, "languanges_known": "English", "name": "Trista cox", "rating": "exceeded_expectation", "salary": 168016, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 9602, "is_manager": 0, "job_title": "Training", "join_day": 3, "join_mo": 6, "join_yr": 2015, "languanges_known": "Arabic", "name": "Fantine copper", "rating": "exceeded_expectation", "salary": 127769, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 2157, "is_manager": 0, "job_title": "Accounts", "join_day": 12, "join_mo": 3, "join_yr": 2011, "languanges_known": "Spanish", "name": "Ambika Brown", "rating": "exceeded_expectation", "salary": 70942, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "USA", "emp_id": 2793, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 20, "join_mo": 7, "join_yr": 2011, "languanges_known": "Dutch", "name": "Bryn Reed", "rating": "exceeded_expectation", "salary": 25681, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 149, "is_manager": 1, "job_title": "Accounts", "join_day": 26, "join_mo": 7, "join_yr": 2016, "languanges_known": "Quechua", "name": "Lysha Damian", "rating": "exceeded_expectation", "salary": 100033, "skills": "Testing" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1976, "is_manager": 0, "job_title": "Sales", "join_day": 1, "join_mo": 1, "join_yr": 2016, "languanges_known": "Dutch", "name": "Mia Russell", "rating": "exceeded_expectation", "salary": 168982, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "India", "emp_id": 1998, "is_manager": 0, "job_title": "Dev-ops", "join_day": 25, "join_mo": 4, "join_yr": 2012, "languanges_known": "German", "name": "Ambika Lee", "rating": "exceeded_expectation", "salary": 160144, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "AUSTRALIA", "emp_id": 7437, "is_manager": 1, "job_title": "Cloud", "join_day": 26, "join_mo": 9, "join_yr": 2015, "languanges_known": "Japanese", "name": "Trista cox", "rating": "exceeded_expectation", "salary": 41080, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 5581, "is_manager": 0, "job_title": "Sales", "join_day": 5, "join_mo": 7, "join_yr": 2016, "languanges_known": "Arabic", "name": "Lysha Juan Jose", "rating": "exceeded_expectation", "salary": 177805, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "AUSTRALIA", "emp_id": 6529, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 1, "join_mo": 5, "join_yr": 2013, "languanges_known": "Sinhalese", "name": "Maura Evans", "rating": "exceeded_expectation", "salary": 84654, "skills": "Java" } }, { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 6912, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 22, "join_mo": 2, "join_yr": 2013, "languanges_known": "Spanish", "name": "Adena Damian", "rating": "exceeded_expectation", "salary": 129417, "skills": "C++" } }, { "_default": { "Working_country": "USA", "citizen_of": "CANADA", "emp_id": 5575, "is_manager": 1, "job_title": "Info-Tech", "join_day": 6, "join_mo": 7, "join_yr": 2010, "languanges_known": "Hindi", "name": "Salina Brown", "rating": "exceeded_expectation", "salary": 64080, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4823, "is_manager": 1, "job_title": "Cloud", "join_day": 28, "join_mo": 5, "join_yr": 2011, "languanges_known": "Quechua", "name": "Drucilla copper", "rating": "exceeded_expectation", "salary": 179667, "skills": "C++" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "AUSTRALIA", "emp_id": 3747, "is_manager": 1, "job_title": "Info-Tech", "join_day": 4, "join_mo": 3, "join_yr": 2013, "languanges_known": "Africans", "name": "Basha Davis", "rating": "exceeded_expectation", "salary": 54811, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 6519, "is_manager": 1, "job_title": "", "join_day": 5, "join_mo": 2, "join_yr": 2016, "languanges_known": "Hindi", "name": "Salina Wilson", "rating": "exceeded_expectation", "salary": 69347, "skills": "Testing" } } ], "status": "success", "metrics": { "elapsedTime": "4.648779ms", "executionTime": "4.589293ms", "resultCount": 20, "resultSize": 9520, "serviceLoad": 6 } } cbq> SAVEPOINT a1; { "requestID": "afac7626-8b44-4e85-b56b-8574cff0d848", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "326.273µs", "executionTime": "266.738µs", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> INSERT INTO default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` t WHERE job_title='Pre-Sales' LIMIT 10 RETURNING *; { "requestID": "39187e54-4eae-4496-81af-34f75681dc9e", "signature": { "*": "*" }, "results": [ ], "errors": [ { "code": 17012, "msg": "Duplicate Key: Lysha Lee" } ], "status": "errors", "metrics": { "elapsedTime": "5.723533ms", "executionTime": "5.599645ms", "resultCount": 0, "resultSize": 0, "serviceLoad": 6, "errorCount": 1 } } cbq> SAVEPOINT a1; { "requestID": "332566dd-c89f-403f-b1c6-695f0f885a02", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "274.65µs", "executionTime": "173.683µs", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> UPDATE default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` USE KEYS ['test_collections-852', 'test_collections-27', 'test_collections-1264', 'test_collections-188', 'test_collections-1405', 'test_collections-1095', 'test_collections-268', 'test_collections-1390', 'test_collections-1206', 'test_collections-183', 'test_collections-172', 'test_collections-815', 'test_collections-1502', 'test_collections-1348', 'test_collections-1394', 'test_collections-420', 'test_collections-1299', 'test_collections-1225', 'test_collections-202', 'test_collections-875'] SET joined='towards_end' RETURNING meta().id; { "requestID": "d12596de-4975-4ce1-873a-33fe53d119cd", "signature": { "id": "json" }, "results": [ { "id": "test_collections-852" }, { "id": "test_collections-27" }, { "id": "test_collections-1264" }, { "id": "test_collections-188" }, { "id": "test_collections-1405" }, { "id": "test_collections-1095" }, { "id": "test_collections-268" }, { "id": "test_collections-1390" }, { "id": "test_collections-1206" }, { "id": "test_collections-183" }, { "id": "test_collections-172" }, { "id": "test_collections-1502" }, { "id": "test_collections-1348" }, { "id": "test_collections-1394" }, { "id": "test_collections-420" }, { "id": "test_collections-1299" }, { "id": "test_collections-1225" }, { "id": "test_collections-202" }, { "id": "test_collections-875" } ], "status": "success", "metrics": { "elapsedTime": "4.637751ms", "executionTime": "4.521493ms", "resultCount": 19, "resultSize": 845, "serviceLoad": 6, "mutationCount": 19 } } cbq> SELECT * from default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` WHERE META().id in ['test_collections-852', 'test_collections-27', 'test_collections-1264', 'test_collections-188', 'test_collections-1405', 'test_collections-1095', 'test_collections-268', 'test_collections-1390', 'test_collections-1206', 'test_collections-183', 'test_collections-172', 'test_collections-815', 'test_collections-1502', 'test_collections-1348', 'test_collections-1394', 'test_collections-420', 'test_collections-1299', 'test_collections-1225', 'test_collections-202', 'test_collections-875']; { "requestID": "8be41b76-6cb2-47f3-8c83-4a6b39ff93bd", "signature": { "*": "*" }, "results": [ { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 51, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 11, "join_mo": 8, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Hindi", "name": "Deirdre Juan Jose", "salary": 144818, "skills": "C++" } }, { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 2467, "is_manager": 1, "job_title": "Engineer", "join_day": 25, "join_mo": 11, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Africans", "name": "Fantine Phillips", "salary": 104357, "skills": "Development" } }, { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 7909, "is_manager": 0, "job_title": "Info-Tech", "join_day": 10, "join_mo": 3, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Italian", "name": "Kallie Wright", "salary": 129199, "skills": "Testing" } }, { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 4176, "is_manager": 0, "job_title": "Sales", "join_day": 1, "join_mo": 2, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Alvita Reed", "salary": 180835, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 2739, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 19, "join_mo": 6, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Portuguese", "name": "Treva Wright", "salary": 80374, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 7294, "is_manager": 1, "job_title": "Sales", "join_day": 20, "join_mo": 3, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Urdu", "name": "Winta Evans", "salary": 145394, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 2116, "is_manager": 1, "job_title": "Accounts", "join_day": 8, "join_mo": 3, "join_yr": 2010, "joined": "towards_end", "languanges_known": "Vietnamese", "name": "Killian Davis", "salary": 16854, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 8280, "is_manager": 1, "job_title": "Engineer", "join_day": 7, "join_mo": 6, "join_yr": 2016, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Quella Julian", "salary": 68988, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 240, "is_manager": 1, "job_title": "", "join_day": 7, "join_mo": 6, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Dutch", "name": "Cassandra Green", "salary": 111294, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 8442, "is_manager": 1, "job_title": "Dev-ops", "join_day": 2, "join_mo": 11, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Winta Jones", "salary": 166260, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 7311, "is_manager": 0, "job_title": "Accounts", "join_day": 11, "join_mo": 3, "join_yr": 2010, "joined": "towards_end", "languanges_known": "Hindi", "name": "Kacila Nicolas", "salary": 113211, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "USA", "emp_id": 5445, "is_manager": 1, "job_title": "Training", "join_day": 24, "join_mo": 4, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Arabic", "name": "Sirena Scott", "salary": 16789, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "India", "emp_id": 7330, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 11, "join_mo": 4, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Malay", "name": "Lysha copper", "salary": 12792, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4890, "is_manager": 1, "job_title": "Dev-ops", "join_day": 27, "join_mo": 5, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Italian", "name": "Jerica Palmer", "salary": 102743, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "USA", "emp_id": 2802, "is_manager": 1, "job_title": "", "join_day": 5, "join_mo": 7, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Hindi", "name": "Alvita Carter", "salary": 49544, "skills": "Development" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4740, "is_manager": 0, "job_title": "Dev-ops", "join_day": 6, "join_mo": 2, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Urdu", "name": "Kallie Baker", "salary": 41007, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 1117, "is_manager": 1, "job_title": "Accounts", "join_day": 7, "join_mo": 2, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Quechua", "name": "Fantine Reed", "salary": 106934, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "CANADA", "emp_id": 561, "is_manager": 1, "job_title": "Sales", "join_day": 10, "join_mo": 2, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Japanese", "name": "Cassandra Palmer", "salary": 188801, "skills": "Development" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 9361, "is_manager": 1, "job_title": "Cloud", "join_day": 19, "join_mo": 2, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Sinhalese", "name": "Salina Bailey", "salary": 166778, "skills": "C++" } } ], "status": "success", "metrics": { "elapsedTime": "5.729814ms", "executionTime": "5.681502ms", "resultCount": 19, "resultSize": 8897, "serviceLoad": 6 } } cbq> SAVEPOINT a1; { "requestID": "bbbd5fad-8e69-4aa9-ae1c-a565c8a27784", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "293.274µs", "executionTime": "206.046µs", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> SELECT * FROM system:transactions; { "requestID": "34b111fa-a292-4a86-90f1-9e176ff322c5", "signature": { "*": "*" }, "results": [ { "transactions": { "durabilityLevel": "majority", "durabilityTimeout": "2.5s", "expiryTime": "2021-01-08T00:33:28.57-08:00", "id": "07a40641-773f-41db-977b-0809d7024294", "isolationLevel": "READ COMMITED", "lastUse": "2021-01-08T00:31:28.784-08:00", "node": "10.112.190.101:8091", "scanConsistency": "scan_plus", "status": 1, "timeout": "2m0s", "uses": 13 } } ], "status": "success", "metrics": { "elapsedTime": "3.132499ms", "executionTime": "3.027418ms", "resultCount": 1, "resultSize": 512, "serviceLoad": 6 } } cbq> COMMIT WORK; { "requestID": "2f478e23-3619-4d7d-9411-c5145d387a27", "signature": "json", "results": [ ], "status": "success", "metrics": { "elapsedTime": "125.619385ms", "executionTime": "125.523398ms", "resultCount": 0, "resultSize": 0, "serviceLoad": 6 } } cbq> SELECT * from default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` WHERE META().id in ['test_collections-226', 'test_collections-1082', 'test_collections-1677', 'test_collections-1626', 'test_collections-1602', 'test_collections-839', 'test_collections-917', 'test_collections-1520', 'test_collections-1064', 'test_collections-1305', 'test_collections-1969', 'test_collections-1242', 'test_collections-663', 'test_collections-775', 'test_collections-1355', 'test_collections-752', 'test_collections-994', 'test_collections-615', 'test_collections-1461', 'test_collections-422']; { "requestID": "ae392a40-1c4b-459d-b89b-ffd385362e9d", "signature": { "*": "*" }, "results": [ { "_default": { "Working_country": "USA", "citizen_of": "CANADA", "emp_id": 5575, "is_manager": 1, "job_title": "Info-Tech", "join_day": 6, "join_mo": 7, "join_yr": 2010, "languanges_known": "Hindi", "name": "Salina Brown", "salary": 64080, "skills": "Java" } }, { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 6912, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 22, "join_mo": 2, "join_yr": 2013, "languanges_known": "Spanish", "name": "Adena Damian", "salary": 129417, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 6519, "is_manager": 1, "job_title": "", "join_day": 5, "join_mo": 2, "join_yr": 2016, "languanges_known": "Hindi", "name": "Salina Wilson", "salary": 69347, "skills": "Testing" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "USA", "emp_id": 2793, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 20, "join_mo": 7, "join_yr": 2011, "languanges_known": "Dutch", "name": "Bryn Reed", "salary": 25681, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 1577, "is_manager": 1, "job_title": "Training", "join_day": 23, "join_mo": 2, "join_yr": 2015, "languanges_known": "German", "name": "Adena Green", "salary": 176631, "skills": "Java" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "India", "emp_id": 1998, "is_manager": 0, "job_title": "Dev-ops", "join_day": 25, "join_mo": 4, "join_yr": 2012, "languanges_known": "German", "name": "Ambika Lee", "salary": 160144, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 499, "is_manager": 0, "job_title": "Sales", "join_day": 14, "join_mo": 4, "join_yr": 2010, "languanges_known": "English", "name": "Salina Tomas", "salary": 100985, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 9477, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 21, "join_mo": 7, "join_yr": 2016, "languanges_known": "Sinhalese", "name": "Basha Sebastian", "salary": 70783, "skills": "Development" } }, { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 5254, "is_manager": 1, "job_title": "Engineer", "join_day": 13, "join_mo": 1, "join_yr": 2011, "languanges_known": "English", "name": "Trista cox", "salary": 168016, "skills": "Testing" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 149, "is_manager": 1, "job_title": "Accounts", "join_day": 26, "join_mo": 7, "join_yr": 2016, "languanges_known": "Quechua", "name": "Lysha Damian", "salary": 100033, "skills": "Testing" } }, { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 2157, "is_manager": 0, "job_title": "Accounts", "join_day": 12, "join_mo": 3, "join_yr": 2011, "languanges_known": "Spanish", "name": "Ambika Brown", "salary": 70942, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1976, "is_manager": 0, "job_title": "Sales", "join_day": 1, "join_mo": 1, "join_yr": 2016, "languanges_known": "Dutch", "name": "Mia Russell", "salary": 168982, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1732, "is_manager": 0, "job_title": "Sales", "join_day": 19, "join_mo": 7, "join_yr": 2010, "languanges_known": "Dutch", "name": "Killian Howard Jr.", "salary": 116409, "skills": "C++" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 1986, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 18, "join_mo": 8, "join_yr": 2011, "languanges_known": "German", "name": "Bryn Phillips", "salary": 63727, "skills": "Testing" } }, { "_default": { "Working_country": "USA", "citizen_of": "AUSTRALIA", "emp_id": 7437, "is_manager": 1, "job_title": "Cloud", "join_day": 26, "join_mo": 9, "join_yr": 2015, "languanges_known": "Japanese", "name": "Trista cox", "salary": 41080, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 9602, "is_manager": 0, "job_title": "Training", "join_day": 3, "join_mo": 6, "join_yr": 2015, "languanges_known": "Arabic", "name": "Fantine copper", "salary": 127769, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4823, "is_manager": 1, "job_title": "Cloud", "join_day": 28, "join_mo": 5, "join_yr": 2011, "languanges_known": "Quechua", "name": "Drucilla copper", "salary": 179667, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 5581, "is_manager": 0, "job_title": "Sales", "join_day": 5, "join_mo": 7, "join_yr": 2016, "languanges_known": "Arabic", "name": "Lysha Juan Jose", "salary": 177805, "skills": "Python" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "AUSTRALIA", "emp_id": 3747, "is_manager": 1, "job_title": "Info-Tech", "join_day": 4, "join_mo": 3, "join_yr": 2013, "languanges_known": "Africans", "name": "Basha Davis", "salary": 54811, "skills": "Java" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "AUSTRALIA", "emp_id": 6529, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 1, "join_mo": 5, "join_yr": 2013, "languanges_known": "Sinhalese", "name": "Maura Evans", "salary": 84654, "skills": "Java" } } ], "status": "success", "metrics": { "elapsedTime": "11.70773ms", "executionTime": "11.644854ms", "resultCount": 20, "resultSize": 8600, "serviceLoad": 25 } } cbq> SELECT * from default:`9dGcEmYNseE6iW2A5Ea-4-854000`.`_default`.`_default` WHERE META().id in ['test_collections-852', 'test_collections-27', 'test_collections-1264', 'test_collections-188', 'test_collections-1405', 'test_collections-1095', 'test_collections-268', 'test_collections-1390', 'test_collections-1206', 'test_collections-183', 'test_collections-172', 'test_collections-815', 'test_collections-1502', 'test_collections-1348', 'test_collections-1394', 'test_collections-420', 'test_collections-1299', 'test_collections-1225', 'test_collections-202', 'test_collections-875']; { "requestID": "786257ed-2614-4237-8e24-1302b5e331f7", "signature": { "*": "*" }, "results": [ { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 2467, "is_manager": 1, "job_title": "Engineer", "join_day": 25, "join_mo": 11, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Africans", "name": "Fantine Phillips", "salary": 104357, "skills": "Development" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 2739, "is_manager": 0, "job_title": "Pre-Sales", "join_day": 19, "join_mo": 6, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Portuguese", "name": "Treva Wright", "salary": 80374, "skills": "Java" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 7294, "is_manager": 1, "job_title": "Sales", "join_day": 20, "join_mo": 3, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Urdu", "name": "Winta Evans", "salary": 145394, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4740, "is_manager": 0, "job_title": "Dev-ops", "join_day": 6, "join_mo": 2, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Urdu", "name": "Kallie Baker", "salary": 41007, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 8280, "is_manager": 1, "job_title": "Engineer", "join_day": 7, "join_mo": 6, "join_yr": 2016, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Quella Julian", "salary": 68988, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "India", "emp_id": 240, "is_manager": 1, "job_title": "", "join_day": 7, "join_mo": 6, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Dutch", "name": "Cassandra Green", "salary": 111294, "skills": "Java" } }, { "_default": { "Working_country": "India", "citizen_of": "AUSTRALIA", "emp_id": 7909, "is_manager": 0, "job_title": "Info-Tech", "join_day": 10, "join_mo": 3, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Italian", "name": "Kallie Wright", "salary": 129199, "skills": "Testing" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "CANADA", "emp_id": 561, "is_manager": 1, "job_title": "Sales", "join_day": 10, "join_mo": 2, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Japanese", "name": "Cassandra Palmer", "salary": 188801, "skills": "Development" } }, { "_default": { "Working_country": "AUSTRALIA", "citizen_of": "India", "emp_id": 7330, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 11, "join_mo": 4, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Malay", "name": "Lysha copper", "salary": 12792, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "CANADA", "emp_id": 51, "is_manager": 1, "job_title": "Pre-Sales", "join_day": 11, "join_mo": 8, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Hindi", "name": "Deirdre Juan Jose", "salary": 144818, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 4890, "is_manager": 1, "job_title": "Dev-ops", "join_day": 27, "join_mo": 5, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Italian", "name": "Jerica Palmer", "salary": 102743, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "AUSTRALIA", "emp_id": 1117, "is_manager": 1, "job_title": "Accounts", "join_day": 7, "join_mo": 2, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Quechua", "name": "Fantine Reed", "salary": 106934, "skills": "Python" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "India", "emp_id": 2116, "is_manager": 1, "job_title": "Accounts", "join_day": 8, "join_mo": 3, "join_yr": 2010, "joined": "towards_end", "languanges_known": "Vietnamese", "name": "Killian Davis", "salary": 16854, "skills": "C++" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 8442, "is_manager": 1, "job_title": "Dev-ops", "join_day": 2, "join_mo": 11, "join_yr": 2012, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Winta Jones", "salary": 166260, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "USA", "emp_id": 7311, "is_manager": 0, "job_title": "Accounts", "join_day": 11, "join_mo": 3, "join_yr": 2010, "joined": "towards_end", "languanges_known": "Hindi", "name": "Kacila Nicolas", "salary": 113211, "skills": "Python" } }, { "_default": { "Working_country": "India", "citizen_of": "USA", "emp_id": 5445, "is_manager": 1, "job_title": "Training", "join_day": 24, "join_mo": 4, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Arabic", "name": "Sirena Scott", "salary": 16789, "skills": "Python" } }, { "_default": { "Working_country": "USA", "citizen_of": "India", "emp_id": 4176, "is_manager": 0, "job_title": "Sales", "join_day": 1, "join_mo": 2, "join_yr": 2011, "joined": "towards_end", "languanges_known": "Nepalese", "name": "Alvita Reed", "salary": 180835, "skills": "Testing" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "USA", "emp_id": 2802, "is_manager": 1, "job_title": "", "join_day": 5, "join_mo": 7, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Hindi", "name": "Alvita Carter", "salary": 49544, "skills": "Development" } }, { "_default": { "Working_country": "CANADA", "citizen_of": "CANADA", "emp_id": 9361, "is_manager": 1, "job_title": "Cloud", "join_day": 19, "join_mo": 2, "join_yr": 2014, "joined": "towards_end", "languanges_known": "Sinhalese", "name": "Salina Bailey", "salary": 166778, "skills": "C++" } } ], "status": "success", "metrics": { "elapsedTime": "14.921282ms", "executionTime": "14.866929ms", "resultCount": 19, "resultSize": 8897, "serviceLoad": 25 } } cbq> cbq>