[IMPALA-9081] testMtDopValidationWithHDFSNumRowsEstDisabled toggles isTestEnv() changing table loading behaviour

• Type: Sub-task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: Impala 3.4.0
• Component/s: Frontend
• Labels: broken-build flaky
• Target Version: Product Backlog
• Epic Color: ghx-label-3
• Assignee: Tim Armstrong
• Reporter: Thomas Tauber-Marshall
• Created: 22/Oct/19 19:28
• Updated: 15/Nov/19 20:21
• Resolved: 15/Nov/19 20:21

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)

Issue Links

• is duplicated by: IMPALA-9142 Failure in PlannerTest.testSpillableBufferSizing: SCAN HDFS columns missing.