hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Peña (JIRA) <j...@apache.org>
Subject [jira] [Commented] (HIVE-6683) Beeline does not accept comments at end of line
Date Tue, 23 Sep 2014 18:18:33 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14145165#comment-14145165
] 

Sergio Peña commented on HIVE-6683:
-----------------------------------

It does not work. 
It does not throw an error though, but the results are not correct.

The example is run in a table 'persons' with two rows only.

{noformat}
0: jdbc:hive2://localhost:10000> select 1 from persons;
+------+--+
| _c0  |
+------+--+
| 1    |
| 1    |
+------+--+

0: jdbc:hive2://localhost:10000> select  
. . . . . . . . . . . . . . . .> 1 -- comment
. . . . . . . . . . . . . . . .> from persons;
+------+--+
| _c0  |
+------+--+
| 1    |
+------+--+
{noformat}

Although there are some different errors when using the column names or the *.

{noformat}
0: jdbc:hive2://localhost:10000> select
. . . . . . . . . . . . . . . .> * -- comment
. . . . . . . . . . . . . . . .> from persons;
Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Invalid column
reference 'TOK_ALLCOLREF' (state=42000,code=40000)

0: jdbc:hive2://localhost:10000> select
. . . . . . . . . . . . . . . .> id -- comment
. . . . . . . . . . . . . . . .> from persons;
Error: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:7
Invalid table alias or column reference 'id': (possible column names are: ) (state=42000,code=10004)
{noformat}

> Beeline does not accept comments at end of line
> -----------------------------------------------
>
>                 Key: HIVE-6683
>                 URL: https://issues.apache.org/jira/browse/HIVE-6683
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.10.0
>            Reporter: Jeremy Beard
>
> Beeline fails to read queries where lines have comments at the end. This works in the
embedded Hive CLI.
> Example:
> SELECT
> 1 -- this is a comment about this value
> FROM
> table;
> Error: Error while processing statement: FAILED: ParseException line 1:36 mismatched
input '<EOF>' expecting FROM near '1' in from clause (state=42000,code=40000)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message