Andries, this is a known issue -
https://issues.apache.org/jira/browse/DRILL-2597


On Wed, Apr 29, 2015 at 12:07 AM, Andries Engelbrecht <
[email protected]> wrote:

> 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 <[email protected]> wrote:
>
> > And that works … thank you Kristine !
> >
> >
> > On Apr 28, 2015, at 11:30 AM, Kristine Hahn <[email protected]> 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 <
> >> [email protected]> 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
> >>>
> >>>
> >
>
>

Reply via email to