Re: No data returned from mongodb table - calcite

2018-07-24 Thread Andrei Sereda
Hi Kumar, Probably, the problem is that mongo (Bson) documents are not shown correctly. Try to fetch individual attributes like : select _MAP['_id'], _MAP['attr1'] from "users" You can always double-check result size with select count(*) from "users" Regards, Andrei. On Tue, Jul 24, 2018 a

No data returned from mongodb table - calcite

2018-07-24 Thread Satiz Kumar
My query returns 1 row but in the result table it is empty. Users table has 1 record which is not properly fetched. sqlline version 1.3.0 sqlline> !connect jdbc:calcite:schemaFactory=org.apache.calcite.adapter.mongodb.MongoSchemaFactory;sc Connecting to jdbc:calcite:schemaFactory=org.apache.calci