[
https://issues.apache.org/jira/browse/DRILL-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556406#comment-14556406
]
Trent Telfer commented on DRILL-3152:
-------------------------------------
When I try to run the command: bin/sqlline -u jdbc:drill:zk=localhost:2181 -n
admin -p admin I get the following error:
Error setting configuration: isolation: java.lang.NullPointerException
10:23:17.569 [main] ERROR org.apache.curator.ConnectionState - Connection timed
out for connection string (localhost:2181) and timeout (5000) / elapse
d (44599)
org.apache.curator.CuratorConnectionLossException: KeeperErrorCode =
ConnectionLoss
at
org.apache.curator.ConnectionState.checkTimeouts(ConnectionState.java:198)
[curator-client-2.5.0.jar:na]
at
org.apache.curator.ConnectionState.getZooKeeper(ConnectionState.java:88)
[curator-client-2.5.0.jar:na]
at
org.apache.curator.CuratorZookeeperClient.getZooKeeper(CuratorZookeeperClient.java:115)
[curator-client-2.5.0.jar:na]
at
org.apache.curator.utils.EnsurePath$InitialHelper$1.call(EnsurePath.java:148)
[curator-client-2.5.0.jar:na]
at org.apache.curator.RetryLoop.callWithRetry(RetryLoop.java:107)
[curator-client-2.5.0.jar:na]
at
org.apache.curator.utils.EnsurePath$InitialHelper.ensure(EnsurePath.java:140)
[curator-client-2.5.0.jar:na]
at org.apache.curator.utils.EnsurePath.ensure(EnsurePath.java:99)
[curator-client-2.5.0.jar:na]
at
org.apache.curator.framework.imps.NamespaceImpl.fixForNamespace(NamespaceImpl.java:74)
[curator-framework-2.5.0.jar:na]
at
org.apache.curator.framework.imps.NamespaceImpl.newNamespaceAwareEnsurePath(NamespaceImpl.java:87)
[curator-framework-2.5.0.jar:na]
at
org.apache.curator.framework.imps.CuratorFrameworkImpl.newNamespaceAwareEnsurePath(CuratorFrameworkImpl.java:468)
[curator-framework-2.5.0.
jar:na]
at
org.apache.curator.framework.recipes.cache.PathChildrenCache.<init>(PathChildrenCache.java:223)
[curator-recipes-2.5.0.jar:na]
at
org.apache.curator.framework.recipes.cache.PathChildrenCache.<init>(PathChildrenCache.java:182)
[curator-recipes-2.5.0.jar:na]
at
org.apache.curator.x.discovery.details.ServiceCacheImpl.<init>(ServiceCacheImpl.java:65)
[curator-x-discovery-2.5.0.jar:na]
at
org.apache.curator.x.discovery.details.ServiceCacheBuilderImpl.build(ServiceCacheBuilderImpl.java:47)
[curator-x-discovery-2.5.0.jar:na]
at
org.apache.drill.exec.coord.zk.ZKClusterCoordinator.<init>(ZKClusterCoordinator.java:104)
[drill-java-exec-1.0.0-rebuffed.jar:1.0.0]
at
org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:185)
[drill-java-exec-1.0.0-rebuffed.jar:1.0.0]
at
org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:126)
[drill-jdbc-1.0.0.jar:1.0.0]
at
org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:97)
[drill-jdbc-1.0.0.jar:1.0.0]
at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:60)
[drill-jdbc-1.0.0.jar:1.0.0]
at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:46)
[drill-jdbc-1.0.0.jar:1.0.0]
at
org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:54)
[drill-jdbc-1.0.0.jar:1.0.0]
at
net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
[optiq-avatica-0.9-drill-r20.jar:na]
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
[sqlline-1.1.9-drill-r4.jar:na]
at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.Commands.connect(Commands.java:1083)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.Commands.connect(Commands.java:1015)
[sqlline-1.1.9-drill-r4.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.7.0_71]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[na:1.7.0_71]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_71]
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.SqlLine.dispatch(SqlLine.java:734)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.SqlLine.initArgs(SqlLine.java:519)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.SqlLine.begin(SqlLine.java:587)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.SqlLine.start(SqlLine.java:366)
[sqlline-1.1.9-drill-r4.jar:na]
at sqlline.SqlLine.main(SqlLine.java:259)
[sqlline-1.1.9-drill-r4.jar:na]
> Apache Drill 1.0 not able to query MongoDB 3.0.
> ------------------------------------------------
>
> Key: DRILL-3152
> URL: https://issues.apache.org/jira/browse/DRILL-3152
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 0.9.0, 1.0.0
> Environment: The environment is as follows:
> Windows 7
> MongoDB 3 Wiredtiger (installed locally)
> Apache Drill 1.0 (installed locally)
> Reporter: Trent Telfer
> Assignee: B Anil Kumar
> Labels: mongodb, mongodb3, windows7, wiredtiger
>
> I have been trying to get Apache Drill 1.0, and previously 0.9 to work with
> MongoDB 3.0 Wiredtiger. I have no problem starting Apache Drill using the
> following, but I am having problems querying MongoDB:
> *./sqlline.bat*
> *!connect jdbc:drill:zk=local*
> *SHOW DATABASES;*
> +---------------------+
> | SCHEMA_NAME |
> +---------------------+
> | INFORMATION_SCHEMA |
> | cp.default |
> | dfs.default |
> | dfs.root |
> | dfs.tmp |
> | mongo.admin |
> | mongo.alliance_db |
> | mongo.local |
> | sys |
> +---------------------+
> *USE mongo.alliance_db;*
> +-------+------------------------------------------------+
> | ok | summary |
> +-------+------------------------------------------------+
> | true | Default schema changed to [mongo.alliance_db] |
> +-------+------------------------------------------------+
> 1 row selected (0.116 seconds)
> *SELECT * FROM price_daily_ngi;*
> May 20, 2015 11:14:40 AM
> org.apache.calcite.sql.validate.SqlValidatorException <init>
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table
> 'price_daily_ngi' not found
> May 20, 2015 11:14:40 AM org.apache.calcite.runtime.CalciteException <init>
> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1,
> column 15 to line 1, column 29: Table 'price_daily_ngi' not found
> Error: PARSE ERROR: From line 1, column 15 to line 1, column 29: Table
> 'price_daily_ngi' not found
> [Error Id: 6414a69d-55a0-4918-8f95-10a920e4dc6b on PCV:31010] (state=,code=0)
> MongoDB storage configuration:
> {
> "type": "mongo",
> "connection": "mongodb://localhost:27017",
> "enabled": true
> }
> The collection price_daily_ngi exists and works with normal MongoDB queries.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
