I hope drill should supports ANSI SQL. Any particular reason for not supporting quotes. I am trying to connect drill with my legacy application. It has huge set of queries. I can't change every quotes with bachtick. Thanks.
> Date: Fri, 17 Jul 2015 05:41:06 -0700 > Subject: Re: Double quotes in alias name not working > From: [email protected] > To: [email protected] > > you only need to use backtick ` symbol when you want to use a "reserved > word" (`user` in this case). I don't think Drill supports double quotes. > > Is there a specific reason you want to use double quotes instead of > backticks ? > > On Fri, Jul 17, 2015 at 5:23 AM, Siva B <[email protected]> wrote: > > > Hi, > > Why drill not accepting Column alias name with quotes is not working. It > > works only with ` symbol. > > Working Query: SELECT id, name AS `user` from users; > > Actual Query: SELECT id, name AS "user" from users; [How to make it this > > works.] > > Please share workaround for this scenario. > > Thanks > > > > > > > -- > > 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>
