hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [jira] [Commented] (HIVE-19190) Improve Logging for SemanticException Handling
Date Tue, 10 Jul 2018 14:27:00 GMT


BELUGA BEHR commented on HIVE-19190:

[~aihuaxu] [~afan]

> Improve Logging for SemanticException Handling
> ----------------------------------------------
>                 Key: HIVE-19190
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: HiveServer2
>    Affects Versions: 3.0.0, 2.3.2
>            Reporter: BELUGA BEHR
>            Priority: Major
>         Attachments: table_not_found_example.txt
> Please improve the logging for queries that fail with SemanticException.  For example,
when performing an action on a table that does not exist.  The most common reason why
this happens is that someone fat fingers the table/column name.  It is not a system error
pe se, but a user validation error.  This is not something the cluster administrator should
have to worry about.  Yet, Hive performs some pretty extreme logging on the matter.  I have
attached to this JIRA the logging produced by a single submission of the following query:
> {code:sql}
> select * from madeup;
> {code}
> For SemanticException exceptions, please print the Exception {{getMessage()}} to the
server INFO logging so that the query's life-cycle can be traced, but do not blast ERRORs
and stack traces to the log file.

This message was sent by Atlassian JIRA

View raw message