Hi Michael,
Thanks for your reply!
The errors are:
|-ERROR in ch.qos.logback.core.joran.spi.Interpreter@33:27 - no applicable
action for [level], current ElementPath is [[configuration][appender][level]]
Error: Failure trying to connect to Drill. (state=,code=0)
java.sql.SQLException: Failure trying to connect to Drill.
at
org.apache.drill.jdbc.DrillHandler.onConnectionInit(DrillHandler.java:131)
at
net.hydromatic.optiq.jdbc.UnregisteredDriver.connect(UnregisteredDriver.java:127)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4802)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4853)
at sqlline.SqlLine$Commands.connect(SqlLine.java:4094)
at sqlline.SqlLine$Commands.connect(SqlLine.java:4003)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2964)
at sqlline.SqlLine.dispatch(SqlLine.java:878)
at sqlline.SqlLine.initArgs(SqlLine.java:652)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
at sqlline.SqlLine.main(SqlLine.java:443)
Caused by: org.apache.drill.exec.exception.SetupException: Failure setting up
new storage engine configuration for config
org.apache.drill.exec.store.parquet.ParquetStorageEngineConfig@617e8cc0
at
org.apache.drill.exec.store.SchemaProviderRegistry.getSchemaProvider(SchemaProviderRegistry.java:76)
at
org.apache.drill.jdbc.DrillHandler.onConnectionInit(DrillHandler.java:116)
... 15 more
Caused by: java.lang.RuntimeException: Error setting up filesystem
at
org.apache.drill.exec.store.parquet.ParquetSchemaProvider.<init>(ParquetSchemaProvider.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at
org.apache.drill.exec.store.SchemaProviderRegistry.getSchemaProvider(SchemaProviderRegistry.java:72)
... 16 more
Caused by: org.apache.hadoop.ipc.RemoteException: Server IPC version 9 cannot
communicate with client version 4
at org.apache.hadoop.ipc.Client.call(Client.java:1113)
at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:229)
at com.sun.proxy.$Proxy18.getProtocolVersion(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:85)
at
org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:62)
at com.sun.proxy.$Proxy18.getProtocolVersion(Unknown Source)
at org.apache.hadoop.ipc.RPC.checkVersion(RPC.java:422)
at org.apache.hadoop.hdfs.DFSClient.createNamenode(DFSClient.java:183)
at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:281)
at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:245)
at
org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:100)
at
org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:1446)
at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:67)
at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1464)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:263)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:124)
at
org.apache.drill.exec.store.parquet.ParquetSchemaProvider.<init>(ParquetSchemaProvider.java:47)
... 21 more
B.R.
Guo Ying
-----Original Message-----
From: Michael Hausenblas [mailto:[email protected]]
Sent: Friday, December 06, 2013 5:16 PM
To: Apache Drill User
Subject: Re: How connect Drill with HDFS
> But when we run “./sqlline -u jdbc:drill:schema=parquet -n admin -p admin”
> there are some ERRORs and Failure trying to connect to Drill.
In order to help you, it would certainly help if you share these errors, either
here via copy and paste or put it on pastebin/gist and link to it.
Cheers,
Michael
--
Michael Hausenblas
Ireland, Europe
http://mhausenblas.info/
On 6 Dec 2013, at 09:09, Guo, Ying Y <[email protected]> wrote:
> Hi all，
> We have modified ./sqlparser/target/classes/storage-engines.json：
> "parquet" :
> {
> "type":"parquet",
> "dfsName" : "hdfs:// localhost:9000"
> }
> We also have recompiled and generated new
> drill-sqlparser-1.0.0-m2-incubating-SNAPSHOT.jar.
> But when we run “./sqlline -u jdbc:drill:schema=parquet -n admin -p admin”
> there are some ERRORs and Failure trying to connect to Drill.
> I don't know why. Do you know what else need to do?
>
> .
>
