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 <malu....@gmail.com> wrote: > Select * from `test.json` was the query. > > On Fri, 21 Aug 2015 at 11:12 Ted Dunning <ted.dunn...@gmail.com> wrote: > > > What was the query? > > > > > > > > On Thu, Aug 20, 2015 at 10:36 PM, Malathi <malu....@gmail.com> 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 <ted.dunn...@gmail.com> > wrote: > > > > > > > Some specific answers here. > > > > > > > > On Thu, Aug 20, 2015 at 4:13 AM, Malathi <malu....@gmail.com> 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>