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>
