Luis E Martinez-Poblete created IMPALA-6615:
-----------------------------------------------

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


Synopsis:
=========
An insert query using a CTE does not show the expected output when executed in 
Impala-shell

Problem:
========
Customer is reporting that 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)

Reply via email to