[
https://issues.apache.org/jira/browse/HIVE-19390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-19390:
------------------------------------
Status: Patch Available (was: Open)
Stack trace:
{code}
2018-03-22T17:09:42,680 ERROR [946f78ac-24e9-493b-b877-336d3006a9b5
HiveServer2-Handler-Pool: Thread-87]: stats.StatsUtils (:()) - Failed to
retrieve table statistics:
org.apache.hadoop.hive.ql.metadata.HiveException:
NoSuchObjectException(message:Specified database/table does not exist :
_dummy_database._dummy_table)
at
org.apache.hadoop.hive.ql.metadata.Hive.getTableColumnStatistics(Hive.java:4163)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.stats.StatsUtils.getTableColumnStats(StatsUtils.java:1122)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(StatsUtils.java:342)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(StatsUtils.java:159)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(StatsUtils.java:147)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.optimizer.stats.annotation.StatsRulesProcFactory$TableScanStatsRule.process(StatsRulesProcFactory.java:137)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:105)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:89)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.lib.LevelOrderWalker.walk(LevelOrderWalker.java:143)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.lib.LevelOrderWalker.startWalking(LevelOrderWalker.java:122)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.optimizer.stats.annotation.AnnotateWithStatistics.transform(AnnotateWithStatistics.java:78)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.TezCompiler.runStatsAnnotation(TezCompiler.java:420)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.TezCompiler.optimizeOperatorPlan(TezCompiler.java:155)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:144)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:11898)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:304)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:280)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:616)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1570)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1523)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
~[hive-exec-3.0.0.3.0.0.0-1076.jar:3.0.0.3.0.0.0-1076]
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:198)
~[hive-service-3.0.0.3.0.0.0-1076.jar:3.0.0.3
{code}
> Useless error messages logged for dummy table stats
> ---------------------------------------------------
>
> Key: HIVE-19390
> URL: https://issues.apache.org/jira/browse/HIVE-19390
> Project: Hive
> Issue Type: Improvement
> Components: Statistics
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
> Priority: Major
> Attachments: HIVE-19390.patch
>
>
> Queries like INSERT INTO t1 VALUES (20); gets rewritten into insert into t1
> select 20 from default_db.default_tblname which later throws as compiler
> tries to get stats
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
