Also can you check the logs on the HDFS datanodes/namenode which may have clues regarding why the client can't obtain the block.
On Sun, Aug 23, 2015 at 11:58 PM, Venki Korukanti <[email protected] > wrote: > Hi, > > On Sun, Aug 23, 2015 at 10:26 PM, Malathi <[email protected]> wrote: > >> Hi, >> >> The entire log of the sqlline is attached in the dropbox link: >> https://www.dropbox.com/s/oijx9vjibk1md5x/sqlline.log?dl=0 >> >> Error id is : >> >> *aa3410a8-8b11-412e-bb89-dec3e8bb8bb4* >> P.S : And one more thing to note is that it worked when both drill and >> apache HDFS run in centos in different machines. It doesn't work when HDFS >> runs in ubuntu. Please let me know of there could be anything wrong with >> the setup. >> > What version of HDFS are you using? Currently Drill comes with HDFS > fileclient 2.4.1 version packaged with it. It could be due to client > compatibility issue with the server. Not sure how HDFS handles > compatibility across versions. > > Also is the version of the HDFS installed on CentOS different from Ubuntu? > >> >> >> Thanks, >> Malathi >> >> On Fri, 21 Aug 2015 at 21:16 Abdel Hakim Deneche <[email protected]> >> wrote: >> >> > Malathi, I couldn't find the error message in the files you shared, I >> only >> > see the error id (which would be useful if I had the full Drillbit.log >> > file) and the stack trace (but it's on the client side, it doesn't >> actually >> > tell us where the exception happened on the server side). >> > >> > Can you share the error message you saw in Sqlline ? you can also use >> the >> > error Id you got with the error and search for it in the Drillbit.log, >> the >> > first occurrence should give us the stack trace on the server side. >> > >> > Thanks! >> > >> > On Fri, Aug 21, 2015 at 1:48 AM, Malathi <[email protected]> wrote: >> > >> > > Select * from `test.json` was the query. >> > > >> > > On Fri, 21 Aug 2015 at 11:12 Ted Dunning <[email protected]> >> wrote: >> > > >> > > > What was the query? >> > > > >> > > > >> > > > >> > > > On Thu, Aug 20, 2015 at 10:36 PM, Malathi <[email protected]> >> wrote: >> > > > >> > > > > Hi Ted, >> > > > > >> > > > > I have created the data source to point to my external cluster. >> > > > > >> > > > > Data source configuration: >> > > > > https://www.dropbox.com/s/g5peo43baf1bqgj/drill.config?dl=0 >> > > > > >> > > > > Error log I am getting when issue a select * query: >> > > > > https://www.dropbox.com/s/5bgyw4jetweczoj/drill.log?dl=0 >> > > > > >> > > > > Can you please let me know what could be the root cause of the >> issue? >> > > > > >> > > > > P.S : I can issue "show files" command and it works without >> issues. >> > > > > >> > > > > Thanks, >> > > > > Malathi >> > > > > >> > > > > On Thu, 20 Aug 2015 at 22:51 Ted Dunning <[email protected]> >> > > wrote: >> > > > > >> > > > > > Some specific answers here. >> > > > > > >> > > > > > On Thu, Aug 20, 2015 at 4:13 AM, Malathi <[email protected]> >> > wrote: >> > > > > > >> > > > > > > I have the following questions: >> > > > > > > 1) Is it possible to run drill in a machine outside hadoop >> > cluster >> > > > and >> > > > > > > query the hdfs files in the cluster? >> > > > > > > >> > > > > > >> > > > > > Yes. Absolutely. >> > > > > > >> > > > > > >> > > > > > > 2) If yes, is there any need of additional configuration >> change? >> > > > > > > >> > > > > > >> > > > > > Yes. >> > > > > > >> > > > > > You have to set up a data source that points to the external >> data. >> > > > > > >> > > > > >> > > > >> > > >> > >> > >> > >> > -- >> > >> > Abdelhakim Deneche >> > >> > Software Engineer >> > >> > <http://www.mapr.com/> >> > >> > >> > Now Available - Free Hadoop On-Demand Training >> > < >> > >> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available >> > > >> > >> > >
