Ok.
Thank you!
B.R.
Guo Ying
-----Original Message-----
From: Michael Hausenblas [mailto:[email protected]]
Sent: Friday, December 06, 2013 5:33 PM
To: Apache Drill User
Subject: Re: How connect Drill with HDFS
Thank you, Guo Ying. I must admit that I’ve not seen this one before but I’d
expect that Jason would have an idea … let’s see when the West coast of the US
and A wakes up ;)
Cheers,
Michael
--
Michael Hausenblas
Ireland, Europe
http://mhausenblas.info/
On 6 Dec 2013, at 09:27, Guo, Ying Y <[email protected]> wrote:
> 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?
>>
>> .
>>
>
