You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Andries Engelbrecht <ae...@maprtech.com> on 2015/04/28 20:23:00 UTC
SQL Comments
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
Re: SQL Comments
Posted by David Tucker <dt...@maprtech.com>.
Glad I’m not the only one fighting with this :)
— David
On Apr 28, 2015, at 11:28 AM, Ramana Inukonda <ri...@maprtech.com> wrote:
> Sorry,
>
> Scratch that. Somehow had a notion that worked. Does not seem to be the
> case.
>
> Regards
> Ramana
>
>
> On Tue, Apr 28, 2015 at 11:25 AM, Ramana Inukonda <ri...@maprtech.com>
> wrote:
>
>> You can use --
>>
>> Example:
>> -- using 1395599672 as a seed to the RNG select l_returnflag, l_linestatus,
>> sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice
>> * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 -
>> l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice)
>> as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem
>> where l_shipdate <= date '1998-12-01' - interval '120' day (3) group by l_returnflag,
>> l_linestatus order by l_returnflag, l_linestatus;
>>
>> On Tue, Apr 28, 2015 at 11:23 AM, Andries Engelbrecht <
>> aengelbrecht@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
>>>
>>>
>>
Re: SQL Comments
Posted by Ramana Inukonda <ri...@maprtech.com>.
Sorry,
Scratch that. Somehow had a notion that worked. Does not seem to be the
case.
Regards
Ramana
On Tue, Apr 28, 2015 at 11:25 AM, Ramana Inukonda <ri...@maprtech.com>
wrote:
> You can use --
>
> Example:
> -- using 1395599672 as a seed to the RNG select l_returnflag, l_linestatus,
> sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice
> * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 -
> l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice)
> as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem
> where l_shipdate <= date '1998-12-01' - interval '120' day (3) group by l_returnflag,
> l_linestatus order by l_returnflag, l_linestatus;
>
> On Tue, Apr 28, 2015 at 11:23 AM, Andries Engelbrecht <
> aengelbrecht@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
>>
>>
>
Re: SQL Comments
Posted by Ramana Inukonda <ri...@maprtech.com>.
You can use --
Example:
-- using 1395599672 as a seed to the RNG select l_returnflag,
l_linestatus, sum(l_quantity)
as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice *
(1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 - l_discount)
* (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice)
as avg_price, avg(l_discount) as avg_disc, count(*) as count_order
from lineitem
where l_shipdate <= date '1998-12-01' - interval '120' day (3) group
by l_returnflag,
l_linestatus order by l_returnflag, l_linestatus;
On Tue, Apr 28, 2015 at 11:23 AM, Andries Engelbrecht <
aengelbrecht@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
>
>
Re: SQL Comments
Posted by Andries Engelbrecht <ae...@maprtech.com>.
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 <dt...@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 <
>> aengelbrecht@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
>>>
>>>
>
Re: SQL Comments
Posted by David Tucker <dt...@maprtech.com>.
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 <
> aengelbrecht@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
>>
>>
Re: SQL Comments
Posted by Kristine Hahn <kh...@maprtech.com>.
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 <
aengelbrecht@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
>
>