7 Replies Latest reply on Nov 1, 2013 8:10 PM by Ramesh Reddy

    MongDB can't get group by to work.

    Ivan Chan Apprentice

      I have mongodb setup with 8.6 Teiid embedded version successfully.  When I ran a sql statement like [select "name", "state" from "mongoDBDS"."grades"] and it works perfectly.  However, if i ran a statement with group by like [select "state" from "mongoDBDS"."grades" group by "state" order by "state"] and it didn't return any value.  Do you guys have any clue?

       

      Thanks a lot,

       

      Ivan C.