You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "sathishkumar (JIRA)" <ji...@apache.org> on 2018/07/24 07:11:00 UTC
[jira] [Commented] (CALCITE-2426) Calcite - mongodb - Returns row
but no data displayed.
[ https://issues.apache.org/jira/browse/CALCITE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16553900#comment-16553900 ]
sathishkumar commented on CALCITE-2426:
---------------------------------------
Users table has 1 record and that not being displayed in the result table. [~julianhyde] - Can you please help?
> 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
> Priority: Critical
>
> 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)