[jira] [Comment Edited] (HIVE-11534) Improve validateTableCols error message

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

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

Xuefu Zhang edited comment on HIVE-11534 at 8/14/15 10:46 PM:
--------------------------------------------------------------

Also pushed to branch-1.


was (Author: xuefuz):
Also pushed to branch-1.0.

> Improve validateTableCols error message
> ---------------------------------------
>
>                 Key: HIVE-11534
>                 URL: https://issues.apache.org/jira/browse/HIVE-11534
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: Mohit Sabharwal
>            Assignee: Mohit Sabharwal
>            Priority: Minor
>             Fix For: 1.3.0, 2.0.0
>
>         Attachments: HIVE-11534.patch
>
>
> For tables created without column definition in the DDL (but referencing the schema in the underlying file format like Avro), ObjectStore.validateTableCols throws an exception that doesn't include the table and db name.  This makes it tedious to lookup table name in schema files.
> Example:
> {code}
> ERROR org.apache.hadoop.hive.metastore.ObjectStore: Error retrieving statistics via jdo
> MetaException(message:Column wpp_mbrshp_hix_ik doesn't exist.)
> at org.apache.hadoop.hive.metastore.ObjectStore.validateTableCols(ObjectStore.java:6061)
> at org.apache.hadoop.hive.metastore.ObjectStore.getMTableColumnStatistics(ObjectStore.java:6012)
> at org.apache.hadoop.hive.metastore.ObjectStore.access$1000(ObjectStore.java:160)
> at org.apache.hadoop.hive.metastore.ObjectStore$6.getJdoResult(ObjectStore.java:6084)
> at org.apache.hadoop.hive.metastore.ObjectStore$6.getJdoResult(ObjectStore.java:6076)
> {code}
> We should add database and the table name to the error message.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)