Hello Mohan, Drill uses back-ticks (`) to enclose strings. Can you please try:
select * FROM dfs.`/home/Administrator/Downloads`; -Abhishek On Sat, Jun 13, 2015 at 8:20 PM, mohanpothula <[email protected]> wrote: > Hi , > Further to the below ,nor able to create new storage plugings nor update > the existing plugins .Please see the below error when trying using drill > shell > > *[root@mapr bin]# ./drill-localhost* > *apache drill 1.0.0 * > *"drill baby drill"* > *0: jdbc:drill:drillbit=localhost> select * FROM > dfs.'/home/Administrator/Downloads';* > *Error: PARSE ERROR: Encountered ". \'/home/Administrator/Downloads\'" at > line 1, column 18.* > *Was expecting one of:* > * <EOF> * > > > On Sun, Jun 14, 2015 at 9:24 AM, mohanpothula <[email protected]> > wrote: > > > Hi , > > I installed mapr on centos os ,When trying to access the flat file not > > able to access though placed the files under the /temp directory.Any > idea > > what will be the issue > > > > jdbc:drill:> use dfs.tmp; > > +-------+--------------------------------------+ > > | ok | summary | > > +-------+--------------------------------------+ > > | true | Default schema changed to [dfs.tmp] | > > +-------+--------------------------------------+ > > 1 row selected (0.147 seconds) > > 0: jdbc:drill:> show tables; > > 0: jdbc:drill:> show tables; > > +--+ > > | | > > +--+ > > +--+ > > No rows selected (0.392 seconds) > > +--+ > > > > Regards, > > Mohan > > > > >
