[IMPALA-6615] An insert query using a CTE does not show the expected output when executed in Impala-shell

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: Impala 2.9.0
• Fix Version/s: Impala 3.0, Impala 2.13.0
• Component/s: Clients
• Epic Color: ghx-label-4
• Assignee: Fredy Wijaya
• Reporter: Luis E Martinez-Poblete
• Created: 06/Mar/18 22:09
• Updated: 09/Mar/18 01:20
• Resolved: 08/Mar/18 16:51

Description

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:
==================

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