Thanks for your reply, but I am sorry that I just saw your reply now. I have tried to run without thses changes before install hadoop and sample queries to search the file" sample-data/region.parquet " are running ok.
-----Original Message----- From: Timothy Chen [mailto:[email protected]] Sent: Friday, December 06, 2013 11:11 PM To: [email protected] Cc: [email protected] Subject: Re: How connect Drill with HDFS Have you tried to run without your changes? It seems like it can't even connect to the drillbit in the first place. Tim Sent from my iPhone > On Dec 6, 2013, at 1:38 AM, Rajika Kumarasiri <[email protected]> > wrote: > > According to the log it means it's a client compatibility issue. > > Rajika > > > On Fri, Dec 6, 2013 at 4:32 AM, Michael Hausenblas < > [email protected]> wrote: > >> >> 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(UnregisteredDriv >> er.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(DelegatingMethodAcces >> sorImpl.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@617e8c >> c0 >>> 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>(Parq >> uetSchemaProvider.java:49) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >>> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct >> orAccessorImpl.java:57) >>> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC >> onstructorAccessorImpl.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(DelegatingMethodAcces >> sorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at >> org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryI >> nvocationHandler.java:85) >>> at >> org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocat >> ionHandler.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(DistributedFi >> leSystem.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>(Parq >> uetSchemaProvider.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? >>>> >>>> . >> >>
