I misunderstood Edward's comment, and figured out"--" works unless put before add and set.Thanks, Edward.
Travis"--" works even in the first line in case you writeSQL after that.
But this issue seems put on JIRA.https://issues.apache.org/jira/browse/HIVE-2259
--- On Mon, 2011/7/4, Travis Powell wrote:
RE: comment out hive script file
Comments cannot be the first line of a file, if I recall correctly. The way that I put my name and email at the top is after a using statement for the database.
-- John Doe, email@example.com
-- (c) Acme co 2007
Select * from (...)
From: Satoshi Yamada
Sent: Sunday, July 03, 2011 04:32 AM Pacific Standard Time
Subject: Re: comment out hive script file
Thanks, Edward, and sorry for late reply.
I want to add comment in the file using with "hive -f".
$ cat sample_select.hql
-- some commentSELECT something FROM sample_table;
$ hive -f sample_select.hql
Sample above does not work. Either "#" or "/* */" doesnot work.
So, is there no way to add comment in the file?
--- On Wed, 2011/6/29, Edward Capriolo wrote:
There is a subtle nuance, comments can only appear before QL statements not set or add commands.
On Wed, Jun 29, 2011 at 8:36 AM, Satoshi Yamada wrote:
Is there any way to comment out hive script file?
Either "--" or "/* */" does not seem to work.
Thanks in advance,satoshi