[ https://issues.apache.org/jira/browse/HIVE-18890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749206#comment-16749206 ]
Hive QA commented on HIVE-18890: -------------------------------- | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 48s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 37s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 41s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 54s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 22s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 35s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 50s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 16s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15738/dev-support/hive-personality.sh | | git revision | master / dfd63d9 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15738/yetus.txt | | Powered by | Apache Yetus http://yetus.apache.org | This message was automatically generated. > Lower Logging for "Table not found" Error > ----------------------------------------- > > Key: HIVE-18890 > URL: https://issues.apache.org/jira/browse/HIVE-18890 > Project: Hive > Issue Type: Improvement > Components: HiveServer2 > Affects Versions: 3.0.0 > Reporter: BELUGA BEHR > Assignee: Manoj Narayanan > Priority: Minor > Attachments: HIVE-18890.1.patch > > > https://github.com/apache/hive/blob/7cb31c03052b815665b3231f2e513b9e65d3ff8c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1105 > {code:java} > // Get the table from metastore > org.apache.hadoop.hive.metastore.api.Table tTable = null; > try { > tTable = getMSC().getTable(dbName, tableName); > } catch (NoSuchObjectException e) { > if (throwException) { > LOG.error("Table " + tableName + " not found: " + e.getMessage()); > throw new InvalidTableException(tableName); > } > return null; > } catch (Exception e) { > throw new HiveException("Unable to fetch table " + tableName + ". " + > e.getMessage(), e); > } > {code} > We should throw an exception or log it, but not both. Right [~mdrob] ? ;) > And in this case, we are generating scary ERROR level logging in the > HiveServer2 logs needlessly. This should not be reported as an application > error. It is a simple user error, indicated by catching the > _NoSuchObjectException_ Throwable, that can always be ignored by the service. > It is most likely a simple user typo of the table name. However, the more > serious general _Exception_ is not logged. This is backwards. > Please remove the _error_ level logging for the user error... or lower it to > _debug_ level logging. > Please include an _error_ level logging to the general Exception case, unless > this Exception is being captured up the stack, somewhere else, and is being > logged there at ERROR level logging. > {code} > -- Sample log messages found in HS2 logs > 2018-03-02 10:26:40,363 ERROR hive.ql.metadata.Hive: > [HiveServer2-Handler-Pool: Thread-4467]: Table default not found: > default.default table not found > 2018-03-02 10:26:40,367 ERROR hive.ql.metadata.Hive: > [HiveServer2-Handler-Pool: Thread-4467]: Table default not found: > default.default table not found > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)