Let me clarify that a bit. Drill uses single quotes for strings and backticks for quoting identifiers. A column names and table names are identifiers and therefore you must use backticks if it includes a special character (such as period, parenthesis, backslash, etc)
This would be a correct use of both: select * from dfs.`/my/table` where strColumn = 'my special string' On Sun, Jun 14, 2015 at 7:38 AM, Abhishek Girish <[email protected]> wrote: > 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 > > > > > > > > >
