Skip to content

Instantly share code, notes, and snippets.

@arhimondr

arhimondr/gist:bbae933cc8915241ba403bc5444aaa53

Created October 23, 2018 15:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arhimondr/bbae933cc8915241ba403bc5444aaa53 to your computer and use it in GitHub Desktop.
Save arhimondr/bbae933cc8915241ba403bc5444aaa53 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Caused by: java.lang.IllegalArgumentException: Nulls fraction should be within [0, 1] or NaN, got: 1.0000000000000044
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:210)
at com.facebook.presto.cost.SymbolStatsEstimate.<init>(SymbolStatsEstimate.java:69)
at com.facebook.presto.cost.SymbolStatsEstimate$Builder.build(SymbolStatsEstimate.java:257)
at com.facebook.presto.cost.PlanNodeStatsEstimateMath.subtractColumnStats(PlanNodeStatsEstimateMath.java:95)
at com.facebook.presto.cost.PlanNodeStatsEstimateMath.lambda$differenceInStatsWithRangeStrategy$1(PlanNodeStatsEstimateMath.java:48)
at java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
at java.base/java.util.stream.Streams$ConcatSpliterator.forEachRemaining(Streams.java:734)
at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
at com.facebook.presto.cost.PlanNodeStatsEstimateMath.differenceInStatsWithRangeStrategy(PlanNodeStatsEstimateMath.java:45)
at com.facebook.presto.cost.PlanNodeStatsEstimateMath.differenceInStats(PlanNodeStatsEstimateMath.java:31)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitNotExpression(FilterStatsCalculator.java:163)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitNotExpression(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.NotExpression.accept(NotExpression.java:54)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:148)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.estimateLogicalAnd(FilterStatsCalculator.java:182)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:171)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.LogicalBinaryExpression.accept(LogicalBinaryExpression.java:88)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:148)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.estimateLogicalAnd(FilterStatsCalculator.java:182)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:171)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.LogicalBinaryExpression.accept(LogicalBinaryExpression.java:88)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:148)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.estimateLogicalAnd(FilterStatsCalculator.java:182)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:171)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.visitLogicalBinaryExpression(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.LogicalBinaryExpression.accept(LogicalBinaryExpression.java:88)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:148)
at com.facebook.presto.cost.FilterStatsCalculator$FilterExpressionStatsCalculatingVisitor.process(FilterStatsCalculator.java:131)
at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
at com.facebook.presto.cost.FilterStatsCalculator.filterStats(FilterStatsCalculator.java:98)
at com.facebook.presto.cost.FilterStatsRule.calculate(FilterStatsRule.java:49)
at com.facebook.presto.cost.FilterStatsRule.calculate(FilterStatsRule.java:27)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:80)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:70)
at com.facebook.presto.cost.CachingStatsProvider.getStats(CachingStatsProvider.java:75)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:52)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:30)
at com.facebook.presto.cost.SimpleStatsRule.calculate(SimpleStatsRule.java:39)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:80)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:70)
at com.facebook.presto.cost.CachingStatsProvider.getStats(CachingStatsProvider.java:75)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:52)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:30)
at com.facebook.presto.cost.SimpleStatsRule.calculate(SimpleStatsRule.java:39)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:80)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:70)
at com.facebook.presto.cost.CachingStatsProvider.getStats(CachingStatsProvider.java:75)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:52)
at com.facebook.presto.cost.ProjectStatsRule.doCalculate(ProjectStatsRule.java:30)
at com.facebook.presto.cost.SimpleStatsRule.calculate(SimpleStatsRule.java:39)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:80)
at com.facebook.presto.cost.ComposableStatsCalculator.calculateStats(ComposableStatsCalculator.java:70)
at com.facebook.presto.cost.CachingStatsProvider.getStats(CachingStatsProvider.java:75)
at com.facebook.presto.cost.CostCalculatorUsingExchanges$CostEstimator.getStats(CostCalculatorUsingExchanges.java:256)
at com.facebook.presto.cost.CostCalculatorUsingExchanges$CostEstimator.visitProject(CostCalculatorUsingExchanges.java:153)
at com.facebook.presto.cost.CostCalculatorUsingExchanges$CostEstimator.visitProject(CostCalculatorUsingExchanges.java:99)
at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:92)
at com.facebook.presto.cost.CostCalculatorUsingExchanges.calculateCost(CostCalculatorUsingExchanges.java:96)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:91)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.Collections$2.tryAdvance(Collections.java:4727)
at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4735)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.facebook.presto.cost.CachingCostProvider.calculateCumulativeCost(CachingCostProvider.java:95)
at com.facebook.presto.cost.CachingCostProvider.getCumulativeCost(CachingCostProvider.java:68)
at com.facebook.presto.cost.StatsAndCosts.create(StatsAndCosts.java:86)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:176)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:152)
at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:397)
at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:382)
at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:326)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:844)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment