mongo集合以_id作为分片键的，不能在其他列上创建唯一索引

mongos> db.createCollection("a");
{ "ok" : 1 }


mongos> sh.shardCollection("edijsp.a", { "_id": "hashed" } )
{ "collectionsharded" : "edijsp.a", "ok" : 1 }
mongos> db.a.createIndex({"poc":1},{unique:true},{"background":true})
{
"raw" : {
"shard11/mongo11:27111,mongo14:27111" : {
"createdCollectionAutomatically" : true,
"numIndexesBefore" : 1,
"numIndexesAfter" : 2,
"ok" : 1,
"$gleStats" : {
"lastOpTime" : Timestamp(1514335939, 29),
"electionId" : ObjectId("5954c87b0f8a58ead1372117")
}
},
"shard12/mongo12:27112,mongo15:27112" : {
"createdCollectionAutomatically" : false,
"numIndexesBefore" : 2,
"ok" : 0,
"errmsg" : "cannot create unique index over { poc: 1.0 } with shard key pattern { _id: \"hashed\" }",
"code" : 67,
"$gleStats" : {
"lastOpTime" : Timestamp(1514335939, 68),
"electionId" : ObjectId("5954c832420c046827d4cb61")
}
},
"shard13/mongo13:27113,mongo16:27113" : {
"createdCollectionAutomatically" : false,
"numIndexesBefore" : 2,
"ok" : 0,
"errmsg" : "cannot create unique index over { poc: 1.0 } with shard key pattern { _id: \"hashed\" }",
"code" : 67,
"$gleStats" : {
"lastOpTime" : Timestamp(1514335939, 22),
"electionId" : ObjectId("5954c8c74244ad5043548400")
}
}
},
"code" : 67,
"ok" : 0,
"errmsg" : "{ shard12/mongo12:27112,mongo15:27112: \"cannot create unique index over { poc: 1.0 } with shard key pattern { _id: \"hashed\" }\", shard13/mongo13:27113,mongo16:27113: \"cannot create unique index over { poc: 1.0 } with shard key pattern { _id: \"hashed\" }\" }"
}

mongos> 

结论：mongo集合以_id作为分片键的，不能在其他列上创建唯一索引