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/26 04:14:00 UTC
[jira] [Updated] (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:all-tabpanel ]
sathishkumar updated CALCITE-2426:
----------------------------------
Description:
sqlline version 1.3.0
sqlline> !connect jdbc:calcite:schemaFactory=org.apache.calcite.adapter.mongodb.MongoSchemaFactory;schema.host=localhost;schema.database=*****; admin admin
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.584 seconds)*
0: jdbc:calcite:schemaFactory=org.apache.calc>
was:
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>
> 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=*****; admin admin
> 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.584 seconds)*
> 0: jdbc:calcite:schemaFactory=org.apache.calc>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)