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 at 8:37 AM Satiz Kumar <citsathis...@gmail.com> wrote:
> 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.calcite.adapter.mongodb.MongoSchemaFactory;schema.host=localhost;schema.database=rfpdb;
> 2018-07-24 13:04:52,932 [main] INFO - Cluster created with settings
> {hosts=[localhost:27017], mode=SINGLE, requiredClusterType=UNKNOWN,
> serverSelectionTimeout='30000 ms', maxWaitQueueSize=500}
> Connected to: Calcite (version 1.16.0)
> Driver: Calcite JDBC Driver (version 1.16.0)
> Autocommit status: true
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 0: jdbc:calcite:schemaFactory=org.apache.calc> *!tables*
>
>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+--------------------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT |
> TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_C |
>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+--------------------+
> | | adhoc | company_preferences | TABLE | |
> | | | |
> | | adhoc | property | TABLE | | |
> | | |
> | | adhoc | templates | TABLE | | |
> | | |
> | | adhoc | user_preferences | TABLE | |
> | | | |
> | | adhoc | users | TABLE | | |
> | | |
> | | metadata | COLUMNS | SYSTEM TABLE | |
> | | | |
> | | metadata | TABLES | SYSTEM TABLE | |
> | | | |
>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+--------------------+
> 0: jdbc:calcite:schemaFactory=org.apache.calc> *select * from "users";*
> +------+
> | _MAP |
> +------+
> | |
> +------+
> *1 row selected (0.718 seconds)*
> 0: jdbc:calcite:schemaFactory=org.apache.calc>
>
