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

Hive QA commented on HIVE-7213:
-------------------------------



{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/12655313/HIVE-7213.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 5703 tests executed
*Failed tests:*
{noformat}
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes
org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
{noformat}

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

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: 12655313

> COUNT(*) returns out-dated count value after TRUNCATE or INSERT INTO
> --------------------------------------------------------------------
>
>                 Key: HIVE-7213
>                 URL: https://issues.apache.org/jira/browse/HIVE-7213
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, Statistics
>    Affects Versions: 0.13.0
>         Environment: HDP 2.1
> Windows Server 2012 64-bit
>            Reporter: Moustafa Aboul Atta
>            Assignee: Ashutosh Chauhan
>         Attachments: HIVE-7213.patch
>
>
> Running a query to count number of rows in a table through
> {{SELECT COUNT( * ) FROM t}}
> always returns the last number of rows added through the following statement:
> {{INSERT INTO TABLE t SELECT r FROM t2}}
> However, running
> {{SELECT * FROM t}}
> returns the expected results i.e. the old and newly added rows.
> Also running 
> {{TRUNCATE TABLE t;}}
> returns the original count of rows in the table, however running 
> {{SELECT * FROM t;}}
> returns nothing as expected



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to