[
https://issues.apache.org/jira/browse/HAWQ-70?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15075642#comment-15075642
]
ASF GitHub Bot commented on HAWQ-70:
------------------------------------
GitHub user wengyanqing opened a pull request:
https://github.com/apache/incubator-hawq/pull/235
HAWQ-70. Refetch file's all block locations when partly hit metadata …
re-fetch file's all block locations, because hdfs will give incorrect
result when fetch partly
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/wengyanqing/incubator-hawq metadata_refetch
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/235.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #235
----
commit ff85066978fbe79edb0bc8d0f71f5627209bf2ab
Author: ivan <[email protected]>
Date: 2015-12-31T02:26:25Z
HAWQ-70. Refetch file's all block locations when partly hit metadata cache
----
> INSERT INTO foo SELECT * FROM foo returned successful, but the data of foo
> was not as expected.
> -----------------------------------------------------------------------------------------------
>
> Key: HAWQ-70
> URL: https://issues.apache.org/jira/browse/HAWQ-70
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Query Execution
> Reporter: Lirong Jian
> Assignee: George Caragea
>
> Reproduce steps:
> postgres=# CREATE TABLE foo (a INT);
> CREATE TABLE
> postgres=# INSERT INTO foo VALUES(generate_series(1, 25000000));
> INSERT 0 25000000
> postgres=# SELECT COUNT(*) FROM foo;
> count
> ----------
> 25000000
> (1 row)
> postgres=# INSERT INTO foo SELECT * FROM foo;
> INSERT 0 25000000
> postgres=# SELECT COUNT(*) FROM foo;
> count
> ----------
> 38402176
> (1 row)
> The expected answer is 50000000.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
