Thanks Kristine!
Any reason why we have 2 different syntaxes for comments, one for the shell and one for sql files? sqlline shell uses # comment sql file uses /* comment */ —Andries On Apr 28, 2015, at 11:31 AM, David Tucker <dtuc...@maprtech.com> wrote: > And that works … thank you Kristine ! > > > On Apr 28, 2015, at 11:30 AM, Kristine Hahn <kh...@maprtech.com> wrote: > >> The new docs http://tshiran.github.io/drill/docs/lexical-structure/ will >> say: >> First paragraph, last bullet: /* This is a comment. */ >> >> Kristine Hahn >> Sr. Technical Writer >> 415-497-8107 @krishahn >> >> >> On Tue, Apr 28, 2015 at 11:23 AM, Andries Engelbrecht < >> aengelbre...@maprtech.com> wrote: >> >>> How do you include SQL comments? >>> >>> Using # at the beginning of a line work in the SQLline shell, however if >>> it is part of a sql file the following error appears. >>> >>> cat comment.sql >>> >>> # comment >>> select * from sys.version; >>> >>> 0: jdbc:drill:zk=drilldemo:5181> !run comment.sql >>> 1/2 # comment >>> Aborting command set because "force" is false and command failed: "# >>> comment” >>> >>> >>> >>> Thanks >>> —Andries >>> >>> >
