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
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