You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/02/25 01:42:18 UTC
[jira] [Commented] (HAWQ-452) Remove workfile views from
hawq_toolkit
[ https://issues.apache.org/jira/browse/HAWQ-452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15166436#comment-15166436 ]
ASF GitHub Bot commented on HAWQ-452:
-------------------------------------
GitHub user gcaragea opened a pull request:
https://github.com/apache/incubator-hawq/pull/385
HAWQ-452. Remove the workfile views from hawq_toolkit
In the hawq_toolkit schema we have a few views with live information about disk space used for workfiles (or spillfiles).
Generating this views means running a UDF on every segment. This doesn't apply to the HAWQ 2 architecture:
* The notion of "every segment" is not well defined in HAWQ 2, since we have virtual segments that are created dynamically based on resource requirements and availablitiy
* There is no mechanism to execute a UDF on all the existing virtual or physical segments
Removing the views from hawq_toolkit.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gcaragea/incubator-hawq gcaragea-segspace-remove
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/385.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 #385
----
commit 24fae2c1c04a6cc3166c71df26b107d88671ff70
Author: George Caragea <gc...@pivotal.io>
Date: 2016-02-25T08:30:08Z
HAWQ-452. Remove the workfile views from hawq_toolkit
In the hawq_toolkit schema we have a few views with live information about disk space used for workfiles (or spillfiles).
Generating this views means running a UDF on every segment. This doesn't apply to the HAWQ 2 architecture:
* The notion of "every segment" is not well defined in HAWQ 2, since we have virtual segments that are created dynamically based on resource requirements and availablitiy
* There is no mechanism to execute a UDF on all the existing virtual or physical segments
Removing the views from hawq_toolkit.
----
> Remove workfile views from hawq_toolkit
> ---------------------------------------
>
> Key: HAWQ-452
> URL: https://issues.apache.org/jira/browse/HAWQ-452
> Project: Apache HAWQ
> Issue Type: Task
> Components: Query Execution
> Reporter: George Caragea
> Assignee: George Caragea
>
> In the hawq_toolkit schema we have a few views with live information about disk space used for workfiles (or spillfiles).
> Generating this views means running a UDF on every segment. This doesn't apply to the HAWQ 2 architecture:
> * The notion of "every segment" is not well defined in HAWQ 2, since we have virtual segments that are created dynamically based on resource requirements and availablitiy
> * There is no mechanism to execute a UDF on all the existing virtual or physical segments
> We should remove the views from hawq_toolkit.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)