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)