How to query Azure DocumentDB with an equivalent of the SELECT DISTINCT statement

Question

DocumentDb don't support the DISTINCT statement. I have documents in DocumentDB with the following structure (thousands of documents):

{
    "type" : "type1",
    "data" : {
        ...
    }
},{
    "type" : "type2",
    "data" : {
        ...
    }
},{
    "type" : "type2",
    "data" : {
        ...
    }
},{
    "type" : "type2",
    "data" : {
        ...
    }
}

How can I query the collection and get the following result:

{
    "type" : "type1"
},{
    "type" : "type2"
}

Answer 1

Azure DocumentDB currently does not support DISTINCT.

Please voice your opinion and vote for this feature on DocumentDB's feedback forum.