You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2017/08/14 04:45:00 UTC
[jira] [Resolved] (IMPALA-1327) Shell may fail to run queries from
file if comments are present
[ https://issues.apache.org/jira/browse/IMPALA-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-1327.
-----------------------------------
Resolution: Cannot Reproduce
> Shell may fail to run queries from file if comments are present
> ---------------------------------------------------------------
>
> Key: IMPALA-1327
> URL: https://issues.apache.org/jira/browse/IMPALA-1327
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.0
> Environment: commit 53b73e5b4dd11888ab3c86d5d331a652f51f8092
> Author: Skye Wanderman-Milne <sk...@cloudera.com>
> Date: Tue Sep 30 11:09:21 2014 -0700
> Revert "Free local UDF/UDA allocations"
> Reporter: casey
> Assignee: Ishaan Joshi
> Priority: Minor
> Labels: shell
> Attachments: log, sql
>
>
> The attached sql file fails part way through.
> {noformat}
> ...
> 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
> {noformat}
> If the comments are removed, the file runs fine.
> Also the commented file runs fine in Postgresql
> {noformat}
> [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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)