You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Fredy Wijaya (JIRA)" <ji...@apache.org> on 2018/03/08 16:52:00 UTC
[jira] [Resolved] (IMPALA-6615) An insert query using a CTE does
not show the expected output when executed in Impala-shell
[ https://issues.apache.org/jira/browse/IMPALA-6615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fredy Wijaya resolved IMPALA-6615.
----------------------------------
Resolution: Fixed
> An insert query using a CTE does not show the expected output when executed in Impala-shell
> -------------------------------------------------------------------------------------------
>
> Key: IMPALA-6615
> URL: https://issues.apache.org/jira/browse/IMPALA-6615
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.9.0
> Reporter: Luis E Martinez-Poblete
> Assignee: Fredy Wijaya
> Priority: Trivial
>
> Synopsis:
> =========
> An insert query using a CTE does not show the expected output when executed in Impala-shell
> Problem:
> ========
> An insert query using a CTE does not produces the expected output when executed in Impala-shell. In the bad case, the output does not show the web links for "Query submitted" and " Query progress".
> Reproduction case:
> ==================
> {noformat}
> create table mytestCTE (c1 int, c2 int);
> --Good case:
> insert overwrite mytestCTE select * from mytestCTE;
> --Output:
> [host-10-17-101-88.coe.cloudera.com:21000] > insert overwrite mytestCTE select * from mytestCTE;
> Query: insert overwrite mytestCTE select * from mytestCTE
> Query submitted at: 2018-03-06 12:19:02 (Coordinator: http://host-10-17-101-88:25000)
> Query progress can be monitored at: http://host-10-17-101-88:25000/query_plan?query_id=f240a1e76c9edb69:3189ef5600000000
> Modified 0 row(s) in 0.23s
> --Bad case:
> with dfl as (select * from mytestCTE)
> insert overwrite mytestCTE
> select * from dfl;
> --Output:
> [host-10-17-101-88.coe.cloudera.com:21000] > with dfl as (select * from mytestCTE)
> > insert overwrite mytestCTE
> > select * from dfl;
> Query: with dfl as (select * from mytestCTE)
> insert overwrite mytestCTE
> select * from dfl
> Modified 0 row(s) in 0.12s{noformat}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)