Is there a way to make a multi line comment in hive scripts

Question

I know that we can make a single line comment with '--' in hiveQL(hive.sql scripts) but is there a way to make multi line comments? I need something like below

/*  This sentence is 
    a comment */

score 30 · Accepted Answer · answered Apr 25 '12 at 01:32

30

As per my knowledge, multi-line comments are not supported in Hive scripts as of now. Seems like this JIRA introduced only single line comments, starting with -- in Hive 0.8

answered Apr 25 '12 at 01:32

Mark Grover

4,070
22
21

This has changed. – combinatorist Aug 15 '19 at 15:20

score 13 · Answer 2 · answered Dec 10 '14 at 11:23

13

No, As of now Hive support single line comment only.

Hive, Pig, Hbase are starting stage not implemented like Mangodb, Cassandra, but in next version especially for Hadoop 2.x it's possible multiple comments also.

Just use -- two dashes to make a comment in hive.

answered Dec 10 '14 at 11:23

Venu A Positive

2,992
2
28
31

1

This has changed. – combinatorist Aug 15 '19 at 15:20

score 6 · Answer 3 · answered Oct 10 '17 at 20:11

6

Multi-line (aka "bracketed") comments should be available in Hive v2.3.0: https://issues.apache.org/jira/browse/HIVE-15765

answered Oct 10 '17 at 20:11

combinatorist

562
1
4
17

However, in my experience it is not working in CREATE TABLE (DDL) statements yet on v2.3.0. – combinatorist Oct 10 '17 at 20:21
1

I've had a lot of issues even at v3.0.1 – Henrique Brisola Oct 20 '21 at 20:12

Is there a way to make a multi line comment in hive scripts

3 Answers3