[jira] [Assigned] (HAWQ-1231) RM should error out when nvseg in statement level is greater than the guc for nvseg per seg.
[ https://issues.apache.org/jira/browse/HAWQ-1231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiang Sheng reassigned HAWQ-1231: - Assignee: Xiang Sheng (was: Ed Espino) > RM should error out when nvseg in statement level is greater than the guc for > nvseg per seg. > > > Key: HAWQ-1231 > URL: https://issues.apache.org/jira/browse/HAWQ-1231 > Project: Apache HAWQ > Issue Type: Bug > Components: Resource Manager >Reporter: Xiang Sheng >Assignee: Xiang Sheng > Fix For: backlog > > > If user set a larget nvseg in statement level, the nvseg is greater than the > guc nvseg per seg, rm won't report error. It will allocate according to nvseg > per seg. But this cannot satisfy statement level nvseg. RM will timeout at > last. This behaviors is not reasonable. We should error out directly and tell > user if he wants the nvseg in statement, he must change the guc ( > hawq_rm_nvseg_perquery_perseg_limit ) accordingly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-1231) RM should error out when nvseg in statement level is greater than the guc for nvseg per seg.
Xiang Sheng created HAWQ-1231: - Summary: RM should error out when nvseg in statement level is greater than the guc for nvseg per seg. Key: HAWQ-1231 URL: https://issues.apache.org/jira/browse/HAWQ-1231 Project: Apache HAWQ Issue Type: Bug Components: Resource Manager Reporter: Xiang Sheng Assignee: Ed Espino Fix For: backlog If user set a larget nvseg in statement level, the nvseg is greater than the guc nvseg per seg, rm won't report error. It will allocate according to nvseg per seg. But this cannot satisfy statement level nvseg. RM will timeout at last. This behaviors is not reasonable. We should error out directly and tell user if he wants the nvseg in statement, he must change the guc ( hawq_rm_nvseg_perquery_perseg_limit ) accordingly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-748) Fix platform issue in test framework
[ https://issues.apache.org/jira/browse/HAWQ-748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-748. Resolution: Fixed > Fix platform issue in test framework > > > Key: HAWQ-748 > URL: https://issues.apache.org/jira/browse/HAWQ-748 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-834) Refactor goh_portals checkinstall cases using new test framework.
[ https://issues.apache.org/jira/browse/HAWQ-834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-834. -- > Refactor goh_portals checkinstall cases using new test framework. > - > > Key: HAWQ-834 > URL: https://issues.apache.org/jira/browse/HAWQ-834 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Hubert Zhang >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > > refactor goh_portals with new test framework -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-834) Refactor goh_portals checkinstall cases using new test framework.
[ https://issues.apache.org/jira/browse/HAWQ-834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-834. Resolution: Fixed > Refactor goh_portals checkinstall cases using new test framework. > - > > Key: HAWQ-834 > URL: https://issues.apache.org/jira/browse/HAWQ-834 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Hubert Zhang >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > > refactor goh_portals with new test framework -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-748) Fix platform issue in test framework
[ https://issues.apache.org/jira/browse/HAWQ-748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-748: --- Labels: (was: ToBeClosed) > Fix platform issue in test framework > > > Key: HAWQ-748 > URL: https://issues.apache.org/jira/browse/HAWQ-748 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-753) Add parquet test using new test library
[ https://issues.apache.org/jira/browse/HAWQ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-753: --- Labels: (was: ToBeClosed) > Add parquet test using new test library > --- > > Key: HAWQ-753 > URL: https://issues.apache.org/jira/browse/HAWQ-753 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-834) Refactor goh_portals checkinstall cases using new test framework.
[ https://issues.apache.org/jira/browse/HAWQ-834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-834: --- Labels: (was: ToBeClosed) > Refactor goh_portals checkinstall cases using new test framework. > - > > Key: HAWQ-834 > URL: https://issues.apache.org/jira/browse/HAWQ-834 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Hubert Zhang >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > > refactor goh_portals with new test framework -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-753) Add parquet test using new test library
[ https://issues.apache.org/jira/browse/HAWQ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-753. Resolution: Fixed > Add parquet test using new test library > --- > > Key: HAWQ-753 > URL: https://issues.apache.org/jira/browse/HAWQ-753 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-748) Fix platform issue in test framework
[ https://issues.apache.org/jira/browse/HAWQ-748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-748. -- > Fix platform issue in test framework > > > Key: HAWQ-748 > URL: https://issues.apache.org/jira/browse/HAWQ-748 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-730. Resolution: Fixed > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-732) Workable test framework
[ https://issues.apache.org/jira/browse/HAWQ-732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-732. -- > Workable test framework > --- > > Key: HAWQ-732 > URL: https://issues.apache.org/jira/browse/HAWQ-732 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-730: --- Labels: (was: ToBeClosed) > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-740) Fix bug in SQLUtility
[ https://issues.apache.org/jira/browse/HAWQ-740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-740: --- Labels: (was: ToBeClosed) > Fix bug in SQLUtility > - > > Key: HAWQ-740 > URL: https://issues.apache.org/jira/browse/HAWQ-740 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-740) Fix bug in SQLUtility
[ https://issues.apache.org/jira/browse/HAWQ-740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-740. -- > Fix bug in SQLUtility > - > > Key: HAWQ-740 > URL: https://issues.apache.org/jira/browse/HAWQ-740 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-732) Workable test framework
[ https://issues.apache.org/jira/browse/HAWQ-732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-732: --- Labels: (was: ToBeClosed) > Workable test framework > --- > > Key: HAWQ-732 > URL: https://issues.apache.org/jira/browse/HAWQ-732 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-732) Workable test framework
[ https://issues.apache.org/jira/browse/HAWQ-732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-732. Resolution: Fixed > Workable test framework > --- > > Key: HAWQ-732 > URL: https://issues.apache.org/jira/browse/HAWQ-732 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-740) Fix bug in SQLUtility
[ https://issues.apache.org/jira/browse/HAWQ-740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-740. Resolution: Fixed > Fix bug in SQLUtility > - > > Key: HAWQ-740 > URL: https://issues.apache.org/jira/browse/HAWQ-740 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-730. -- > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-728) add wrapper SQLUtility for test usage
[ https://issues.apache.org/jira/browse/HAWQ-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-728. Resolution: Fixed > add wrapper SQLUtility for test usage > - > > Key: HAWQ-728 > URL: https://issues.apache.org/jira/browse/HAWQ-728 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-583) Extend PXF to allow plugins to support returning partial content of SELECT(column projection)
[ https://issues.apache.org/jira/browse/HAWQ-583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-583. -- > Extend PXF to allow plugins to support returning partial content of > SELECT(column projection) > - > > Key: HAWQ-583 > URL: https://issues.apache.org/jira/browse/HAWQ-583 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Michael Andre Pearce (IG) >Assignee: Kavinder Dhaliwal > Fix For: 2.1.0.0-incubating > > > Currently PXF supports being able to push down the predicate WHERE logic to > the external system to reduce the amount data needed to be retrieved. > SELECT a, b FROM external_pxf_source WHERE z < 3 AND x > 6 > As such we can filter the rows returned, but currently still would have to > return all the fields / complete row. > This proposal is so that we can return only the columns in SELECT part. > For data sources where it is columnar storage or selectable such as remote > database that PXF can read or connect to this has advantages in the data that > needs to be accessed or even transferred. > As like with the push down Filter it should be optional so that plugins that > provide support can use it but others that do not, continue to work as they > do. > The proposal would be for > 1) create an interface created for plugins to optionally implement, where the > columns needed to be returned are given to the plugin. > 2) update pxf api for hawq to send columns defined in SELECT, for pxf to > invoke the plugin interface and pass this information onto if provided > 3) update pxf integration within hawq itself so that hawq passes this > additonal information to pxf. > This Ticket is off the back of discussion on HAWQ-492. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-77) Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements
[ https://issues.apache.org/jira/browse/HAWQ-77?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-77: -- Labels: (was: ToBeClosed) > Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements > -- > > Key: HAWQ-77 > URL: https://issues.apache.org/jira/browse/HAWQ-77 > Project: Apache HAWQ > Issue Type: Improvement > Components: Resource Manager >Reporter: Yi Jin >Assignee: Xiang Sheng > Fix For: 2.1.0.0-incubating > > > This is open to fix unresolved comments from HAWQ-25. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-728) add wrapper SQLUtility for test usage
[ https://issues.apache.org/jira/browse/HAWQ-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-728: --- Labels: (was: ToBeClosed) > add wrapper SQLUtility for test usage > - > > Key: HAWQ-728 > URL: https://issues.apache.org/jira/browse/HAWQ-728 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-583) Extend PXF to allow plugins to support returning partial content of SELECT(column projection)
[ https://issues.apache.org/jira/browse/HAWQ-583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-583. Resolution: Fixed > Extend PXF to allow plugins to support returning partial content of > SELECT(column projection) > - > > Key: HAWQ-583 > URL: https://issues.apache.org/jira/browse/HAWQ-583 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Michael Andre Pearce (IG) >Assignee: Kavinder Dhaliwal > Fix For: 2.1.0.0-incubating > > > Currently PXF supports being able to push down the predicate WHERE logic to > the external system to reduce the amount data needed to be retrieved. > SELECT a, b FROM external_pxf_source WHERE z < 3 AND x > 6 > As such we can filter the rows returned, but currently still would have to > return all the fields / complete row. > This proposal is so that we can return only the columns in SELECT part. > For data sources where it is columnar storage or selectable such as remote > database that PXF can read or connect to this has advantages in the data that > needs to be accessed or even transferred. > As like with the push down Filter it should be optional so that plugins that > provide support can use it but others that do not, continue to work as they > do. > The proposal would be for > 1) create an interface created for plugins to optionally implement, where the > columns needed to be returned are given to the plugin. > 2) update pxf api for hawq to send columns defined in SELECT, for pxf to > invoke the plugin interface and pass this information onto if provided > 3) update pxf integration within hawq itself so that hawq passes this > additonal information to pxf. > This Ticket is off the back of discussion on HAWQ-492. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-583) Extend PXF to allow plugins to support returning partial content of SELECT(column projection)
[ https://issues.apache.org/jira/browse/HAWQ-583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-583: --- Labels: (was: ToBeClosed) > Extend PXF to allow plugins to support returning partial content of > SELECT(column projection) > - > > Key: HAWQ-583 > URL: https://issues.apache.org/jira/browse/HAWQ-583 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Michael Andre Pearce (IG) >Assignee: Kavinder Dhaliwal > Fix For: 2.1.0.0-incubating > > > Currently PXF supports being able to push down the predicate WHERE logic to > the external system to reduce the amount data needed to be retrieved. > SELECT a, b FROM external_pxf_source WHERE z < 3 AND x > 6 > As such we can filter the rows returned, but currently still would have to > return all the fields / complete row. > This proposal is so that we can return only the columns in SELECT part. > For data sources where it is columnar storage or selectable such as remote > database that PXF can read or connect to this has advantages in the data that > needs to be accessed or even transferred. > As like with the push down Filter it should be optional so that plugins that > provide support can use it but others that do not, continue to work as they > do. > The proposal would be for > 1) create an interface created for plugins to optionally implement, where the > columns needed to be returned are given to the plugin. > 2) update pxf api for hawq to send columns defined in SELECT, for pxf to > invoke the plugin interface and pass this information onto if provided > 3) update pxf integration within hawq itself so that hawq passes this > additonal information to pxf. > This Ticket is off the back of discussion on HAWQ-492. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-77) Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements
[ https://issues.apache.org/jira/browse/HAWQ-77?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-77. - > Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements > -- > > Key: HAWQ-77 > URL: https://issues.apache.org/jira/browse/HAWQ-77 > Project: Apache HAWQ > Issue Type: Improvement > Components: Resource Manager >Reporter: Yi Jin >Assignee: Xiang Sheng > Fix For: 2.1.0.0-incubating > > > This is open to fix unresolved comments from HAWQ-25. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-728) add wrapper SQLUtility for test usage
[ https://issues.apache.org/jira/browse/HAWQ-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-728. -- > add wrapper SQLUtility for test usage > - > > Key: HAWQ-728 > URL: https://issues.apache.org/jira/browse/HAWQ-728 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Affects Versions: 2.0.0.0-incubating >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-77) Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements
[ https://issues.apache.org/jira/browse/HAWQ-77?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-77. --- Resolution: Fixed > Fix source code comment for new ALTER/CREATE RESOURCE QUEUE ddl statements > -- > > Key: HAWQ-77 > URL: https://issues.apache.org/jira/browse/HAWQ-77 > Project: Apache HAWQ > Issue Type: Improvement > Components: Resource Manager >Reporter: Yi Jin >Assignee: Xiang Sheng > Fix For: 2.1.0.0-incubating > > > This is open to fix unresolved comments from HAWQ-25. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-924) Refactor feature test for querycontext with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-924. Resolution: Fixed > Refactor feature test for querycontext with new test framework > -- > > Key: HAWQ-924 > URL: https://issues.apache.org/jira/browse/HAWQ-924 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > > From code side, QueryContextDispatchingSizeMemoryLimit is disabled. So no > need to test it anymore. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-917) Refactor feature tests for data type check with new googletest framework
[ https://issues.apache.org/jira/browse/HAWQ-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-917: --- Labels: (was: ToBeClosed) > Refactor feature tests for data type check with new googletest framework > > > Key: HAWQ-917 > URL: https://issues.apache.org/jira/browse/HAWQ-917 > Project: Apache HAWQ > Issue Type: Sub-task >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This needs to refactor the following 15 test cases. > ../../../regress/sql/boolean.sql > ../../../regress/sql/char.sql > ../../../regress/sql/date.sql > ../../../regress/sql/float4.sql > ../../../regress/sql/float8.sql > ../../../regress/sql/int2.sql > ../../../regress/sql/int4.sql > ../../../regress/sql/int8.sql > ../../../regress/sql/money.sql > ../../../regress/sql/name.sql > ../../../regress/sql/oid.sql > ../../../regress/sql/text.sql > ../../../regress/sql/time.sql > ../../../regress/sql/type_sanity.sql > ../../../regress/sql/varchar.sql -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-925) Set default locale, timezone & datastyle before running sql command/file
[ https://issues.apache.org/jira/browse/HAWQ-925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-925. -- > Set default locale, timezone & datastyle before running sql command/file > > > Key: HAWQ-925 > URL: https://issues.apache.org/jira/browse/HAWQ-925 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > So that sql output could be consistent. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-922) Add basic verification for various pl and udf in HAWQ
[ https://issues.apache.org/jira/browse/HAWQ-922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-922: --- Labels: (was: ToBeClosed) > Add basic verification for various pl and udf in HAWQ > - > > Key: HAWQ-922 > URL: https://issues.apache.org/jira/browse/HAWQ-922 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Upgrade >Affects Versions: 2.0.0.0-incubating >Reporter: Ruilong Huo >Assignee: Ruilong Huo > Fix For: 2.1.0.0-incubating > > > For HAWQ upgrade from 2.0.0.0 to 2.0.1.0 related tasks, we need to add basic > data verification for hawq upgrade, including procedural languages, > user-defined functions, etc. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-922) Add basic verification for various pl and udf in HAWQ
[ https://issues.apache.org/jira/browse/HAWQ-922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-922. -- > Add basic verification for various pl and udf in HAWQ > - > > Key: HAWQ-922 > URL: https://issues.apache.org/jira/browse/HAWQ-922 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Upgrade >Affects Versions: 2.0.0.0-incubating >Reporter: Ruilong Huo >Assignee: Ruilong Huo > Fix For: 2.1.0.0-incubating > > > For HAWQ upgrade from 2.0.0.0 to 2.0.1.0 related tasks, we need to add basic > data verification for hawq upgrade, including procedural languages, > user-defined functions, etc. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-922) Add basic verification for various pl and udf in HAWQ
[ https://issues.apache.org/jira/browse/HAWQ-922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-922. Resolution: Fixed > Add basic verification for various pl and udf in HAWQ > - > > Key: HAWQ-922 > URL: https://issues.apache.org/jira/browse/HAWQ-922 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Upgrade >Affects Versions: 2.0.0.0-incubating >Reporter: Ruilong Huo >Assignee: Ruilong Huo > Fix For: 2.1.0.0-incubating > > > For HAWQ upgrade from 2.0.0.0 to 2.0.1.0 related tasks, we need to add basic > data verification for hawq upgrade, including procedural languages, > user-defined functions, etc. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-924) Refactor feature test for querycontext with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-924. -- > Refactor feature test for querycontext with new test framework > -- > > Key: HAWQ-924 > URL: https://issues.apache.org/jira/browse/HAWQ-924 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > > From code side, QueryContextDispatchingSizeMemoryLimit is disabled. So no > need to test it anymore. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-925) Set default locale, timezone & datastyle before running sql command/file
[ https://issues.apache.org/jira/browse/HAWQ-925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-925: --- Labels: (was: ToBeClosed) > Set default locale, timezone & datastyle before running sql command/file > > > Key: HAWQ-925 > URL: https://issues.apache.org/jira/browse/HAWQ-925 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > So that sql output could be consistent. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-924) Refactor feature test for querycontext with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-924: --- Labels: (was: ToBeClosed) > Refactor feature test for querycontext with new test framework > -- > > Key: HAWQ-924 > URL: https://issues.apache.org/jira/browse/HAWQ-924 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: zhenglin tao >Assignee: zhenglin tao > Fix For: 2.1.0.0-incubating > > > From code side, QueryContextDispatchingSizeMemoryLimit is disabled. So no > need to test it anymore. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-917) Refactor feature tests for data type check with new googletest framework
[ https://issues.apache.org/jira/browse/HAWQ-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-917. -- > Refactor feature tests for data type check with new googletest framework > > > Key: HAWQ-917 > URL: https://issues.apache.org/jira/browse/HAWQ-917 > Project: Apache HAWQ > Issue Type: Sub-task >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This needs to refactor the following 15 test cases. > ../../../regress/sql/boolean.sql > ../../../regress/sql/char.sql > ../../../regress/sql/date.sql > ../../../regress/sql/float4.sql > ../../../regress/sql/float8.sql > ../../../regress/sql/int2.sql > ../../../regress/sql/int4.sql > ../../../regress/sql/int8.sql > ../../../regress/sql/money.sql > ../../../regress/sql/name.sql > ../../../regress/sql/oid.sql > ../../../regress/sql/text.sql > ../../../regress/sql/time.sql > ../../../regress/sql/type_sanity.sql > ../../../regress/sql/varchar.sql -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-925) Set default locale, timezone & datastyle before running sql command/file
[ https://issues.apache.org/jira/browse/HAWQ-925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-925. Resolution: Fixed > Set default locale, timezone & datastyle before running sql command/file > > > Key: HAWQ-925 > URL: https://issues.apache.org/jira/browse/HAWQ-925 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > So that sql output could be consistent. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-900) Add dependency in PL/R rpm build spec file plr.spec
[ https://issues.apache.org/jira/browse/HAWQ-900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-900. Resolution: Fixed > Add dependency in PL/R rpm build spec file plr.spec > --- > > Key: HAWQ-900 > URL: https://issues.apache.org/jira/browse/HAWQ-900 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > Building of plr depends on R-devel, while using of plr depends on R. In > theory they depends on hawq also but we do not seem to be mandatory to have a > hawq rpm for hawq installation, so the dependencies could be R stuffs only. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-914) Improve user experience of HAWQ's build infrastructure
[ https://issues.apache.org/jira/browse/HAWQ-914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-914. Resolution: Fixed > Improve user experience of HAWQ's build infrastructure > -- > > Key: HAWQ-914 > URL: https://issues.apache.org/jira/browse/HAWQ-914 > Project: Apache HAWQ > Issue Type: Improvement > Components: Build >Affects Versions: 2.0.0.0-incubating >Reporter: Roman Shaposhnik >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This is likely to end up being an umbrella JIRA so feel free to fork off > sub-tasks whenever it makes sense. > As an end-user of HAWQ's build system, I'd like to see the default of the > build system (running configure/etc. with no arguments) to be: > # treating optional missing dependencies with a WARNING similar to what > PostrgreSQL configure does in the following example: > {noformat} > checking for bison... no > configure: WARNING: > *** Without Bison you will not be able to build PostgreSQL from CVS nor > *** change any of the parser definition files. You can obtain Bison from > *** a GNU mirror site. (If you are using the official distribution of > *** PostgreSQL then you do not need to worry about this, because the Bison > *** output is pre-generated.) To use a different yacc program (possible, > *** but not recommended), set the environment variable YACC before running > *** 'configure'. > {noformat} > # treating all the missing suggested dependencies by failing the build and > suggesting how to point at binary copies of these missing dependencies > similar to what PostrgreSQL configure does in the following example: > {noformat} > checking for -ledit... no > configure: error: readline library not found > If you have readline already installed, see config.log for details on the > failure. It is possible the compiler isn't looking in the proper directory. > Use --without-readline to disable readline support. > {noformat} > # treating the core dependencies same as suggested dependencies, but > obviously about the option of continuing the build without them. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-894) Add feature test for polymorphism with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-894: --- Labels: (was: ToBeClosed) > Add feature test for polymorphism with new test framework > - > > Key: HAWQ-894 > URL: https://issues.apache.org/jira/browse/HAWQ-894 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Lin Wen >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-900) Add dependency in PL/R rpm build spec file plr.spec
[ https://issues.apache.org/jira/browse/HAWQ-900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-900: --- Labels: (was: ToBeClosed) > Add dependency in PL/R rpm build spec file plr.spec > --- > > Key: HAWQ-900 > URL: https://issues.apache.org/jira/browse/HAWQ-900 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > Building of plr depends on R-devel, while using of plr depends on R. In > theory they depends on hawq also but we do not seem to be mandatory to have a > hawq rpm for hawq installation, so the dependencies could be R stuffs only. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-917) Refactor feature tests for data type check with new googletest framework
[ https://issues.apache.org/jira/browse/HAWQ-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-917. Resolution: Fixed > Refactor feature tests for data type check with new googletest framework > > > Key: HAWQ-917 > URL: https://issues.apache.org/jira/browse/HAWQ-917 > Project: Apache HAWQ > Issue Type: Sub-task >Reporter: Paul Guo >Assignee: Paul Guo > Labels: ToBeClosed > Fix For: 2.1.0.0-incubating > > > This needs to refactor the following 15 test cases. > ../../../regress/sql/boolean.sql > ../../../regress/sql/char.sql > ../../../regress/sql/date.sql > ../../../regress/sql/float4.sql > ../../../regress/sql/float8.sql > ../../../regress/sql/int2.sql > ../../../regress/sql/int4.sql > ../../../regress/sql/int8.sql > ../../../regress/sql/money.sql > ../../../regress/sql/name.sql > ../../../regress/sql/oid.sql > ../../../regress/sql/text.sql > ../../../regress/sql/time.sql > ../../../regress/sql/type_sanity.sql > ../../../regress/sql/varchar.sql -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-914) Improve user experience of HAWQ's build infrastructure
[ https://issues.apache.org/jira/browse/HAWQ-914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-914. -- > Improve user experience of HAWQ's build infrastructure > -- > > Key: HAWQ-914 > URL: https://issues.apache.org/jira/browse/HAWQ-914 > Project: Apache HAWQ > Issue Type: Improvement > Components: Build >Affects Versions: 2.0.0.0-incubating >Reporter: Roman Shaposhnik >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This is likely to end up being an umbrella JIRA so feel free to fork off > sub-tasks whenever it makes sense. > As an end-user of HAWQ's build system, I'd like to see the default of the > build system (running configure/etc. with no arguments) to be: > # treating optional missing dependencies with a WARNING similar to what > PostrgreSQL configure does in the following example: > {noformat} > checking for bison... no > configure: WARNING: > *** Without Bison you will not be able to build PostgreSQL from CVS nor > *** change any of the parser definition files. You can obtain Bison from > *** a GNU mirror site. (If you are using the official distribution of > *** PostgreSQL then you do not need to worry about this, because the Bison > *** output is pre-generated.) To use a different yacc program (possible, > *** but not recommended), set the environment variable YACC before running > *** 'configure'. > {noformat} > # treating all the missing suggested dependencies by failing the build and > suggesting how to point at binary copies of these missing dependencies > similar to what PostrgreSQL configure does in the following example: > {noformat} > checking for -ledit... no > configure: error: readline library not found > If you have readline already installed, see config.log for details on the > failure. It is possible the compiler isn't looking in the proper directory. > Use --without-readline to disable readline support. > {noformat} > # treating the core dependencies same as suggested dependencies, but > obviously about the option of continuing the build without them. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-914) Improve user experience of HAWQ's build infrastructure
[ https://issues.apache.org/jira/browse/HAWQ-914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-914: --- Labels: (was: ToBeClosed) > Improve user experience of HAWQ's build infrastructure > -- > > Key: HAWQ-914 > URL: https://issues.apache.org/jira/browse/HAWQ-914 > Project: Apache HAWQ > Issue Type: Improvement > Components: Build >Affects Versions: 2.0.0.0-incubating >Reporter: Roman Shaposhnik >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This is likely to end up being an umbrella JIRA so feel free to fork off > sub-tasks whenever it makes sense. > As an end-user of HAWQ's build system, I'd like to see the default of the > build system (running configure/etc. with no arguments) to be: > # treating optional missing dependencies with a WARNING similar to what > PostrgreSQL configure does in the following example: > {noformat} > checking for bison... no > configure: WARNING: > *** Without Bison you will not be able to build PostgreSQL from CVS nor > *** change any of the parser definition files. You can obtain Bison from > *** a GNU mirror site. (If you are using the official distribution of > *** PostgreSQL then you do not need to worry about this, because the Bison > *** output is pre-generated.) To use a different yacc program (possible, > *** but not recommended), set the environment variable YACC before running > *** 'configure'. > {noformat} > # treating all the missing suggested dependencies by failing the build and > suggesting how to point at binary copies of these missing dependencies > similar to what PostrgreSQL configure does in the following example: > {noformat} > checking for -ledit... no > configure: error: readline library not found > If you have readline already installed, see config.log for details on the > failure. It is possible the compiler isn't looking in the proper directory. > Use --without-readline to disable readline support. > {noformat} > # treating the core dependencies same as suggested dependencies, but > obviously about the option of continuing the build without them. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-900) Add dependency in PL/R rpm build spec file plr.spec
[ https://issues.apache.org/jira/browse/HAWQ-900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-900. -- > Add dependency in PL/R rpm build spec file plr.spec > --- > > Key: HAWQ-900 > URL: https://issues.apache.org/jira/browse/HAWQ-900 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > Building of plr depends on R-devel, while using of plr depends on R. In > theory they depends on hawq also but we do not seem to be mandatory to have a > hawq rpm for hawq installation, so the dependencies could be R stuffs only. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-907) Add feature test for caqlinmem with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-907. -- > Add feature test for caqlinmem with new test framework > -- > > Key: HAWQ-907 > URL: https://issues.apache.org/jira/browse/HAWQ-907 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Ivan Weng >Assignee: Ivan Weng > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-886) Investigation of HAWQ/PXF support for ORC
[ https://issues.apache.org/jira/browse/HAWQ-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-886. -- > Investigation of HAWQ/PXF support for ORC > - > > Key: HAWQ-886 > URL: https://issues.apache.org/jira/browse/HAWQ-886 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Shivram Mani >Assignee: Shivram Mani > Fix For: 2.1.0.0-incubating > > > Currently HAWQ when reading ORC files via PXF (using the default Hive > profile) doesn’t push down any of the filter information down to the > underlying ORC reader. The only filter that is possible right now is at the > level of partition and is generically done for all Hive tables. > ORC internally contains file level, stripe level and row level statistics > including information such as min,max values etc. For more information refer > to https://orc.apache.org/docs/indexes.html > The proposal here is to introduce a new PXF profile optimized for ORC files > which leverages these stats to improve the performance of HAWQ queries with > predicates. We will also use the Vectorized approach (VectorizedRowBatch) > while reading along with SearchArgument to build the filter as opposed to the > existing expensive reader which is row based. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-907) Add feature test for caqlinmem with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-907. Resolution: Fixed > Add feature test for caqlinmem with new test framework > -- > > Key: HAWQ-907 > URL: https://issues.apache.org/jira/browse/HAWQ-907 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Ivan Weng >Assignee: Ivan Weng > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-881) Output of 'hawq stop --reload' is not correct
[ https://issues.apache.org/jira/browse/HAWQ-881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-881. -- > Output of 'hawq stop --reload' is not correct > - > > Key: HAWQ-881 > URL: https://issues.apache.org/jira/browse/HAWQ-881 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools >Reporter: Radar Lei >Assignee: Radar Lei > Fix For: 2.1.0.0-incubating > > > hawq stop has an option to reload configuration changes. However when you > reload the log information displayed suggests that the cluster is stopped. > We should log 'reload' instead of 'stop' while running 'hawq stop > -u/--reload'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-894) Add feature test for polymorphism with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-894. -- > Add feature test for polymorphism with new test framework > - > > Key: HAWQ-894 > URL: https://issues.apache.org/jira/browse/HAWQ-894 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Lin Wen >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-894) Add feature test for polymorphism with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-894. Resolution: Fixed > Add feature test for polymorphism with new test framework > - > > Key: HAWQ-894 > URL: https://issues.apache.org/jira/browse/HAWQ-894 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Lin Wen >Assignee: Yi Jin > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-881) Output of 'hawq stop --reload' is not correct
[ https://issues.apache.org/jira/browse/HAWQ-881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-881: --- Labels: (was: ToBeClosed) > Output of 'hawq stop --reload' is not correct > - > > Key: HAWQ-881 > URL: https://issues.apache.org/jira/browse/HAWQ-881 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools >Reporter: Radar Lei >Assignee: Radar Lei > Fix For: 2.1.0.0-incubating > > > hawq stop has an option to reload configuration changes. However when you > reload the log information displayed suggests that the cluster is stopped. > We should log 'reload' instead of 'stop' while running 'hawq stop > -u/--reload'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-890) .gitignore files generated by python build
[ https://issues.apache.org/jira/browse/HAWQ-890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-890. Resolution: Fixed > .gitignore files generated by python build > -- > > Key: HAWQ-890 > URL: https://issues.apache.org/jira/browse/HAWQ-890 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo >Priority: Minor > Fix For: 2.1.0.0-incubating > > > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/build/ > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/psi/_version.pyc > ../../tools/bin/pythonSrc/lockfile-0.9.1/build/ > ../../tools/bin/pythonSrc/pychecker-0.8.18/build/ > ../../tools/bin/pythonSrc/pycrypto-2.0.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/__init__.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/case.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/collector.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/compatibility.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/loader.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/main.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/result.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/runner.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/signals.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/suite.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/util.pyc -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-886) Investigation of HAWQ/PXF support for ORC
[ https://issues.apache.org/jira/browse/HAWQ-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-886. Resolution: Fixed > Investigation of HAWQ/PXF support for ORC > - > > Key: HAWQ-886 > URL: https://issues.apache.org/jira/browse/HAWQ-886 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Shivram Mani >Assignee: Shivram Mani > Fix For: 2.1.0.0-incubating > > > Currently HAWQ when reading ORC files via PXF (using the default Hive > profile) doesn’t push down any of the filter information down to the > underlying ORC reader. The only filter that is possible right now is at the > level of partition and is generically done for all Hive tables. > ORC internally contains file level, stripe level and row level statistics > including information such as min,max values etc. For more information refer > to https://orc.apache.org/docs/indexes.html > The proposal here is to introduce a new PXF profile optimized for ORC files > which leverages these stats to improve the performance of HAWQ queries with > predicates. We will also use the Vectorized approach (VectorizedRowBatch) > while reading along with SearchArgument to build the filter as opposed to the > existing expensive reader which is row based. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-907) Add feature test for caqlinmem with new test framework
[ https://issues.apache.org/jira/browse/HAWQ-907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-907: --- Labels: (was: ToBeClosed) > Add feature test for caqlinmem with new test framework > -- > > Key: HAWQ-907 > URL: https://issues.apache.org/jira/browse/HAWQ-907 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Ivan Weng >Assignee: Ivan Weng > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-890) .gitignore files generated by python build
[ https://issues.apache.org/jira/browse/HAWQ-890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-890: --- Labels: (was: ToBeClosed) > .gitignore files generated by python build > -- > > Key: HAWQ-890 > URL: https://issues.apache.org/jira/browse/HAWQ-890 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo >Priority: Minor > Fix For: 2.1.0.0-incubating > > > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/build/ > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/psi/_version.pyc > ../../tools/bin/pythonSrc/lockfile-0.9.1/build/ > ../../tools/bin/pythonSrc/pychecker-0.8.18/build/ > ../../tools/bin/pythonSrc/pycrypto-2.0.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/__init__.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/case.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/collector.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/compatibility.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/loader.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/main.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/result.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/runner.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/signals.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/suite.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/util.pyc -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-886) Investigation of HAWQ/PXF support for ORC
[ https://issues.apache.org/jira/browse/HAWQ-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-886: --- Labels: (was: ToBeClosed) > Investigation of HAWQ/PXF support for ORC > - > > Key: HAWQ-886 > URL: https://issues.apache.org/jira/browse/HAWQ-886 > Project: Apache HAWQ > Issue Type: New Feature > Components: PXF >Reporter: Shivram Mani >Assignee: Shivram Mani > Fix For: 2.1.0.0-incubating > > > Currently HAWQ when reading ORC files via PXF (using the default Hive > profile) doesn’t push down any of the filter information down to the > underlying ORC reader. The only filter that is possible right now is at the > level of partition and is generically done for all Hive tables. > ORC internally contains file level, stripe level and row level statistics > including information such as min,max values etc. For more information refer > to https://orc.apache.org/docs/indexes.html > The proposal here is to introduce a new PXF profile optimized for ORC files > which leverages these stats to improve the performance of HAWQ queries with > predicates. We will also use the Vectorized approach (VectorizedRowBatch) > while reading along with SearchArgument to build the filter as opposed to the > existing expensive reader which is row based. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-890) .gitignore files generated by python build
[ https://issues.apache.org/jira/browse/HAWQ-890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-890. -- > .gitignore files generated by python build > -- > > Key: HAWQ-890 > URL: https://issues.apache.org/jira/browse/HAWQ-890 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo >Priority: Minor > Fix For: 2.1.0.0-incubating > > > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/build/ > ../../tools/bin/pythonSrc/PSI-0.3b2_gp/psi/_version.pyc > ../../tools/bin/pythonSrc/lockfile-0.9.1/build/ > ../../tools/bin/pythonSrc/pychecker-0.8.18/build/ > ../../tools/bin/pythonSrc/pycrypto-2.0.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/build/ > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/__init__.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/case.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/collector.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/compatibility.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/loader.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/main.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/result.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/runner.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/signals.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/suite.pyc > ../../tools/bin/pythonSrc/unittest2-0.5.1/unittest2/util.pyc -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-881) Output of 'hawq stop --reload' is not correct
[ https://issues.apache.org/jira/browse/HAWQ-881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-881. Resolution: Duplicate > Output of 'hawq stop --reload' is not correct > - > > Key: HAWQ-881 > URL: https://issues.apache.org/jira/browse/HAWQ-881 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools >Reporter: Radar Lei >Assignee: Radar Lei > Labels: ToBeClosed > Fix For: 2.1.0.0-incubating > > > hawq stop has an option to reload configuration changes. However when you > reload the log information displayed suggests that the cluster is stopped. > We should log 'reload' instead of 'stop' while running 'hawq stop > -u/--reload'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-977) mask and clean up some files after running feature_test cases.
[ https://issues.apache.org/jira/browse/HAWQ-977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-977. Resolution: Fixed > mask and clean up some files after running feature_test cases. > -- > > Key: HAWQ-977 > URL: https://issues.apache.org/jira/browse/HAWQ-977 > Project: Apache HAWQ > Issue Type: Bug > Components: Build >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Make "git status" neat. > 2) Need to remove those files after running "make clean". -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-977) mask and clean up some files after running feature_test cases.
[ https://issues.apache.org/jira/browse/HAWQ-977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-977. -- > mask and clean up some files after running feature_test cases. > -- > > Key: HAWQ-977 > URL: https://issues.apache.org/jira/browse/HAWQ-977 > Project: Apache HAWQ > Issue Type: Bug > Components: Build >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Make "git status" neat. > 2) Need to remove those files after running "make clean". -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'
[ https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-975. -- > Queries run much slower with 'explain analyze' than which without 'explain > analyze' > > > Key: HAWQ-975 > URL: https://issues.apache.org/jira/browse/HAWQ-975 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.0.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang >Priority: Critical > Fix For: 2.1.0.0-incubating > > > When we run queries with 'explain analyze' in AWS cluster, the total running > time is about 2-3 times longer than which without 'explain analyze'. > Here is a group of TPC-H results for queries with 'explain analyze' and > queries without 'explain analyze'. > ||query ||without 'explain analyze' ||with 'explain analyze' > ||multiple > |TPCH_Query_01| 311843 | 818658 | 2.63 > |TPCH_Query_02| 34675 | 117884 | 3.40 > |TPCH_Query_03| 166155 | 422131 | 2.54 > |TPCH_Query_04| 157807 | 507143 | 3.21 > |TPCH_Query_05| 272657 | 710573 | 2.61 > |TPCH_Query_06| 12508 | 22276 | 1.78 > |TPCH_Query_07| 71893 | 370338 | 5.15 > |TPCH_Query_08| 12 | 672625 | 5.17 > |TPCH_Query_09| 575709 | 1171672 | 2.04 > |TPCH_Query_10| 93770 | 233391 | 2.49 > |TPCH_Query_11| 16252 | 58360 | 3.59 > |TPCH_Query_12| 142576 | 237270 | 1.66 > |TPCH_Query_13| 72682 | 343257 | 4.72 > |TPCH_Query_14| 10410 | 32337 | 3.11 > |TPCH_Query_15| 25719 | 98705 | 3.84 > |TPCH_Query_16| 21382 | 76877 | 3.60 > |TPCH_Query_17| 839683 | 2041169 | 2.43 > |TPCH_Query_18| 460570 | 1065940 | 2.31 > |TPCH_Query_19| 69075 | 82286 | 1.19 > |TPCH_Query_20| 78263 | 292041 | 3.73 > |TPCH_Query_21| 505606 | 1549690 | 3.07 > |TPCH_Query_22| 56450 | 329837 | 5.84 > |Total| 4125684 | 11254460| > 2.73 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-977) mask and clean up some files after running feature_test cases.
[ https://issues.apache.org/jira/browse/HAWQ-977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-977: --- Labels: (was: ToBeClosed) > mask and clean up some files after running feature_test cases. > -- > > Key: HAWQ-977 > URL: https://issues.apache.org/jira/browse/HAWQ-977 > Project: Apache HAWQ > Issue Type: Bug > Components: Build >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Make "git status" neat. > 2) Need to remove those files after running "make clean". -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'
[ https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-975: --- Labels: (was: ToBeClosed) > Queries run much slower with 'explain analyze' than which without 'explain > analyze' > > > Key: HAWQ-975 > URL: https://issues.apache.org/jira/browse/HAWQ-975 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.0.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang >Priority: Critical > Fix For: 2.1.0.0-incubating > > > When we run queries with 'explain analyze' in AWS cluster, the total running > time is about 2-3 times longer than which without 'explain analyze'. > Here is a group of TPC-H results for queries with 'explain analyze' and > queries without 'explain analyze'. > ||query ||without 'explain analyze' ||with 'explain analyze' > ||multiple > |TPCH_Query_01| 311843 | 818658 | 2.63 > |TPCH_Query_02| 34675 | 117884 | 3.40 > |TPCH_Query_03| 166155 | 422131 | 2.54 > |TPCH_Query_04| 157807 | 507143 | 3.21 > |TPCH_Query_05| 272657 | 710573 | 2.61 > |TPCH_Query_06| 12508 | 22276 | 1.78 > |TPCH_Query_07| 71893 | 370338 | 5.15 > |TPCH_Query_08| 12 | 672625 | 5.17 > |TPCH_Query_09| 575709 | 1171672 | 2.04 > |TPCH_Query_10| 93770 | 233391 | 2.49 > |TPCH_Query_11| 16252 | 58360 | 3.59 > |TPCH_Query_12| 142576 | 237270 | 1.66 > |TPCH_Query_13| 72682 | 343257 | 4.72 > |TPCH_Query_14| 10410 | 32337 | 3.11 > |TPCH_Query_15| 25719 | 98705 | 3.84 > |TPCH_Query_16| 21382 | 76877 | 3.60 > |TPCH_Query_17| 839683 | 2041169 | 2.43 > |TPCH_Query_18| 460570 | 1065940 | 2.31 > |TPCH_Query_19| 69075 | 82286 | 1.19 > |TPCH_Query_20| 78263 | 292041 | 3.73 > |TPCH_Query_21| 505606 | 1549690 | 3.07 > |TPCH_Query_22| 56450 | 329837 | 5.84 > |Total| 4125684 | 11254460| > 2.73 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-969) Add getting configuration from HDFS and YARN
[ https://issues.apache.org/jira/browse/HAWQ-969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-969. Resolution: Fixed > Add getting configuration from HDFS and YARN > > > Key: HAWQ-969 > URL: https://issues.apache.org/jira/browse/HAWQ-969 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Add getting configuration from HDFS and YARN and writing xml file in > xml_parser.cpp. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-963) Enhance PXF to support Null operators
[ https://issues.apache.org/jira/browse/HAWQ-963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-963: --- Labels: (was: ToBeClosed) > Enhance PXF to support Null operators > - > > Key: HAWQ-963 > URL: https://issues.apache.org/jira/browse/HAWQ-963 > Project: Apache HAWQ > Issue Type: Improvement > Components: PXF >Reporter: Shivram Mani >Assignee: Alexander Denissov > Fix For: 2.1.0.0-incubating > > > Will need to add support for more operators in the PXF framework > isNull() and isNotNull() -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-969) Add getting configuration from HDFS and YARN
[ https://issues.apache.org/jira/browse/HAWQ-969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-969: --- Labels: (was: ToBeClosed) > Add getting configuration from HDFS and YARN > > > Key: HAWQ-969 > URL: https://issues.apache.org/jira/browse/HAWQ-969 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Add getting configuration from HDFS and YARN and writing xml file in > xml_parser.cpp. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-961) Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from master to segments
[ https://issues.apache.org/jira/browse/HAWQ-961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-961: --- Labels: (was: ToBeClosed) > Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from > master to segments > - > > Key: HAWQ-961 > URL: https://issues.apache.org/jira/browse/HAWQ-961 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This does not affect the functionality and security of hawq, but there are > users who want the session user id info on segments to do something. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-945) catalog:char/varchar test cases fail due to locale settings.
[ https://issues.apache.org/jira/browse/HAWQ-945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-945. -- > catalog:char/varchar test cases fail due to locale settings. > > > Key: HAWQ-945 > URL: https://issues.apache.org/jira/browse/HAWQ-945 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-961) Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from master to segments
[ https://issues.apache.org/jira/browse/HAWQ-961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-961. Resolution: Fixed > Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from > master to segments > - > > Key: HAWQ-961 > URL: https://issues.apache.org/jira/browse/HAWQ-961 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This does not affect the functionality and security of hawq, but there are > users who want the session user id info on segments to do something. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-969) Add getting configuration from HDFS and YARN
[ https://issues.apache.org/jira/browse/HAWQ-969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-969. -- > Add getting configuration from HDFS and YARN > > > Key: HAWQ-969 > URL: https://issues.apache.org/jira/browse/HAWQ-969 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Tests >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Add getting configuration from HDFS and YARN and writing xml file in > xml_parser.cpp. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-962) Make catalog:type_sanity be able to run with other cases in parallel
[ https://issues.apache.org/jira/browse/HAWQ-962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-962: --- Labels: (was: ToBeClosed) > Make catalog:type_sanity be able to run with other cases in parallel > > > Key: HAWQ-962 > URL: https://issues.apache.org/jira/browse/HAWQ-962 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > The test case will query some database-level system tables while with > parallel google testing is being enabled (see HAWQ-955. Add scriptS for > feature test running in parallel.), the test could fail. We need to create a > new database in the test case to avoid this.. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-943) Various issues in hawq register feature_test cases
[ https://issues.apache.org/jira/browse/HAWQ-943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-943. -- > Various issues in hawq register feature_test cases > -- > > Key: HAWQ-943 > URL: https://issues.apache.org/jira/browse/HAWQ-943 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Do not assume the test database is postgres. > Use HAWQ_DB which is defined in sql_util.h > 2) Use error immune options when creating a new hdfs file or directory. > e.g. mkdir -p, put -f. > Since nonexistence of those files/directories are not guaranteed. > e.g. Previous test run was terminated by ctrl+c. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-963) Enhance PXF to support Null operators
[ https://issues.apache.org/jira/browse/HAWQ-963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-963. Resolution: Fixed > Enhance PXF to support Null operators > - > > Key: HAWQ-963 > URL: https://issues.apache.org/jira/browse/HAWQ-963 > Project: Apache HAWQ > Issue Type: Improvement > Components: PXF >Reporter: Shivram Mani >Assignee: Alexander Denissov > Labels: ToBeClosed > Fix For: 2.1.0.0-incubating > > > Will need to add support for more operators in the PXF framework > isNull() and isNotNull() -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'
[ https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-975. Resolution: Not A Bug > Queries run much slower with 'explain analyze' than which without 'explain > analyze' > > > Key: HAWQ-975 > URL: https://issues.apache.org/jira/browse/HAWQ-975 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.0.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang >Priority: Critical > Fix For: 2.1.0.0-incubating > > > When we run queries with 'explain analyze' in AWS cluster, the total running > time is about 2-3 times longer than which without 'explain analyze'. > Here is a group of TPC-H results for queries with 'explain analyze' and > queries without 'explain analyze'. > ||query ||without 'explain analyze' ||with 'explain analyze' > ||multiple > |TPCH_Query_01| 311843 | 818658 | 2.63 > |TPCH_Query_02| 34675 | 117884 | 3.40 > |TPCH_Query_03| 166155 | 422131 | 2.54 > |TPCH_Query_04| 157807 | 507143 | 3.21 > |TPCH_Query_05| 272657 | 710573 | 2.61 > |TPCH_Query_06| 12508 | 22276 | 1.78 > |TPCH_Query_07| 71893 | 370338 | 5.15 > |TPCH_Query_08| 12 | 672625 | 5.17 > |TPCH_Query_09| 575709 | 1171672 | 2.04 > |TPCH_Query_10| 93770 | 233391 | 2.49 > |TPCH_Query_11| 16252 | 58360 | 3.59 > |TPCH_Query_12| 142576 | 237270 | 1.66 > |TPCH_Query_13| 72682 | 343257 | 4.72 > |TPCH_Query_14| 10410 | 32337 | 3.11 > |TPCH_Query_15| 25719 | 98705 | 3.84 > |TPCH_Query_16| 21382 | 76877 | 3.60 > |TPCH_Query_17| 839683 | 2041169 | 2.43 > |TPCH_Query_18| 460570 | 1065940 | 2.31 > |TPCH_Query_19| 69075 | 82286 | 1.19 > |TPCH_Query_20| 78263 | 292041 | 3.73 > |TPCH_Query_21| 505606 | 1549690 | 3.07 > |TPCH_Query_22| 56450 | 329837 | 5.84 > |Total| 4125684 | 11254460| > 2.73 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-945) catalog:char/varchar test cases fail due to locale settings.
[ https://issues.apache.org/jira/browse/HAWQ-945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-945: --- Labels: (was: ToBeClosed) > catalog:char/varchar test cases fail due to locale settings. > > > Key: HAWQ-945 > URL: https://issues.apache.org/jira/browse/HAWQ-945 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-963) Enhance PXF to support Null operators
[ https://issues.apache.org/jira/browse/HAWQ-963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-963. -- > Enhance PXF to support Null operators > - > > Key: HAWQ-963 > URL: https://issues.apache.org/jira/browse/HAWQ-963 > Project: Apache HAWQ > Issue Type: Improvement > Components: PXF >Reporter: Shivram Mani >Assignee: Alexander Denissov > Fix For: 2.1.0.0-incubating > > > Will need to add support for more operators in the PXF framework > isNull() and isNotNull() -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-943) Various issues in hawq register feature_test cases
[ https://issues.apache.org/jira/browse/HAWQ-943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-943: --- Labels: (was: ToBeClosed) > Various issues in hawq register feature_test cases > -- > > Key: HAWQ-943 > URL: https://issues.apache.org/jira/browse/HAWQ-943 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Do not assume the test database is postgres. > Use HAWQ_DB which is defined in sql_util.h > 2) Use error immune options when creating a new hdfs file or directory. > e.g. mkdir -p, put -f. > Since nonexistence of those files/directories are not guaranteed. > e.g. Previous test run was terminated by ctrl+c. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-962) Make catalog:type_sanity be able to run with other cases in parallel
[ https://issues.apache.org/jira/browse/HAWQ-962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-962. Resolution: Fixed > Make catalog:type_sanity be able to run with other cases in parallel > > > Key: HAWQ-962 > URL: https://issues.apache.org/jira/browse/HAWQ-962 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > The test case will query some database-level system tables while with > parallel google testing is being enabled (see HAWQ-955. Add scriptS for > feature test running in parallel.), the test could fail. We need to create a > new database in the test case to avoid this.. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-962) Make catalog:type_sanity be able to run with other cases in parallel
[ https://issues.apache.org/jira/browse/HAWQ-962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-962. -- > Make catalog:type_sanity be able to run with other cases in parallel > > > Key: HAWQ-962 > URL: https://issues.apache.org/jira/browse/HAWQ-962 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > The test case will query some database-level system tables while with > parallel google testing is being enabled (see HAWQ-955. Add scriptS for > feature test running in parallel.), the test could fail. We need to create a > new database in the test case to avoid this.. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-961) Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from master to segments
[ https://issues.apache.org/jira/browse/HAWQ-961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-961. -- > Dispatch session user info, instead of current BOOTSTRAP_SUPERUSERID, from > master to segments > - > > Key: HAWQ-961 > URL: https://issues.apache.org/jira/browse/HAWQ-961 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > This does not affect the functionality and security of hawq, but there are > users who want the session user id info on segments to do something. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-943) Various issues in hawq register feature_test cases
[ https://issues.apache.org/jira/browse/HAWQ-943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-943. Resolution: Fixed > Various issues in hawq register feature_test cases > -- > > Key: HAWQ-943 > URL: https://issues.apache.org/jira/browse/HAWQ-943 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > 1) Do not assume the test database is postgres. > Use HAWQ_DB which is defined in sql_util.h > 2) Use error immune options when creating a new hdfs file or directory. > e.g. mkdir -p, put -f. > Since nonexistence of those files/directories are not guaranteed. > e.g. Previous test run was terminated by ctrl+c. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-945) catalog:char/varchar test cases fail due to locale settings.
[ https://issues.apache.org/jira/browse/HAWQ-945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-945. Resolution: Fixed > catalog:char/varchar test cases fail due to locale settings. > > > Key: HAWQ-945 > URL: https://issues.apache.org/jira/browse/HAWQ-945 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-942) Need to .gitignore and make-clean some test files which are generated after running feature/test
[ https://issues.apache.org/jira/browse/HAWQ-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-942. -- > Need to .gitignore and make-clean some test files which are generated after > running feature/test > > > Key: HAWQ-942 > URL: https://issues.apache.org/jira/browse/HAWQ-942 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > After running feature tests, there will be some generated output files, like > .out files (result files after running .sql file), .out.diff files (If .out > files does not match .ans files, there will be files which include the diff > part), generated sql and and ans files, etc. > We need to clean up them in the Makefile clean/distclean target. Besides we > need to mask them in "git status" outputs, probably .out.diff is an exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-942) Need to .gitignore and make-clean some test files which are generated after running feature/test
[ https://issues.apache.org/jira/browse/HAWQ-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-942. Resolution: Duplicate > Need to .gitignore and make-clean some test files which are generated after > running feature/test > > > Key: HAWQ-942 > URL: https://issues.apache.org/jira/browse/HAWQ-942 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > After running feature tests, there will be some generated output files, like > .out files (result files after running .sql file), .out.diff files (If .out > files does not match .ans files, there will be files which include the diff > part), generated sql and and ans files, etc. > We need to clean up them in the Makefile clean/distclean target. Besides we > need to mask them in "git status" outputs, probably .out.diff is an exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-942) Need to .gitignore and make-clean some test files which are generated after running feature/test
[ https://issues.apache.org/jira/browse/HAWQ-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-942: --- Labels: (was: ToBeClosed) > Need to .gitignore and make-clean some test files which are generated after > running feature/test > > > Key: HAWQ-942 > URL: https://issues.apache.org/jira/browse/HAWQ-942 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > After running feature tests, there will be some generated output files, like > .out files (result files after running .sql file), .out.diff files (If .out > files does not match .ans files, there will be files which include the diff > part), generated sql and and ans files, etc. > We need to clean up them in the Makefile clean/distclean target. Besides we > need to mask them in "git status" outputs, probably .out.diff is an exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-1021) Need to log for some local_ssh function calls.
[ https://issues.apache.org/jira/browse/HAWQ-1021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-1021. --- > Need to log for some local_ssh function calls. > -- > > Key: HAWQ-1021 > URL: https://issues.apache.org/jira/browse/HAWQ-1021 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > HAWQ management tools calls a lot of local_ssh() function to run some > external commands. The function is defined in hawqpylib/hawqlib.py. Many > callers does not set logger so we do not know any details about the command > running process. This is annoying when users/developers fail to run some > related commands and want to know the root cause quickly. > Besides, there is two definitions of local_ssh(). Although they are not in > the same namespace, it is kind of annoying. We need to rename either one or > even both. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-930) HAWQ RM can not work
[ https://issues.apache.org/jira/browse/HAWQ-930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-930. -- > HAWQ RM can not work > > > Key: HAWQ-930 > URL: https://issues.apache.org/jira/browse/HAWQ-930 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.1.0-incubating >Reporter: Biao Wu >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > The HAWQ Version is "HAWQ version 2.0.1.0 build dev". > segment number:17 > Run `hawq restart cluster`, > the pg_log: > 2016-07-18 14:04:42.799428 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 151",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:43.799498 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 152",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:44.799569 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 153",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:45.799639 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 154",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:46.799709 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 155",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:47.799780 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 156",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:48.799850 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 157",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:49.799918 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 158",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:50.799988 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 159",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:51.800056 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 160",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:52.800126 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 161",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:53.800195 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 162",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:54.800263 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 163",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:55.800331 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 164",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:56.800399 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 165",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:57.800466 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 166",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:58.800535 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 167",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:59.800602 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 168",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:00.800669 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 169",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:01.800736 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 170",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:02.800803 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 171",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:03.800870 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 172",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:04.800938 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 173",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:05.801004 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 174",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:06.801073 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 175",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:07.801132 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 176",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:08.801224 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 177",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:09.801294 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 178",
[jira] [Resolved] (HAWQ-930) HAWQ RM can not work
[ https://issues.apache.org/jira/browse/HAWQ-930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-930. Resolution: Fixed > HAWQ RM can not work > > > Key: HAWQ-930 > URL: https://issues.apache.org/jira/browse/HAWQ-930 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.1.0-incubating >Reporter: Biao Wu >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > The HAWQ Version is "HAWQ version 2.0.1.0 build dev". > segment number:17 > Run `hawq restart cluster`, > the pg_log: > 2016-07-18 14:04:42.799428 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 151",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:43.799498 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 152",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:44.799569 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 153",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:45.799639 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 154",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:46.799709 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 155",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:47.799780 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 156",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:48.799850 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 157",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:49.799918 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 158",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:50.799988 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 159",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:51.800056 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 160",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:52.800126 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 161",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:53.800195 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 162",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:54.800263 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 163",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:55.800331 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 164",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:56.800399 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 165",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:57.800466 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 166",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:58.800535 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 167",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:59.800602 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 168",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:00.800669 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 169",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:01.800736 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 170",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:02.800803 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 171",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:03.800870 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 172",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:04.800938 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 173",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:05.801004 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 174",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:06.801073 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 175",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:07.801132 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 176",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:08.801224 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 177",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:09.801294 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0",
[jira] [Updated] (HAWQ-930) HAWQ RM can not work
[ https://issues.apache.org/jira/browse/HAWQ-930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-930: --- Labels: (was: ToBeClosed) > HAWQ RM can not work > > > Key: HAWQ-930 > URL: https://issues.apache.org/jira/browse/HAWQ-930 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Affects Versions: 2.0.1.0-incubating >Reporter: Biao Wu >Assignee: Lei Chang > Fix For: 2.1.0.0-incubating > > > The HAWQ Version is "HAWQ version 2.0.1.0 build dev". > segment number:17 > Run `hawq restart cluster`, > the pg_log: > 2016-07-18 14:04:42.799428 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 151",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:43.799498 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 152",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:44.799569 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 153",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:45.799639 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 154",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:46.799709 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 155",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:47.799780 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 156",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:48.799850 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 157",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:49.799918 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 158",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:50.799988 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 159",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:51.800056 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 160",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:52.800126 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 161",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:53.800195 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 162",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:54.800263 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 163",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:55.800331 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 164",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:56.800399 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 165",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:57.800466 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 166",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:58.800535 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 167",,,0,,"resourcemanager.c",421, > 2016-07-18 14:04:59.800602 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 168",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:00.800669 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 169",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:01.800736 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 170",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:02.800803 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 171",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:03.800870 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 172",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:04.800938 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 173",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:05.801004 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 174",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:06.801073 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 175",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:07.801132 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 176",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:08.801224 > CST,,,p136927,th-17368286400,,,seg-1,"LOG","0","Wait for HAWQ > RM 177",,,0,,"resourcemanager.c",421, > 2016-07-18 14:05:09.801294 > CST,,,p136927,th-17368286400,,,seg-1,"LOG",
[jira] [Resolved] (HAWQ-1021) Need to log for some local_ssh function calls.
[ https://issues.apache.org/jira/browse/HAWQ-1021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-1021. - Resolution: Fixed > Need to log for some local_ssh function calls. > -- > > Key: HAWQ-1021 > URL: https://issues.apache.org/jira/browse/HAWQ-1021 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > HAWQ management tools calls a lot of local_ssh() function to run some > external commands. The function is defined in hawqpylib/hawqlib.py. Many > callers does not set logger so we do not know any details about the command > running process. This is annoying when users/developers fail to run some > related commands and want to know the root cause quickly. > Besides, there is two definitions of local_ssh(). Although they are not in > the same namespace, it is kind of annoying. We need to rename either one or > even both. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1020) Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and TestCommonLib.TestYanConfig run in concourse
[ https://issues.apache.org/jira/browse/HAWQ-1020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-1020: Labels: (was: ToBeClosed) > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse > --- > > Key: HAWQ-1020 > URL: https://issues.apache.org/jira/browse/HAWQ-1020 > Project: Apache HAWQ > Issue Type: Bug > Components: Tests >Affects Versions: 2.0.1.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-1019) clarify database application interfaces discussion
[ https://issues.apache.org/jira/browse/HAWQ-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-1019. - Resolution: Fixed > clarify database application interfaces discussion > -- > > Key: HAWQ-1019 > URL: https://issues.apache.org/jira/browse/HAWQ-1019 > Project: Apache HAWQ > Issue Type: Improvement > Components: Documentation >Reporter: Lisa Owen >Assignee: Lei Chang >Priority: Minor > Fix For: 2.1.0.0-incubating > > > discussion of drivers for database application interfaces needs to be > clarified. > relevant incubator-hawq-docs file: > clientaccess/g-database-application-interfaces.html.md.erb -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-1019) clarify database application interfaces discussion
[ https://issues.apache.org/jira/browse/HAWQ-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-1019. --- > clarify database application interfaces discussion > -- > > Key: HAWQ-1019 > URL: https://issues.apache.org/jira/browse/HAWQ-1019 > Project: Apache HAWQ > Issue Type: Improvement > Components: Documentation >Reporter: Lisa Owen >Assignee: Lei Chang >Priority: Minor > Fix For: 2.1.0.0-incubating > > > discussion of drivers for database application interfaces needs to be > clarified. > relevant incubator-hawq-docs file: > clientaccess/g-database-application-interfaces.html.md.erb -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1021) Need to log for some local_ssh function calls.
[ https://issues.apache.org/jira/browse/HAWQ-1021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino updated HAWQ-1021: Labels: (was: ToBeClosed) > Need to log for some local_ssh function calls. > -- > > Key: HAWQ-1021 > URL: https://issues.apache.org/jira/browse/HAWQ-1021 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Paul Guo > Fix For: 2.1.0.0-incubating > > > HAWQ management tools calls a lot of local_ssh() function to run some > external commands. The function is defined in hawqpylib/hawqlib.py. Many > callers does not set logger so we do not know any details about the command > running process. This is annoying when users/developers fail to run some > related commands and want to know the root cause quickly. > Besides, there is two definitions of local_ssh(). Although they are not in > the same namespace, it is kind of annoying. We need to rename either one or > even both. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-1020) Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and TestCommonLib.TestYanConfig run in concourse
[ https://issues.apache.org/jira/browse/HAWQ-1020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino resolved HAWQ-1020. - Resolution: Fixed > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse > --- > > Key: HAWQ-1020 > URL: https://issues.apache.org/jira/browse/HAWQ-1020 > Project: Apache HAWQ > Issue Type: Bug > Components: Tests >Affects Versions: 2.0.1.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-1020) Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and TestCommonLib.TestYanConfig run in concourse
[ https://issues.apache.org/jira/browse/HAWQ-1020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-1020. --- > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse > --- > > Key: HAWQ-1020 > URL: https://issues.apache.org/jira/browse/HAWQ-1020 > Project: Apache HAWQ > Issue Type: Bug > Components: Tests >Affects Versions: 2.0.1.0-incubating >Reporter: Chunling Wang >Assignee: Chunling Wang > Fix For: 2.1.0.0-incubating > > > Fix bugs to let feature tests TestCommonLib.TestHdfsConfig and > TestCommonLib.TestYanConfig run in concourse -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-999) Log_error when file count is not in proportion to bucket number of hash table.
[ https://issues.apache.org/jira/browse/HAWQ-999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ed Espino closed HAWQ-999. -- > Log_error when file count is not in proportion to bucket number of hash table. > -- > > Key: HAWQ-999 > URL: https://issues.apache.org/jira/browse/HAWQ-999 > Project: Apache HAWQ > Issue Type: Improvement > Components: Core >Reporter: Hubert Zhang >Assignee: Hubert Zhang > Fix For: 2.1.0.0-incubating > > > By definition, file count of a hash table should be equal to or a multiple of > the bucket number of the table. So if mismatch happens, we should not treat > it as hash table in data locality algorithm. > The default behaviour should LOG_ERROR and tell the user "file count is not > in proportion to bucket number for hash table with oid=X. Some data maybe > lost, if you still want to continue the query, set GUC > assign_randomly_for_mismatched_hash_table to true and try again." > If GUC assign_randomly_for_mismatched_hash_table is on, the behaviour changed > to treat the hash table as random table in data locality algorithm. > -- This message was sent by Atlassian JIRA (v6.3.4#6332)