Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3902 Multi-threaded query execution
  3. IMPALA-9081

testMtDopValidationWithHDFSNumRowsEstDisabled toggles isTestEnv() changing table loading behaviour

    XMLWordPrintableJSON

    Details

      Description

      Section PLAN of query:
      insert into functional_parquet.alltypes partition(year,month)
      select * from functional_parquet.alltypessmall
      
      Actual does not match expected result:
      F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
      |  Per-Host Resources: mem-estimate=1.01GB mem-reservation=12.09MB thread-reservation=1
      WRITE TO HDFS [functional_parquet.alltypes, OVERWRITE=false, PARTITION-KEYS=(year,month)]
      |  partitions=unavailable
      ^^^^^^^^^^^^^^^^^^^^^^^^^
      |  output exprs: id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month
      |  mem-estimate=1.00GB mem-reservation=0B thread-reservation=0
      |
      01:SORT
      |  order by: year ASC NULLS LAST, month ASC NULLS LAST
      |  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
      |  tuple-ids=2 row-size=80B cardinality=unavailable
      |  in pipelines: 01(GETNEXT), 00(OPEN)
      |
      00:SCAN HDFS [functional_parquet.alltypessmall]
         HDFS partitions=4/4 files=4 size=14.76KB
         stored statistics:
           table: rows=unavailable size=unavailable
           partitions: 0/4 rows=unavailable
           columns: unavailable
         extrapolated-rows=disabled max-scan-range-rows=unavailable
         mem-estimate=16.00MB mem-reservation=88.00KB thread-reservation=0
         tuple-ids=0 row-size=80B cardinality=unavailable
         in pipelines: 00(GETNEXT)
      
      Expected:
      F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
      |  Per-Host Resources: mem-estimate=1.01GB mem-reservation=12.09MB thread-reservation=1
      WRITE TO HDFS [functional_parquet.alltypes, OVERWRITE=false, PARTITION-KEYS=(year,month)]
      |  partitions=4
      |  output exprs: id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month
      |  mem-estimate=1.00GB mem-reservation=0B thread-reservation=0
      |
      01:SORT
      |  order by: year ASC NULLS LAST, month ASC NULLS LAST
      |  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
      |  tuple-ids=2 row-size=80B cardinality=unavailable
      |  in pipelines: 01(GETNEXT), 00(OPEN)
      |
      00:SCAN HDFS [functional_parquet.alltypessmall]
         HDFS partitions=4/4 files=4 size=14.51KB
         stored statistics:
           table: rows=unavailable size=unavailable
           partitions: 0/4 rows=unavailable
           columns missing stats: id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col
         extrapolated-rows=disabled max-scan-range-rows=unavailable
         mem-estimate=16.00MB mem-reservation=88.00KB thread-reservation=0
         tuple-ids=0 row-size=80B cardinality=unavailable
         in pipelines: 00(GETNEXT)
      
      Verbose plan:
      F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
      |  Per-Host Resources: mem-estimate=1.01GB mem-reservation=12.09MB thread-reservation=1
      WRITE TO HDFS [functional_parquet.alltypes, OVERWRITE=false, PARTITION-KEYS=(year,month)]
      |  partitions=unavailable
      |  output exprs: id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month
      |  mem-estimate=1.00GB mem-reservation=0B thread-reservation=0
      |
      01:SORT
      |  order by: year ASC NULLS LAST, month ASC NULLS LAST
      |  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
      |  tuple-ids=2 row-size=80B cardinality=unavailable
      |  in pipelines: 01(GETNEXT), 00(OPEN)
      |
      00:SCAN HDFS [functional_parquet.alltypessmall]
         HDFS partitions=4/4 files=4 size=14.76KB
         stored statistics:
           table: rows=unavailable size=unavailable
           partitions: 0/4 rows=unavailable
           columns: unavailable
         extrapolated-rows=disabled max-scan-range-rows=unavailable
         mem-estimate=16.00MB mem-reservation=88.00KB thread-reservation=0
         tuple-ids=0 row-size=80B cardinality=unavailable
         in pipelines: 00(GETNEXT)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tarmstrong Tim Armstrong
                Reporter:
                twmarshall Thomas Tauber-Marshall
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: