Script started on Mon 14 Jan 2019 03:15:17 PM PST dekhtyar@ambari-head:~/369/logs$ dekhtyar@ambari-head:~/369/logs$ mongo MongoDB shell version v4.0.5 connecting to: mongodb://127.0.0.1:27017/?gssapiServiceName=mongodb Implicit session: session { "id" : UUID("9668f7ab-16d6-4e54-84b4-d40f9e08870b") } MongoDB server version: 4.0.5 ambariMongo:PRIMARY> use abuse adminuse admin switched to db admin ambariMongo:PRIMARY> db.aodb.auth("alex","absdb.auth("alex","abc123")db.auth("alex","abc123") 1 ambariMongo:PRIMARY> use alexuse alex switched to db alex ambariMongo:PRIMARY> show databsaesshow databsaeshow databsashow databsshow databasesshow databases acengel 0.000GB admin 0.000GB alex 0.000GB awengel 0.000GB blhanna 0.000GB config 0.000GB dekhtyar 0.000GB iafong 0.000GB jhan28 0.000GB jlandy 0.000GB ksoe 0.000GB lfverast 0.000GB lnarayan 0.000GB local 0.000GB lthomp19 0.000GB new 0.000GB nparra 0.000GB skariyad 0.000GB ambariMongo:PRIMARY> show collectionsshow collections classes data test ambariMongo:PRIMARY> db/db.tedb.tdb.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } ambariMongo:PRIMARY> db.test.insert({"name"db.test.insert({"name":"foobr"db.test.insert({"name":"foobrdb.test.insert({"name":"foobar", count:5"db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.test.insert({"name":"foobar", count:5})db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } ambariMongo:PRIMARY> db.test.find()db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.test.insert({"name":"foobar", count:5})db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19355fb2540bdd7394de"), "name" : "foobar", "count" : 5 } ambariMongo:PRIMARY> db.test.find()db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({"name":"foobar", count:5})db.test.insert({_"name":"foobar", count:5})db.test.insert({_i"name":"foobar", count:5})db.test.insert({_id"name":"foobar", count:5})db.test.insert({_id:"name":"foobar", count:5})db.test.insert({_id:1"name":"foobar", count:5})db.test.insert({_id:1,"name":"foobar", count:5})db.test.insert({_id:1, "name":"foobar", count:5})db.test.insert({_id:1, "name":"foobar", count:5}) WriteResult({ "nInserted" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: alex.test index: _id_ dup key: { : 1.0 }" } }) ambariMongo:PRIMARY> db.test.insert({_id:1, "name":"foobar", count:5})db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19355fb2540bdd7394de"), "name" : "foobar", "count" : 5 } ambariMongo:PRIMARY> db.test.find()db.test.insert({_id:1, "name":"foobar", count:5})db.test.insert({_id:1, "name":"foobar", count:5})db.test.insert({_id:1, "name":"foobar", count:5)db.test.insert({_id:1, "name":"foobar", count:)db.test.insert({_id:1, "name":"foobar", count)db.test.insert({_id:1, "name":"foobar", coun)db.test.insert({_id:1, "name":"foobar", cou)db.test.insert({_id:1, "name":"foobar", co)db.test.insert({_id:1, "name":"foobar", c)db.test.insert({_id:1, "name":"foobar", )db.test.insert({_id:1, "name":"foobar",)db.test.insert({_id:1, "name":"foobar")db.test.insert({_id:1, "name":"foobar)db.test.insert({_id:1, "name":"fooba)db.test.insert({_id:1, "name":"foob)db.test.insert({_id:1, "name":"foo)db.test.insert({_id:1, "name":"fo)db.test.insert({_id:1, "name":"f)db.test.insert({_id:1, "name":")db.test.insert({_id:1, "name":)db.test.insert({_id:1, "name")db.test.insert({_id:1, "name)db.test.insert({_id:1, "nam)db.test.insert({_id:1, "na)db.test.insert({_id:1, "n)db.test.insert({_id:1, ")db.test.insert({_id:1, )db.test.insert({_id:1,)db.test.insert({_id:1)db.test.insert({_id:)db.test.insert({_id)db.test.insert({_i)db.test.insert({_)db.test.insert({)db.test.insert()db.test.insert()db.test.insert([{:db.test.insert([{a:27}, {b:18}, {a:27, b:18}])db.test.insert([{a:27}, {b:18}, {a:27, b:18}]) BulkWriteResult({ "writeErrors" : [ ], "writeConcernErrors" : [ ], "nInserted" : 3, "nUpserted" : 0, "nMatched" : 0, "nModified" : 0, "nRemoved" : 0, "upserted" : [ ] }) ambariMongo:PRIMARY> db.test.insert([{a:27}, {b:18}, {a:27, b:18}])db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19355fb2540bdd7394de"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394df"), "a" : 27 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e0"), "b" : 18 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e1"), "a" : 27, "b" : 18 } ambariMongo:PRIMARY> db.test.find()db.test.insert([{a:27}, {b:18}, {a:27, b:18}])db.test.insert([{a:27}, {b:18}, {a:27, b:18}])db.test.insert([{a:27}, {b:18}, {a:27, b:18}])db.test.insert([{a:27}, {b:18}, {a:27, b:18])db.test.insert([{a:27}, {b:18}, {a:27, b:1])db.test.insert([{a:27}, {b:18}, {a:27, b:])db.test.insert([{a:27}, {b:18}, {a:27, b])db.test.insert([{a:27}, {b:18}, {a:27, ])db.test.insert([{a:27}, {b:18}, {a:27,])db.test.insert([{a:27}, {b:18}, {a:27])db.test.insert([{a:27}, {b:18}, {a:2])db.test.insert([{a:27}, {b:18}, {a:])db.test.insert([{a:27}, {b:18}, {a])db.test.insert([{a:27}, {b:18}, {])db.test.insert([{a:27}, {b:18}, ])db.test.insert([{a:27}, {b:18},])db.test.insert([{a:27}, {b:18}])db.test.insert([{a:27}, {b:18])db.test.insert([{a:27}, {b:1])db.test.insert([{a:27}, {b:])db.test.insert([{a:27}, {b])db.test.insert([{a:27}, {])db.test.insert([{a:27}, ])db.test.insert([{a:27},])db.test.insert([{a:27}])db.test.insert([{a:27])db.test.insert([{a:2])db.test.insert([{a:])db.test.insert([{a])db.test.insert([{])db.test.insert([])db.test.insert([1])db.test.insert([1.])db.test.insert([1])db.test.insert([1,])db.test.insert([1,2])db.test.insert([1,2,])db.test.insert([1,2,3])db.test.insert([1,2,3,])db.test.insert([1,2,3,4])db.test.insert([1,2,3,4]) 2019-01-14T15:24:58.639-0800 E QUERY [js] Error: argument to bsonsize has to be an object : Bulk/addToOperationsList@src/mongo/shell/bulk_api.js:611:28 Bulk/this.insert@src/mongo/shell/bulk_api.js:654:20 DBCollection.prototype.insert/<@src/mongo/shell/collection.js:315:17 DBCollection.prototype.insert@src/mongo/shell/collection.js:314:13 @(shell):1:1 ambariMongo:PRIMARY> db.test.insert([1,2,3,4])db.test.insert([1,2,3,4])db.test.insert([1,2,3,4)db.test.insert([1,2,3,)db.test.insert([1,2,3)db.test.insert([1,2,)db.test.insert([1,2)db.test.insert([1,)db.test.insert([1)db.test.insert([)db.test.insert()db.test.find()db.test.find({_id:10, db.test.find({_id:10,db.test.find({_id:10db.test.find({_id:1db.test.find({_id:db.test.find({_iddb.test.find({_idb.test.find({_db.test.find({db.test.find(db.test.finddb.test.findb.test.fidb.test.fdb.test.insert)db.test.insert({_ddb.test.insert({_id:10, nmedb.test.insert({_id:10, nmdb.test.insert({_id:10, name: "Bob", classes:["CSC349, db.test.insert({_id:10, name: "Bob", classes:["CSC349,db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]})db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]})db.test.insert([1,2,3,4])db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19355fb2540bdd7394de"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394df"), "a" : 27 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e0"), "b" : 18 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e1"), "a" : 27, "b" : 18 } { "_id" : 10, "name" : "Bob", "classes" : [ "CSC349", "CSC369" ] } ambariMongo:PRIMARY> db.test.find()db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]})db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]}db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"]db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369"db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC369db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC36db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSC3db.test.insert({_id:10, name: "Bob", classes:["CSC349","CSCdb.test.insert({_id:10, name: "Bob", classes:["CSC349","CSdb.test.insert({_id:10, name: "Bob", classes:["CSC349","Cdb.test.insert({_id:10, name: "Bob", classes:["CSC349","db.test.insert({_id:10, name: "Bob", classes:["CSC349",db.test.insert({_id:10, name: "Bob", classes:["CSC349"db.test.insert({_id:10, name: "Bob", classes:["CSC349db.test.insert({_id:10, name: "Bob", classes:["CSC34db.test.insert({_id:10, name: "Bob", classes:["CSC3db.test.insert({_id:10, name: "Bob", classes:["CSCdb.test.insert({_id:10, name: "Bob", classes:["CSdb.test.insert({_id:10, name: "Bob", classes:["Cdb.test.insert({_id:10, name: "Bob", classes:["db.test.insert({_id:10, name: "Bob", classes:[db.test.insert({_id:10, name: "Bob", classes:db.test.insert({_id:10, name: "Bob", classesdb.test.insert({_id:10, name: "Bob", classedb.test.insert({_id:10, name: "Bob", classdb.test.insert({_id:10, name: "Bob", clasdb.test.insert({_id:10, name: "Bob", cladb.test.insert({_id:10, name: "Bob", cldb.test.insert({_id:10, name: "Bob", cdb.test.insert({_id:10, name: "Bob", db.test.insert({_id:10, name: "Bob",db.test.insert({_id:10, name: "Bob"db.test.insert({_id:10, name: "Bobdb.test.insert({_id:10, name: "Bodb.test.insert({_id:10, name: "Bdb.test.insert({_id:10, name: "db.test.insert({_id:10, name: db.test.insert({_id:10, name:db.test.insert({_id:10, namedb.test.insert({_id:10, namdb.test.insert({_id:10, nadb.test.insert({_id:10, ndb.test.insert({_id:10, db.test.insert({_id:10,db.test.insert({_id:10db.test.insert({_id:11, adb.test.insert({_id:11, name: "Mary", address"db.test.insert({_id:11, name: "Mary", address: db.test.insert({_id:11, name: "Mary", address:  ... {street:"123 Cherry Hill Terrace", city: "San Francisco"}}){street:"123 Cherry Hill Terrace", city: "San Francisco"}}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.test.insert({_id:11, name: "Mary", address: {street:"123 Cherry Hill Terrace", city: "San Francisco"}})db.test.find()db.test.find() { "_id" : 1, "name" : "test" } { "_id" : 2, "name" : "test2" } { "_id" : 3, "name" : "hello csc369" } { "_id" : ObjectId("5c3d191a5fb2540bdd7394dd"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19355fb2540bdd7394de"), "name" : "foobar", "count" : 5 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394df"), "a" : 27 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e0"), "b" : 18 } { "_id" : ObjectId("5c3d19ea5fb2540bdd7394e1"), "a" : 27, "b" : 18 } { "_id" : 10, "name" : "Bob", "classes" : [ "CSC349", "CSC369" ] } { "_id" : 11, "name" : "Mary", "address" : { "street" : "123 Cherry Hill Terrace", "city" : "San Francisco" } } ambariMongo:PRIMARY> clearclear 2019-01-14T15:29:26.347-0800 E QUERY [js] ReferenceError: clear is not defined : @(shell):1:1 ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY> db.class.db.classdb.clasedb.clasedb.classes.cdb.classes.find()db.classes.find() { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY>  ambariMongo:PRIMARY> db.classes.find({})db.classes.find({})db.classes.find({})db.classes.find({c})db.classes.find({cl})db.classes.find({cla})db.classes.find({clas})db.classes.find({class})db.classes.find({class:})db.classes.find({class:"})db.classes.find({class:"C})db.classes.find({class:"CS})db.classes.find({class:"CSC})db.classes.find({class:"CSC })db.classes.find({class:"CSC 3})db.classes.find({class:"CSC 36})db.classes.find({class:"CSC 369})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"}) { "_id" : 1, "class" : "CSC 369", "roster" : 28 } ambariMongo:PRIMARY> d.db.classes.findb.classes.fidb.classes.fdb.classes.insert({_id:6:db.classes.insert({_id:6, class:"CSC 480",,db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"}db.classes.find({class:"CSC 369"db.classes.find({class:"CSC 369db.classes.find({class:"CSC 36db.classes.find({class:"CSC 3db.classes.find({class:"CSC db.classes.find({class:"CSCdb.classes.find({class:"CSdb.classes.find({class:"Cdb.classes.find({class:"db.classes.find({class:db.classes.find({classdb.classes.find({clasdb.classes.find({cladb.classes.find({cldb.classes.find({cdb.classes.find({db.classes.find()db.classes.find() { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } ambariMongo:PRIMARY> db.classes.find()db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.insert({_id:6, class:"CSC 480", name:"AI", roster:28})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369"})db.classes.find({class:"CSC 369})db.classes.find({class:"CSC 36})db.classes.find({class:"CSC 3})db.classes.find({class:"CSC })db.classes.find({class:"CSC})db.classes.find({class:"CS})db.classes.find({class:"C})db.classes.find({class:"})db.classes.find({class:})db.classes.find({class})db.classes.find({clas})db.classes.find({cla})db.classes.find({cl})db.classes.find({c})db.classes.find({})db.classes.find({r})db.classes.find({ro})db.classes.find({ros})db.classes.find({rost})db.classes.find({roste})db.classes.find({roster})db.classes.find({roster:})db.classes.find({roster:2})db.classes.find({roster:28})db.classes.find({roster:28}) { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } ambariMongo:PRIMARY> db.classes.find({roster:28})db.classes.find({roster:28})db.classes.find({roster:28},)db.classes.find({roster:28},{)db.classes.find({roster:28},{})db.classes.find({roster:28},{})db.classes.find({roster:28},{c})db.classes.find({roster:28},{cl})db.classes.find({roster:28},{cla})db.classes.find({roster:28},{clas})db.classes.find({roster:28},{class})db.classes.find({roster:28},{class:})db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1}) { "_id" : 1, "class" : "CSC 369" } { "_id" : 6, "class" : "CSC 480" } ambariMongo:PRIMARY> db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:})db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:0}) { "_id" : 1, "roster" : 28 } { "_id" : 6, "name" : "AI", "roster" : 28 } ambariMongo:PRIMARY> db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1,})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:1, r})db.classes.find({roster:28},{class:1, ro})db.classes.find({roster:28},{class:1, ros})db.classes.find({roster:28},{class:1, rost})db.classes.find({roster:28},{class:1, roste})db.classes.find({roster:28},{class:1, roster})db.classes.find({roster:28},{class:1, roster:})db.classes.find({roster:28},{class:1, roster:0})db.classes.find({roster:28},{class:1, roster:0}) Error: error: { "operationTime" : Timestamp(1547509068, 1), "ok" : 0, "errmsg" : "Projection cannot have a mix of inclusion and exclusion.", "code" : 2, "codeName" : "BadValue", "$clusterTime" : { "clusterTime" : Timestamp(1547509068, 1), "signature" : { "hash" : BinData(0,"zjiI6ciK6cnCi9Qz+xpIv6A8Lh0="), "keyId" : NumberLong("6646206189682032641") } } } ambariMongo:PRIMARY> db.classes.find({roster:28},{class:1, roster:0})db.classes.find({roster:28},{class:1, roster:0})db.classes.find({roster:28},{class:1, roster:0})db.classes.find({roster:28},{class:1, roster:})db.classes.find({roster:28},{class:1, roster})db.classes.find({roster:28},{class:1, roste})db.classes.find({roster:28},{class:1, rost})db.classes.find({roster:28},{class:1, ros})db.classes.find({roster:28},{class:1, ro})db.classes.find({roster:28},{class:1, r})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:1,})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1.})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1,})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1}) { "_id" : 1, "class" : "CSC 369" } { "_id" : 6, "class" : "CSC 480" } ambariMongo:PRIMARY> db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1,})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:1, i})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:1, _})db.classes.find({roster:28},{class:1, _i})db.classes.find({roster:28},{class:1, _id})db.classes.find({roster:28},{class:1, _id:})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:0}) { "class" : "CSC 369" } { "class" : "CSC 480" } ambariMongo:PRIMARY> db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1, _id:})db.classes.find({roster:28},{class:1, _id})db.classes.find({roster:28},{class:1, _i})db.classes.find({roster:28},{class:1, _})db.classes.find({roster:28},{class:1, })db.classes.find({roster:28},{class:1,})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{rclass:1})db.classes.find({roster:28},{roclass:1})db.classes.find({roster:28},{rosclass:1})db.classes.find({roster:28},{rostclass:1})db.classes.find({roster:28},{rosteclass:1})db.classes.find({roster:28},{rosterclass:1})db.classes.find({roster:28},{roster:class:1})db.classes.find({roster:28},{roster:1class:1})db.classes.find({roster:28},{roster:1,class:1})db.classes.find({roster:28},{roster:1,class:1}) { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 6, "class" : "CSC 480", "roster" : 28 } ambariMongo:PRIMARY> db.classes.find({roster:28},{roster:1,class:1})db.classes.find({roster:28},{class:1, _id:0})db.classes.find({roster:28},{class:1})db.classes.find({roster:28},{class:1, roster:0})db.classes.find({roster:28},{class:0})db.classes.find({roster:28},{class:1})db.classes.find({roster:28})db.classes.find()db.classes.find() { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } ambariMongo:PRIMARY> cdcdc.dcdb.classes.insert:{_id:7, "db.classes.insert:{_id:7, cdb.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"} 2019-01-14T15:40:55.537-0800 E QUERY [js] SyntaxError: missing ; before statement @(shell):1:17 ambariMongo:PRIMARY> db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert{_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.find()0db.classes.find({roster:28},{roster:1,class:1})db.classes.find()db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.insert{_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"}db.classes.insert({_id:7, roster:34, class:"CSC 202"})db.classes.insert({_id:7, roster:34, class:"CSC 202"}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.classes.insert({_id:7, roster:34, class:"CSC 202"})db.classes.insert:{_id:7, roster:34, class:"CSC 202"}db.classes.find()db.classes.find() { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } { "_id" : 7, "roster" : 34, "class" : "CSC 202" } ambariMongo:PRIMARY> db.classes.find().count()db.classes.find().count() 7 ambariMongo:PRIMARY> db.classes.find().count()db.classes.find()db.classes.find() { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } { "_id" : 7, "roster" : 34, "class" : "CSC 202" } ambariMongo:PRIMARY> db.classes.find()db.classes.find().count()db.classes.find().count() 7 ambariMongo:PRIMARY> db.classes.find().count()db.classes.find().count(db.classes.find().countdb.classes.find().coundb.classes.find().coudb.classes.find().codb.classes.find().cdb.classes.find().limit(3)db.classes.find().limit(3) { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } ambariMongo:PRIMARY> db.classes.find().limit(3)db.classes.find().limit(3)db.classes.find().limit(3)db.classes.find().limit(3)db.classes.find().limi(3)db.classes.find().lim(3)db.classes.find().li(3)db.classes.find().l(3)db.classes.find().(3)db.classes.find().s(3)db.classes.find().sk(3)db.classes.find().ski(3)db.classes.find().skip(3)db.classes.find().skip(3) { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } { "_id" : 7, "roster" : 34, "class" : "CSC 202" } ambariMongo:PRIMARY> db.classes.find().skip(3)db.classes.find().skip(3db.classes.find().skip(db.classes.find().skipdb.classes.find().skidb.classes.find().skdb.classes.find().sort{db.classes.find().sort9)db.classes.find().sort9db.classes.find().sort()db.classes.find().sort()db.classes.find().sort({)db.classes.find().sort({r)db.classes.find().sort({ro)db.classes.find().sort({ros)db.classes.find().sort({rost)db.classes.find().sort({roste)db.classes.find().sort({roster)db.classes.find().sort({roster:)db.classes.find().sort({roster:-)db.classes.find().sort({roster:-1)db.classes.find().sort({roster:-1})db.classes.find().sort({roster:-1}) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 7, "roster" : 34, "class" : "CSC 202" } { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).limit(1)db.classes.find().sort({roster:-1}).limit(1) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).limit(1)db.classes.find().sort({roster:-1}).limit(1db.classes.find().sort({roster:-1}).limit(db.classes.find().sort({roster:-1}).limitdb.classes.find().sort({roster:-1}).limidb.classes.find().sort({roster:-1}).limdb.classes.find().sort({roster:-1}).lidb.classes.find().sort({roster:-1}).ldb.classes.find().sort({roster:-1}).skip(30.db.classes.find().sort({roster:-1}).skip(30db.classes.find().sort({roster:-1}).skip(3).limit(1)db.classes.find().sort({roster:-1}).skip(3).limit(1) { "_id" : 7, "roster" : 34, "class" : "CSC 202" } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).skip(3).limit(1)db.classes.find().sort({roster:-1}).skip(3).limit(1db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1) { "_id" : 7, "roster" : 34, "class" : "CSC 202" } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3).limit(-1)db.classes.find().sort({roster:-1}).skip(3)limit(-1)db.classes.find().sort({roster:-1}).skip(3limit(-1)db.classes.find().sort({roster:-1}).skip(limit(-1)db.classes.find().sort({roster:-1}).skiplimit(-1)db.classes.find().sort({roster:-1}).skilimit(-1)db.classes.find().sort({roster:-1}).sklimit(-1)db.classes.find().sort({roster:-1}).slimit(-1)db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1})limit(-1)db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1}).limit(-1) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1}).limit(-1)db.classes.find().sort({roster:-1}).limit(-)db.classes.find().sort({roster:-1}).limit(-3)db.classes.find().sort({roster:-1}).limit(-3) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).limit(-3)db.classes.find().sort({roster:-1}).limit(-3)db.classes.find().sort({roster:-1}).limit(-3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } ambariMongo:PRIMARY> db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1}).limit(3)db.classes.find().sort({roster:-1,}).limit(3)db.classes.find().sort({roster:-1, }).limit(3)db.classes.find().sort({roster:-1, c}).limit(3)db.classes.find().sort({roster:-1, cl}).limit(3)db.classes.find().sort({roster:-1, cla}).limit(3)db.classes.find().sort({roster:-1, clas}).limit(3)db.classes.find().sort({roster:-1, class}).limit(3)db.classes.find().sort({roster:-1, class:}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3)db.classes.find().sort({roster:-1, class:1}).limit(3db.classes.find().sort({roster:-1, class:1}).limit(db.classes.find().sort({roster:-1, class:1}).limitdb.classes.find().sort({roster:-1, class:1}).limidb.classes.find().sort({roster:-1, class:1}).limdb.classes.find().sort({roster:-1, class:1}).lidb.classes.find().sort({roster:-1, class:1}).ldb.classes.find().sort({roster:-1, class:1}).db.classes.find().sort({roster:-1, class:1})db.classes.find().sort({roster:-1, class:1}) { "_id" : 5, "class" : "CSC 101", "roster" : 100 } { "_id" : 7, "roster" : 34, "class" : "CSC 202" } { "_id" : 4, "class" : "CSC 357", "name" : "Systems Programming", "sections" : [ "01", "03", "05", "07" ], "roster" : [ 34, 20, 32, 25 ] } { "_id" : 2, "class" : "CSC 445", "roster" : 34 } { "_id" : 1, "class" : "CSC 369", "roster" : 28 } { "_id" : 6, "class" : "CSC 480", "name" : "AI", "roster" : 28 } { "_id" : 3, "class" : "CSC 466", "roster" : 17 } ambariMongo:PRIMARY> sho wsho show collectionsshow collections classes data test ambariMongo:PRIMARY> db.data.find9)db.data.find9db.data.find90db.data.find9db.data.find()db.data.find() { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 2, "a" : 3 } { "_id" : 3, "a" : 4 } ambariMongo:PRIMARY> db.data.find()db.data.find(db.data.finddb.data.findb.data.fidb.data.fdb.data.insert9db.data.insert9db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.data.find().sort({a:1})db.data.find().sort({a:1}) { "_id" : 4, "b" : 4 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 2, "a" : 3 } { "_id" : 3, "a" : 4 } ambariMongo:PRIMARY> db.data.find().sort({a:1})db.data.find().sort({a:1})db.data.find().sort({a:1})db.data.find().sort({a:1})db.data.find().sort({a:-1})db.data.find().sort({a:-1}) { "_id" : 3, "a" : 4 } { "_id" : 2, "a" : 3 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 4, "b" : 4 } ambariMongo:PRIMARY> db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1}) { "_id" : 4, "b" : 4 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 2, "a" : 3 } { "_id" : 3, "a" : 4 } ambariMongo:PRIMARY> "b" : 4 } "b" : 4 } 2019-01-14T15:52:39.873-0800 E QUERY [js] SyntaxError: missing ; before statement @(shell):1:4 ambariMongo:PRIMARY> "b" : 4 }db.data.find().sort({b:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-})db.data.find().sort({b:})db.data.find().sort({b:1})db.data.find().sort({b:1}) { "_id" : 2, "a" : 3 } { "_id" : 3, "a" : 4 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 4, "b" : 4 } ambariMongo:PRIMARY> db.data.find().sort({b:1})"b" : 4 }db.data.find().sort({b:-1})db.data.find().sort({a:-1})db.data.find().sort({a:1})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:4, b:4})db.data.insert({_id:, b:4})db.data.insert({_id:5, b:4})db.data.insert({_id:5, b:4})db.data.insert({_id:5, b:4})db.data.insert({_id:5, b:4})db.data.insert({_id:5, :4})db.data.insert({_id:5, a:4})db.data.insert({_id:5, a:4})db.data.insert({_id:5, a:-4})db.data.insert({_id:5, a:-4}) WriteResult({ "nInserted" : 1 }) ambariMongo:PRIMARY> db.data.insert({_id:5, a:-4})db.data.find().sort({b:1})"b" : 4 }db.data.find().sort({b:-1})"b" : 4 }db.data.find().sort({b:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1}) { "_id" : 3, "a" : 4 } { "_id" : 2, "a" : 3 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 5, "a" : -4 } { "_id" : 4, "b" : 4 } ambariMongo:PRIMARY> db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({a:-1})db.data.find().sort({:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1}) { "_id" : 4, "b" : 4 } { "_id" : 1, "a" : 1, "b" : 2 } { "_id" : 2, "a" : 3 } { "_id" : 3, "a" : 4 } { "_id" : 5, "a" : -4 } ambariMongo:PRIMARY> db.data.find().sort({b:-1})db.data.find().sort({b:-1}db.data.find().sort({b:-1db.data.find().sort({b:-db.data.find().sort({b:db.data.find().sort({bdb.data.find().sort({db.data.find().sort(db.data.find().sortdb.data.find().sordb.data.find().sodb.data.find().sdb.data.find().db.data.find()db.data.find(db.data.finddb.data.find().sort({a:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1})db.data.find().sort({b:-1}db.data.find().sort({b:-1db.data.find().sort({b:-db.data.find().sort({b:db.data.find().sort({bdb.data.find().sort({db.data.find().sort(db.data.find().sortdb.data.find().sordb.data.find().sodb.data.find().sdb.data.find().db.data.find()db.data.find(db.data.finddb.data.finddb.data.find().sort({a:-1})db.data.find().sort({a:-1}db.data.find().sort({a:-1db.data.find().sort({a:-db.data.find().sort({a:db.data.find().sort({adb.data.find().sort({db.data.find().sort(db.data.find().sortdb.data.find().sordb.data.find().sodb.data.find().sdb.data.find().db.data.find()db.data.find({a:1})db.data.find({a:1}) { "_id" : 1, "a" : 1, "b" : 2 } ambariMongo:PRIMARY> eiexitexit bye dekhtyar@ambari-head:~/369/logs$ exit exit Script done on Mon 14 Jan 2019 03:58:21 PM PST