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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-7152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808178#comment-16808178 ] 

ASF GitHub Bot commented on DRILL-7152:
---------------------------------------

amansinha100 commented on pull request #1730: DRILL-7152: During histogram creation handle the case when all values…
URL: https://github.com/apache/drill/pull/1730
 
 
   … of a column are NULLs.
   
   Please see [DRILL-7152](https://issues.apache.org/jira/browse/DRILL-7152) for a description of the issue.  It was caused because all the column's values are NULLs and the t-digest code-gen functions tried to generate an output for an empty t-digest since it does not store any NULL values.  The fix is to check the t-digest size() first before trying to create the output. 
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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 & 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)