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 > > > > > >
