sathishkumar created CALCITE-2426:
-------------------------------------
Summary: Calcite - mongodb - Returns row but no data displayed.
Key: CALCITE-2426
URL: https://issues.apache.org/jira/browse/CALCITE-2426
Project: Calcite
Issue Type: Bug
Reporter: sathishkumar
Assignee: Julian Hyde
sqlline version 1.3.0
sqlline> !connect
jdbc:calcite:schemaFactory=org.apache.calcite.adapter.mongodb.MongoSchemaFactory;schema.host=localhost;schema.database=rfpdb;
admin admin
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/core/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/cassandra/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/druid/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/geode/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/mongodb/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/server/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/spark/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/Sathish_rfpio/softwares/apache-calcite-1.16.0-src/apache-calcite-1.16.0-src/splunk/target/dependencies/slf4j-log4j12-1.7.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connecting to
jdbc:calcite:schemaFactory=org.apache.calcite.adapter.mongodb.MongoSchemaFactory;schema.host=localhost;schema.database=rfpdb;
2018-07-24 12:37:06,568 [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
2018-07-24 12:37:13,678 [main] INFO - No server chosen by
ReadPreferenceServerSelector\{readPreference=primary} from cluster description
ClusterDescription\{type=UNKNOWN, connectionMode=SINGLE,
serverDescriptions=[ServerDescription{address=localhost:27017, type=UNKNOWN,
state=CONNECTING}]}. Waiting for 30000 ms before timing out
2018-07-24 12:37:19,012 [cluster-ClusterId\{value='5b56d01ac5722626f8c56e2e',
description='null'}-localhost:27017] INFO - Opened connection
[connectionId\{localValue:1, serverValue:23}] to localhost:27017
2018-07-24 12:37:19,015 [cluster-ClusterId\{value='5b56d01ac5722626f8c56e2e',
description='null'}-localhost:27017] INFO - Monitor thread successfully
connected to server with description
ServerDescription\{address=localhost:27017, type=STANDALONE, state=CONNECTED,
ok=true, version=ServerVersion{versionList=[3, 4, 9]}, minWireVersion=0,
maxWireVersion=5, maxDocumentSize=16777216, roundTripTimeNanos=589108}
2018-07-24 12:37:19,035 [main] INFO - Opened connection
[connectionId\{localValue:2, serverValue:24}] to localhost:27017
+-----------+-------------+------------+------------+---------+----------+------------+-----------+--------------------+
| 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.584 seconds)*
0: jdbc:calcite:schemaFactory=org.apache.calc>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
