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

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

     [ https://issues.apache.org/jira/browse/DRILL-7152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha resolved DRILL-7152.
-------------------------------
    Resolution: Fixed

Fixed in 54384a9. 

> 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
>            Priority: Major
>             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)