[IMPALA-1327] Shell may fail to run queries from file if comments are present

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: Impala 2.0
• Component/s: Clients
• Labels: shell

Environment

commit 53b73e5b4dd11888ab3c86d5d331a652f51f8092
Author: Skye Wanderman-Milne <[e-mail]>
Date: Tue Sep 30 11:09:21 2014 -0700

    Revert "Free local UDF/UDA allocations"

• Target Version: Impala 2.11.0
• Assignee: Ishaan Joshi
• Reporter: casey
• Created: 30/Sep/14 23:18
• Updated: 25/Aug/17 00:57
• Resolved: 14/Aug/17 04:44

Description

The attached sql file fails part way through.

...
Fetched 1 row(s) in 0.76s
Query: select t2.date_string_col AS string_col_1
FROM alltypesagg t1
RIGHT JOIN alltypestiny t2 ON t2.date_string_col = t1.string_col AND t2.year = t1.int_col;
SELECT
MAX(t2.smallint_col) AS smallint_col_1
FROM alltypesagg t1
INNER JOIN alltypes t2 ON t2.string_col = t1.string_col
INNER JOIN alltypes t3 ON t3.date_string_col = t2.string_col AND t3.string_col = t1.date_string_col;
SELECT
MAX(t2.year) AS int_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.string_col = t1.string_col;
SELECT
COUNT(t2.date_string_col) AS int_col_1
FROM alltypestiny t1
INNER JOIN alltypesagg t2 ON t2.day = t1.int_col AND t2.date_string_col = t1.date_string_col;
SELECT
SUM(t3.smallint_col) AS smallint_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.day = t1.smallint_col AND t2.date_string_col = t1.date_string_col
INNER JOIN alltypes t3 ON t3.date_string_col = t1.date_string_col
ERROR: Error: Error: could not match input

If the comments are removed, the file runs fine.

Also the commented file runs fine in Postgresql

[casey@vd0206 comparison]$ psql --username=postgres --dbname=functional -f sql &> log


[casey@vd0206 comparison]$ echo $?
0


[casey@vd0206 comparison]$ tail log
 int_col_1 
-----------
         0
(1 row)

 smallint_col_1 
----------------
         405000
(1 row)