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

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-11534:
--------------------------------



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12749999/HIVE-11534.patch

{color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 9352 tests executed
*Failed tests:*
{noformat}
TestCustomAuthentication - did not produce a TEST-*.xml file
org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testMetastoreProxyUser
org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore
org.apache.hive.hcatalog.api.TestHCatClient.testReplicationTaskIter
org.apache.hive.jdbc.TestSSL.testSSLFetchHttp
org.apache.hive.spark.client.TestSparkClient.testJobSubmission
org.apache.hive.spark.client.TestSparkClient.testMetricsCollection
org.apache.hive.spark.client.TestSparkClient.testSyncRpc
{noformat}

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4934/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4934/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4934/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 8 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12749999 - PreCommit-HIVE-TRUNK-Build

> 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
>         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)