[jira] [Commented] (HIVE-8706) Table statistic collection on counter failed due to table name character case.

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

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

Hive QA commented on HIVE-8706:
-------------------------------



{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/12678918/HIVE-8706.1.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6669 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.ql.io.parquet.serde.TestParquetTimestampUtils.testTimezone
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyCommit
{noformat}

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

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: 2 tests failed
{noformat}

This message is automatically generated.

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

> Table statistic collection on counter failed due to table name character case.
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-8706
>                 URL: https://issues.apache.org/jira/browse/HIVE-8706
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.1
>            Reporter: Chengxiang Li
>            Assignee: Chengxiang Li
>         Attachments: HIVE-8706.1.patch
>
>
> Hive ignore table name character case, transfer table name to lowercase in metastore, while Counters/TezCounters are character case sensitive. This difference may lead to table statistic collection failed, as when Hive collection table statistic based on Counters, and hive use table name as the group name of counter. 
> ctas.q is an example, during the INSERT OVERWRITE TABLE sql execution, table name contains uppercase characters, Hive gather table statistic in FileSinkOperator with uppercase table name(translated  from sql), and aggregate table statistic in StatsTask with lowercase table name(from metastore), which would failed table statistic collection.



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