How to programmatically get away from key too large to index error in pymongo python?

Question

Python

I have a database of 2 million records. When I create an index field (db.coll.create_index(...)), I get an error of this type: key too large to index, failing 1098. Apparently, some name did not fit when building the index. Tell me how programmatically through pymongo or bypass this, or increase the size of accepted keys in the index?

Answer 1

The crutch solution to your problem is hashing.
1) Before insertion, hash your keys using a non-critical algorithm.
2) When searching by key, do the same.
With such a campaign, there is a chance of being blown up by collisions. You can reduce the probability by making a composite key.
Obviously the key will require a new field.
And it is better to choose more adequate attributes as a key.
UPD: mongo has indexes on hashes .