Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6615

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

    Details

    • 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
    • Labels:
      None
    • Epic Color:
      ghx-label-4

      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

       

        Attachments

          Activity

            People

            • Assignee:
              fredyw Fredy Wijaya
              Reporter:
              lmartinez@cloudera.com Luis E Martinez-Poblete
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: