You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2019/04/02 21:11:00 UTC

[jira] [Created] (DRILL-7152) Histogram creation throws exception for all nulls column

Aman Sinha created DRILL-7152:
---------------------------------

             Summary: Histogram creation throws exception for all nulls column
                 Key: DRILL-7152
                 URL: https://issues.apache.org/jira/browse/DRILL-7152
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning &amp; Optimization
            Reporter: Aman Sinha
            Assignee: Aman Sinha
             Fix For: 1.16.0


ANALYZE command fails when creating the histogram for a table with 1 column with all NULLs. 

Analyze table `table_stats/parquet_col_nulls` compute statistics;

{noformat}
Error: SYSTEM ERROR: NullPointerException
  (org.apache.drill.common.exceptions.DrillRuntimeException) Failed to get TDigest output
    org.apache.drill.exec.test.generated.StreamingAggregatorGen32.outputRecordValues():1085
    org.apache.drill.exec.test.generated.StreamingAggregatorGen32.outputToBatchPrev():492
    org.apache.drill.exec.test.generated.StreamingAggregatorGen32.doWork():224
    org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.innerNext():288
    org.apache.drill.exec.record.AbstractRecordBatch.next():186
    org.apache.drill.exec.record.AbstractRecordBatch.next():126
    org.apache.drill.exec.record.AbstractRecordBatch.next():116
    org.apache.drill.exec.physical.impl.statistics.StatisticsMergeBatch.innerNext():358
    org.apache.drill.exec.record.AbstractRecordBatch.next():186
    org.apache.drill.exec.record.AbstractRecordBatch.next():126
    org.apache.drill.exec.record.AbstractRecordBatch.next():116
    org.apache.drill.exec.physical.impl.unpivot.UnpivotMapsRecordBatch.innerNext():106
    org.apache.drill.exec.record.AbstractRecordBatch.next():186
    org.apache.drill.exec.record.AbstractRecordBatch.next():126
    org.apache.drill.exec.record.AbstractRecordBatch.next():116
    org.apache.drill.exec.physical.impl.StatisticsWriterRecordBatch.innerNext():96
    org.apache.drill.exec.record.AbstractRecordBatch.next():186
    org.apache.drill.exec.record.AbstractRecordBatch.next():126
    org.apache.drill.exec.record.AbstractRecordBatch.next():116
    org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():63
    org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():141
    org.apache.drill.exec.record.AbstractRecordBatch.next():186
    org.apache.drill.exec.physical.impl.BaseRootExec.next():104
    org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():83
    org.apache.drill.exec.physical.impl.BaseRootExec.next():94
    org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():296
    org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():283
    java.security.AccessController.doPrivileged():-2
    javax.security.auth.Subject.doAs():422
    org.apache.hadoop.security.UserGroupInformation.doAs():1669
    org.apache.drill.exec.work.fragment.FragmentExecutor.run():283
    org.apache.drill.common.SelfCleaningRunnable.run():38
    java.util.concurrent.ThreadPoolExecutor.runWorker():1149
    java.util.concurrent.ThreadPoolExecutor$Worker.run():624
    java.lang.Thread.run():748
{noformat}

This table has 1 column with all NULL values:

{noformat}
apache drill (dfs.drilltestdir)> select * from `table_stats/parquet_col_nulls` limit 20;
+------+------+
| col1 | col2 |
+------+------+
| 0    | null |
| 1    | null |
| 2    | null |
| 3    | null |
| 4    | null |
| 5    | null |
| 6    | null |
| 7    | null |
| 8    | null |
| 9    | null |
| 10   | null |
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)