[jira] [Resolved] (HAWQ-1131) Fix error message difference between Orca and Planner

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-1131. - Resolution: Fixed Fix Version/s: 2.0.1.0-incubating > Fix error message difference between

[jira] [Resolved] (HAWQ-934) Populate canSetTag of PlannedStmt from Query object

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-934. Resolution: Fixed > Populate canSetTag of PlannedStmt from Query object >

[jira] [Resolved] (HAWQ-938) Remove ivy.xml in gpopt and read orca version from header file

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-938. Resolution: Fixed > Remove ivy.xml in gpopt and read orca version from header file >

[jira] [Resolved] (HAWQ-983) Minirepro generate wrong dependency order of objects and miss CTE relations

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-983. Resolution: Fixed > Minirepro generate wrong dependency order of objects and miss CTE relations >

[jira] [Resolved] (HAWQ-929) Fix plan generated by query window function and no partition by clause

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-929. Resolution: Resolved > Fix plan generated by query window function and no partition by clause >

[jira] [Resolved] (HAWQ-860) Optimizer generates wrong plan when correlated subquery contains set-returning functions

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-860. Resolution: Fixed > Optimizer generates wrong plan when correlated subquery contains > set-returning

[jira] [Resolved] (HAWQ-1122) Bump ORCA version to 1.674

2016-12-19 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-1122. - Resolution: Resolved Fix Version/s: 2.0.1.0-incubating > Bump ORCA version to 1.674 >

[jira] [Created] (HAWQ-1137) Remove banned api mechanism in Orca

2016-11-02 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-1137: --- Summary: Remove banned api mechanism in Orca Key: HAWQ-1137 URL: https://issues.apache.org/jira/browse/HAWQ-1137 Project: Apache HAWQ Issue Type: Improvement

[jira] [Assigned] (HAWQ-1137) Remove banned api mechanism in Orca

2016-11-02 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned HAWQ-1137: --- Assignee: Haisheng Yuan (was: Lei Chang) > Remove banned api mechanism in Orca >

[jira] [Created] (HAWQ-1136) Disable .psqlrc in minirepro

2016-11-01 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-1136: --- Summary: Disable .psqlrc in minirepro Key: HAWQ-1136 URL: https://issues.apache.org/jira/browse/HAWQ-1136 Project: Apache HAWQ Issue Type: Bug

[jira] [Assigned] (HAWQ-1136) Disable .psqlrc in minirepro

2016-11-01 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned HAWQ-1136: --- Assignee: Haisheng Yuan (was: Lei Chang) > Disable .psqlrc in minirepro >

[jira] [Assigned] (HAWQ-1131) Fix error message difference between Orca and Planner

2016-11-01 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned HAWQ-1131: --- Assignee: Haisheng Yuan (was: Lei Chang) > Fix error message difference between Orca and

[jira] [Updated] (HAWQ-1131) Fix error message difference between Orca and Planner

2016-11-01 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-1131: Summary: Fix error message difference between Orca and Planner (was: Fix error message between Orca

[jira] [Created] (HAWQ-1131) Fix error message between Orca and Planner

2016-11-01 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-1131: --- Summary: Fix error message between Orca and Planner Key: HAWQ-1131 URL: https://issues.apache.org/jira/browse/HAWQ-1131 Project: Apache HAWQ Issue Type: Bug

[jira] [Assigned] (HAWQ-1093) Bump Orca version and enable Orca related exception propagation

2016-10-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned HAWQ-1093: --- Assignee: Haisheng Yuan (was: Lei Chang) > Bump Orca version and enable Orca related

[jira] [Created] (HAWQ-983) Minirepro generate wrong dependency order of objects and miss CTE relations

2016-08-05 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-983: -- Summary: Minirepro generate wrong dependency order of objects and miss CTE relations Key: HAWQ-983 URL: https://issues.apache.org/jira/browse/HAWQ-983 Project: Apache

[jira] [Assigned] (HAWQ-938) Remove ivy.xml in gpopt and read orca version from header file

2016-07-20 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned HAWQ-938: -- Assignee: Haisheng Yuan (was: Venkatesh) > Remove ivy.xml in gpopt and read orca version from

[jira] [Updated] (HAWQ-938) Remove ivy.xml in gpopt and read orca version from header file

2016-07-18 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-938: --- Description: Currently, if we want to upgrade orca or gpos, we need change the orca SHA as well as the

[jira] [Created] (HAWQ-938) Remove ivy.xml in gpopt and read orca version from header file

2016-07-18 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-938: -- Summary: Remove ivy.xml in gpopt and read orca version from header file Key: HAWQ-938 URL: https://issues.apache.org/jira/browse/HAWQ-938 Project: Apache HAWQ

[jira] [Created] (HAWQ-936) Add GUC for array expansion in ORCA optimizer

2016-07-18 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-936: -- Summary: Add GUC for array expansion in ORCA optimizer Key: HAWQ-936 URL: https://issues.apache.org/jira/browse/HAWQ-936 Project: Apache HAWQ Issue Type: New

[jira] [Created] (HAWQ-934) Populate canSetTag of PlannedStmt from Query object

2016-07-18 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-934: -- Summary: Populate canSetTag of PlannedStmt from Query object Key: HAWQ-934 URL: https://issues.apache.org/jira/browse/HAWQ-934 Project: Apache HAWQ Issue Type:

[jira] [Resolved] (HAWQ-763) Remove traceflag that allows ORCA to run in multiple threads

2016-06-22 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-763. Resolution: Fixed > Remove traceflag that allows ORCA to run in multiple threads >

[jira] [Updated] (HAWQ-764) Remove CTranslatorPlStmtToDXL Deadcode

2016-05-28 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-764: --- Component/s: Optimizer > Remove CTranslatorPlStmtToDXL Deadcode >

[jira] [Created] (HAWQ-765) Remove CTranslatorDXLToQuery Deadcode

2016-05-28 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-765: -- Summary: Remove CTranslatorDXLToQuery Deadcode Key: HAWQ-765 URL: https://issues.apache.org/jira/browse/HAWQ-765 Project: Apache HAWQ Issue Type: Improvement

[jira] [Created] (HAWQ-764) Remove CTranslatorPlStmtToDXL Deadcode

2016-05-28 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-764: -- Summary: Remove CTranslatorPlStmtToDXL Deadcode Key: HAWQ-764 URL: https://issues.apache.org/jira/browse/HAWQ-764 Project: Apache HAWQ Issue Type: Improvement

[jira] [Created] (HAWQ-763) Remove traceflag that allows ORCA to run in multiple threads

2016-05-28 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-763: -- Summary: Remove traceflag that allows ORCA to run in multiple threads Key: HAWQ-763 URL: https://issues.apache.org/jira/browse/HAWQ-763 Project: Apache HAWQ

[jira] [Updated] (HAWQ-670) Error when changing the table distribution policy from random to hash distribution

2016-04-13 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-670: --- Description: If the current segments number is 8 and I run these queries, {code:sql} create table t2

[jira] [Resolved] (HAWQ-404) Add sort during INSERT of append only row oriented partition tables

2016-04-13 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-404. Resolution: Fixed > Add sort during INSERT of append only row oriented partition tables >

[jira] [Created] (HAWQ-646) Bump up optimizer version number

2016-04-08 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-646: -- Summary: Bump up optimizer version number Key: HAWQ-646 URL: https://issues.apache.org/jira/browse/HAWQ-646 Project: Apache HAWQ Issue Type: Improvement

[jira] [Resolved] (HAWQ-455) Disable creating partition tables with non uniform bucket schema

2016-03-14 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-455. Resolution: Fixed Resolved in commit:

[jira] [Created] (HAWQ-455) Disable creating partition tables with non uniform bucket schema

2016-02-24 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-455: -- Summary: Disable creating partition tables with non uniform bucket schema Key: HAWQ-455 URL: https://issues.apache.org/jira/browse/HAWQ-455 Project: Apache HAWQ

[jira] [Created] (HAWQ-404) Add sort during INSERT of append only row oriented partition tables

2016-02-08 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-404: -- Summary: Add sort during INSERT of append only row oriented partition tables Key: HAWQ-404 URL: https://issues.apache.org/jira/browse/HAWQ-404 Project: Apache HAWQ

[jira] [Resolved] (HAWQ-161) Port GPDB planner fixes to HAWQ

2016-01-20 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-161. Resolution: Resolved > Port GPDB planner fixes to HAWQ > --- > >

[jira] [Commented] (HAWQ-324) Add minirepro to let user dump minimal set of DDL and statistics for a given query

2016-01-20 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15109116#comment-15109116 ] Haisheng Yuan commented on HAWQ-324: It was resolved. I will close it. > Add minirepro to let user dump

[jira] [Resolved] (HAWQ-123) Add 'Partition by' description in psql

2016-01-06 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved HAWQ-123. Resolution: Resolved > Add 'Partition by' description in psql >

[jira] [Created] (HAWQ-324) Add minirepro to let user dump minimal set of DDL and statistics for a given query

2016-01-06 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-324: -- Summary: Add minirepro to let user dump minimal set of DDL and statistics for a given query Key: HAWQ-324 URL: https://issues.apache.org/jira/browse/HAWQ-324 Project:

[jira] [Updated] (HAWQ-161) Port GPDB planner fixes to HAWQ

2015-11-13 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-161: --- Priority: Minor (was: Major) > Port GPDB planner fixes to HAWQ > --- > >

[jira] [Created] (HAWQ-161) Port GPDB planner fixes to HAWQ

2015-11-13 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-161: -- Summary: Port GPDB planner fixes to HAWQ Key: HAWQ-161 URL: https://issues.apache.org/jira/browse/HAWQ-161 Project: Apache HAWQ Issue Type: Improvement

[jira] [Updated] (HAWQ-123) Add 'Partition by' description in psql

2015-11-10 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-123: --- Summary: Add 'Partition by' description in psql (was: Data Engineer can see partition key in psql) >

[jira] [Updated] (HAWQ-123) Data Engineer can see partition key in psql

2015-11-04 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated HAWQ-123: --- Priority: Minor (was: Major) > Data Engineer can see partition key in psql >