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

Analyzed query in explain plan is not quite right for insert with values clause

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 4.0.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      Description

      In impala-shell:

      create table double_tbl (d double) stored as textfile;
      set explain_level=2;
      explain insert into double_tbl values (-0.43149576573887316);
      
      +----------------------------------------------------------------------------------+
      | Explain String                                                                   |
      +----------------------------------------------------------------------------------+
      | Max Per-Host Resource Reservation: Memory=0B Threads=1                           |
      | Per-Host Resource Estimates: Memory=10MB                                         |
      | Codegen disabled by planner                                                      |
      | Analyzed query: SELECT CAST(-0.43149576573887316 AS DECIMAL(17,17)) UNION SELECT |
      | CAST(-0.43149576573887316 AS DECIMAL(17,17))                                     |
      |                                                                                  |
      | F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1                            |
      | |  Per-Host Resources: mem-estimate=8B mem-reservation=0B thread-reservation=1   |
      | WRITE TO HDFS [default.double_tbl, OVERWRITE=false]                              |
      | |  partitions=1                                                                  |
      | |  output exprs: CAST(-0.43149576573887316 AS DOUBLE)                            |
      | |  mem-estimate=8B mem-reservation=0B thread-reservation=0                       |
      | |                                                                                |
      | 00:UNION                                                                         |
      |    constant-operands=1                                                           |
      |    mem-estimate=0B mem-reservation=0B thread-reservation=0                       |
      |    tuple-ids=0 row-size=8B cardinality=1                                         |
      |    in pipelines: <none>                                                          |
      +----------------------------------------------------------------------------------+
      
      

      The analyzed query does not make sense. We should investigate and fix it.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tarmstrong Tim Armstrong
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: