[jira] [Commented] (HAWQ-1122) Bump ORCA version to 1.674
[
https://issues.apache.org/jira/browse/HAWQ-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15610200#comment-15610200
]
xin zhang commented on HAWQ-1122:
-
Feature-test result:
```
{code}
[ FAILED ] 6 tests, listed below:
[ FAILED ] TestExternalTable.TestExternalTableAll
[ FAILED ] TestAlterTable.TestAlterTableAOColumnNOTNULL
[ FAILED ] TestGuc.per_db_guc_with_space
[ FAILED ] TestType.char
[ FAILED ] TestType.varchar
[ FAILED ] TestQueryInsert.TestInsertWithDefaultNeg
6 FAILED TESTS
YOU HAVE 13 DISABLED TESTS
{code}
```
ICG Failure
```
{code}
(using postmaster on Unix socket, default port)
== dropping database "regression" ==
NOTICE: database "regression" does not exist, skipping
DROP DATABASE
== creating database "regression" ==
CREATE DATABASE
ALTER DATABASE
== checking optimizer status ==
Optimizer enabled. Using optimizer answer files whenever possible
== running regression test queries==
test errortbl ... ok (7.75 sec)
test goh_create_type_composite ... ok (3.24 sec)
test goh_toast... ok (1.06 sec)
test goh_database ... ok (6.06 sec)
test goh_gp_dist_random ... ok (0.30 sec)
test create_table_test... ok (0.25 sec)
test copy ... ok (42.25 sec)
test information_schema ... ok (0.34 sec)
test transactions ... ok (28.65 sec)
test temp ... ok (3.10 sec)
test rowtypes ... ok (1.96 sec)
test caqlinmem... ok (2.45 sec)
test hcatalog_lookup ... FAILED (3.63 sec)
test json_load... ok (0.92 sec)
test validator_function ... ok (0.18 sec)
===
1 of 15 tests failed.
===
hcatalog_lookup failed, but lack of context for what are the dependencies
missing:
1 *** ./expected/hcatalog_lookup.out 2016-10-26 15:53:37.0 -0700
2 --- ./results/hcatalog_lookup.out 2016-10-26 15:53:37.0 -0700
3 ***
4 *** 3,19
5 -- test hcatalog lookup
6 -- --
7 SELECT * FROM pxf_get_item_fields('Hive', '*');
8 ! path | itemname | fieldname | fieldtype | sourcefieldtype
9 ! --+--+---+---+-
10 ! (0 rows)
11 !
12 \d hcatalog.*.*
13 SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
14 ! path | itemname | fieldname | fieldtype | sourcefieldtype
15 ! --+--+---+---+-
16 ! (0 rows)
17 !
18 \d hcatalog.*abc*.*abc*
19 \d hcatalog
20 Invalid pattern provided.
21 \d hcatalog.
22 --- 3,15
23 -- test hcatalog lookup
24 -- --
25 SELECT * FROM pxf_get_item_fields('Hive', '*');
26 ! ERROR: remote component error (0): Failed to connect to ::1 port 51200:
Connection refused
27\d hcatalog.*.*
28 + ERROR: remote component error (0): Failed to connect to ::1 port 51200:
Connection refused
29 SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
30 ! ERROR: remote component error (0): Failed to connect to ::1 port 51200:
Connection refused
31 \d hcatalog.*abc*.*abc*
32 + ERROR: remote component error (0): Failed to connect to ::1 port 51200:
Connection refused
33 \d hcatalog
34 Invalid pattern provided.
35 \d hcatalog.
36
{code}
```
> Bump ORCA version to 1.674
> --
>
> Key: HAWQ-1122
> URL: https://issues.apache.org/jira/browse/HAWQ-1122
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Optimizer
>Reporter: xin zhang
>Assignee: Lei Chang
>
> This improvement will port related changes under `src/backend/gpopt` from
> GPDB OSS to use GPORCA version v1.674.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (HAWQ-1122) Bump ORCA version to 1.674
xin zhang created HAWQ-1122: --- Summary: Bump ORCA version to 1.674 Key: HAWQ-1122 URL: https://issues.apache.org/jira/browse/HAWQ-1122 Project: Apache HAWQ Issue Type: Improvement Components: Optimizer Reporter: xin zhang Assignee: Lei Chang This improvement will port related changes under `src/backend/gpopt` from GPDB OSS to use GPORCA version v1.674. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-708) Consume latest GPORCA features up to version 1.630
xin zhang created HAWQ-708: -- Summary: Consume latest GPORCA features up to version 1.630 Key: HAWQ-708 URL: https://issues.apache.org/jira/browse/HAWQ-708 Project: Apache HAWQ Issue Type: Improvement Components: Optimizer Reporter: xin zhang Assignee: Amr El-Helw There are additional GPORCA features benefiting the HAWQ community, and this ticket is to bump the GPORCA from version 1.627 to 1.630. Here is list of new features in GPORCA: -- 1.628 and rename EatMalloc to EatTracker Better memory tracking. -- 1.629 to include new GUC for Join Exploration New GUC optimizer_join_arity_for_associativity_commutativity is added to control Join exploration, hence speed up optimization time [#116333899] For example, `set optimizer_join_arity_for_associativity_commutativity=x` will hint at the optimizer to stop exploring join associativity and join commutativity transformations when an n-ary join operator has more than x children during optimization, pruning quite a bit of the search space. -- 1.630 to fix CTE Predicate pushdown This fix will prevent predicate pushdown with volatile function like random(), which caused wrong result if predicates were duplicated. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (HAWQ-358) Installcheck good failures in hawq-dev environment
[
https://issues.apache.org/jira/browse/HAWQ-358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15212132#comment-15212132
]
xin zhang edited comment on HAWQ-358 at 3/25/16 6:12 PM:
-
At this moment, only two tests failed on OSX (not on Linux)
{code}
test exttab1 ... FAILED (11.18 sec)
test hcatalog_lookup ... FAILED (0.71 sec) (test process exited with
unexpected exit code 2, but was expected exit code 0)
{code}
{code}
===
2 of 56 tests failed.
===
{code}
The regression.diffs is:
{code}
*** ./expected/exttab1_optimizer.out2016-03-25 10:23:17.0 -0700
--- ./results/exttab1.out 2016-03-25 10:23:17.0 -0700
***
*** 610,617
--drop foreign table ext; -- should fail (wrong object)
--drop external table ext;
--
! r_name
! MIDDLE EAST
--
--
--
--- 599,606
--drop foreign table ext; -- should fail (wrong object)
--drop external table ext;
--
! x
! Okay, gpfdist version "2.0.0.0_beta build dev" is running on localhost:7070.
--
--
--
***
*** 673,680
-- in between runs, so we don't check for count(*), and instead check for
distinct.
-- negative
-- positive
! ---
--
ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once
ERROR: the ON segment syntax for writableexternal tables is
deprecated
ERROR: the file protocol for external tables is deprecated
--- 662,670
-- in between runs, so we don't check for count(*), and instead check for
distinct.
-- negative
-- positive
! -- start_ignore
--
+ --
ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once
ERROR: the ON segment syntax for writable external tables is deprecated
ERROR: the file protocol for external tables is deprecated
***
*** 690,720
create writable external table wet_pos3(like wet_pos2)
location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b);
create writable external table wet_region(like reg_region)
location('gpfdist://localhost:7070/wet_region.out') format 'text';
create writable external web table wet_pos5(a text, b text) execute 'some
command' on segment 0 format 'text';
select * from wet_pos1;
(1 row)
! GP_IGNORE:-- start_ignore
! GP_IGNORE:select * from gpfdist_status;
! GP_IGNORE: x
!
GP_IGNORE:--
! GP_IGNORE: Okay, gpfdist version "1.3.0.0 build dev" is running on
localhost:7070.
! GP_IGNORE:(1 row)
! GP_IGNORE:
! GP_IGNORE:select * from gpfdist_stop;
! GP_IGNORE: x
! GP_IGNORE:-
! GP_IGNORE: stopping...
! GP_IGNORE:(1 row)
! GP_IGNORE:
! GP_IGNORE:select * from gpfdist_status;
! GP_IGNORE: x
! GP_IGNORE:--
! GP_IGNORE: Error: gpfdist is not running (reason: socket error)
! GP_IGNORE: Exit: 1
! GP_IGNORE:
! GP_IGNORE:(3 rows)
! GP_IGNORE:
! GP_IGNORE:-- end_ignore
--
-- get an error for missing gpfdist
--
--- 680,704
create writable external table wet_pos3(like wet_pos2)
location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b);
create writable external table wet_region(like reg_region)
location('gpfdist://localhost:7070/wet_region.out') format 'text';
create writable external web table wet_pos5(a text, b text) execute 'some
command' on segment 0 format 'text';
+ select * from gpfdist_status;
select * from wet_pos1;
(1 row)
! select * from gpfdist_stop;
! x
! -
! stopping...
! (1 row)
!
! select * from gpfdist_status;
! x
! --
!
! Error: gpfdist is not running (reason: socket error)
! Exit: 1
! (3 rows)
!
! -- end_ignore
--
-- get an error for missing gpfdist
--
==
*** ./expected/hcatalog_lookup.out 2016-03-25 10:23:55.0 -0700
--- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.0 -0700
***
*** 13,22
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! path | itemname |
[jira] [Comment Edited] (HAWQ-358) Installcheck good failures in hawq-dev environment
[
https://issues.apache.org/jira/browse/HAWQ-358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15212132#comment-15212132
]
xin zhang edited comment on HAWQ-358 at 3/25/16 5:34 PM:
-
At this moment, only two tests failed:
{code}
test exttab1 ... FAILED (11.18 sec)
test hcatalog_lookup ... FAILED (0.71 sec) (test process exited with
unexpected exit code 2, but was expected exit code 0)
{code}
{code}
===
2 of 56 tests failed.
===
{code}
The regression.diffs is:
{code}
*** ./expected/exttab1_optimizer.out2016-03-25 10:23:17.0 -0700
--- ./results/exttab1.out 2016-03-25 10:23:17.0 -0700
***
*** 610,617
--drop foreign table ext; -- should fail (wrong object)
--drop external table ext;
--
! r_name
! MIDDLE EAST
--
--
--
--- 599,606
--drop foreign table ext; -- should fail (wrong object)
--drop external table ext;
--
! x
! Okay, gpfdist version "2.0.0.0_beta build dev" is running on localhost:7070.
--
--
--
***
*** 673,680
-- in between runs, so we don't check for count(*), and instead check for
distinct.
-- negative
-- positive
! ---
--
ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once
ERROR: the ON segment syntax for writableexternal tables is
deprecated
ERROR: the file protocol for external tables is deprecated
--- 662,670
-- in between runs, so we don't check for count(*), and instead check for
distinct.
-- negative
-- positive
! -- start_ignore
--
+ --
ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once
ERROR: the ON segment syntax for writable external tables is deprecated
ERROR: the file protocol for external tables is deprecated
***
*** 690,720
create writable external table wet_pos3(like wet_pos2)
location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b);
create writable external table wet_region(like reg_region)
location('gpfdist://localhost:7070/wet_region.out') format 'text';
create writable external web table wet_pos5(a text, b text) execute 'some
command' on segment 0 format 'text';
select * from wet_pos1;
(1 row)
! GP_IGNORE:-- start_ignore
! GP_IGNORE:select * from gpfdist_status;
! GP_IGNORE: x
!
GP_IGNORE:--
! GP_IGNORE: Okay, gpfdist version "1.3.0.0 build dev" is running on
localhost:7070.
! GP_IGNORE:(1 row)
! GP_IGNORE:
! GP_IGNORE:select * from gpfdist_stop;
! GP_IGNORE: x
! GP_IGNORE:-
! GP_IGNORE: stopping...
! GP_IGNORE:(1 row)
! GP_IGNORE:
! GP_IGNORE:select * from gpfdist_status;
! GP_IGNORE: x
! GP_IGNORE:--
! GP_IGNORE: Error: gpfdist is not running (reason: socket error)
! GP_IGNORE: Exit: 1
! GP_IGNORE:
! GP_IGNORE:(3 rows)
! GP_IGNORE:
! GP_IGNORE:-- end_ignore
--
-- get an error for missing gpfdist
--
--- 680,704
create writable external table wet_pos3(like wet_pos2)
location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b);
create writable external table wet_region(like reg_region)
location('gpfdist://localhost:7070/wet_region.out') format 'text';
create writable external web table wet_pos5(a text, b text) execute 'some
command' on segment 0 format 'text';
+ select * from gpfdist_status;
select * from wet_pos1;
(1 row)
! select * from gpfdist_stop;
! x
! -
! stopping...
! (1 row)
!
! select * from gpfdist_status;
! x
! --
!
! Error: gpfdist is not running (reason: socket error)
! Exit: 1
! (3 rows)
!
! -- end_ignore
--
-- get an error for missing gpfdist
--
==
*** ./expected/hcatalog_lookup.out 2016-03-25 10:23:55.0 -0700
--- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.0 -0700
***
*** 13,22
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! path | itemname | fieldname | fieldtype
[jira] [Resolved] (HAWQ-502) Support --enable-orca in autoconf
[ https://issues.apache.org/jira/browse/HAWQ-502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang resolved HAWQ-502. Resolution: Fixed Fix Version/s: 2.0.0-beta-incubating This is resolved. The commit is in the git a48600a125eed2a3da00133d6f5f8dad22d4a6a4. > Support --enable-orca in autoconf > - > > Key: HAWQ-502 > URL: https://issues.apache.org/jira/browse/HAWQ-502 > Project: Apache HAWQ > Issue Type: Improvement > Components: Optimizer >Reporter: Jacob Max Frank >Assignee: xin zhang > Fix For: 2.0.0-beta-incubating > > > Autoconf and Makefile changes are needed to build with HAWQ with GPORCA. We > spent some time hacking on this and will file a PR soon. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-502) Support --enable-orca in autoconf
[ https://issues.apache.org/jira/browse/HAWQ-502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang reassigned HAWQ-502: -- Assignee: xin zhang (was: Amr El-Helw) > Support --enable-orca in autoconf > - > > Key: HAWQ-502 > URL: https://issues.apache.org/jira/browse/HAWQ-502 > Project: Apache HAWQ > Issue Type: Improvement > Components: Optimizer >Reporter: Jacob Max Frank >Assignee: xin zhang > > Autoconf and Makefile changes are needed to build with HAWQ with GPORCA. We > spent some time hacking on this and will file a PR soon. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-513) initdb.c failed on OSX 10.11.3 due to fgets error
xin zhang created HAWQ-513:
--
Summary: initdb.c failed on OSX 10.11.3 due to fgets error
Key: HAWQ-513
URL: https://issues.apache.org/jira/browse/HAWQ-513
Project: Apache HAWQ
Issue Type: Bug
Components: Unknown
Reporter: xin zhang
Assignee: Lei Chang
we hit following strange issue on OSX 10.11.3:
The error message in the initdb is:
{code}
20160301:00:00:26:075823 hawq_init:This-MacBook-Pro:vagrant-[INFO]:-Start to
init master node: 'localhost'
sh: line 1: 76106 Trace/BPT trap: 5 "/usr/local/hawq/bin/postgres" -V 2>
/dev/null
fgets failure: Undefined error: 0
The program "postgres" is needed by initdb but was either not found in the same
directory as "/usr/local/hawq/bin/initdb" or failed unexpectedly.
Check your installation; "postgres -V" may have more information.
Master postgres initdb failed
{code}
We suspect the issue due to the newer version of the libSystem.B.dylib on OSX
10.11.3.
Here is the details of the dependencies of `postgres` and `initdb`:
10.10.5, postgres can start, and initdb succeed:
{code}
[bin: xzhang{master}]$ otool -L postgres
postgres:
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version
120.0.0)
libhdfs3.1.dylib (compatibility version 1.0.0, current version 2.2.30)
/usr/lib/libxml2.2.dylib (compatibility version 10.0.0, current version
10.9.0)
libyarn.1.dylib (compatibility version 1.0.0, current version 0.1.13)
/usr/local/opt/json-c/lib/libjson-c.2.dylib (compatibility version 3.0.0,
current version 3.1.0)
/usr/local/opt/snappy/lib/libsnappy.1.dylib (compatibility version 5.0.0,
current version 5.0.0)
/usr/lib/libbz2.1.0.dylib (compatibility version 1.0.0, current version
1.0.5)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1213.0.0)
/usr/lib/libcurl.4.dylib (compatibility version 7.0.0, current version
8.0.0)
/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
(compatibility version 5.0.0, current version 6.0.0)
libdxltranslators.dylib (compatibility version 0.0.0, current version 0.0.0)
/usr/local/opt/thrift/lib/libthrift-0.9.3.dylib (compatibility version
0.0.0, current version 0.0.0)
This-MacBook-Pro:bin vagrant$ otool -L initdb
initdb:
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1226.10.1)
{code}
10.11.3, postgres can start, but initdb failed:
{code}
This-MacBook-Pro:bin vagrant$ otool -L postgres
postgres:
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version
120.1.0)
libhdfs3.1.dylib (compatibility version 1.0.0, current version 2.2.30)
/usr/lib/libxml2.2.dylib (compatibility version 10.0.0, current version
10.9.0)
libyarn.1.dylib (compatibility version 1.0.0, current version 0.1.13)
/usr/local/opt/json-c/lib/libjson-c.2.dylib (compatibility version 3.0.0,
current version 3.1.0)
/usr/local/opt/snappy/lib/libsnappy.1.dylib (compatibility version 5.0.0,
current version 5.0.0)
/usr/lib/libbz2.1.0.dylib (compatibility version 1.0.0, current version
1.0.5)
/usr/lib/libssl.0.9.8.dylib (compatibility version 0.9.8, current version
0.9.8)
/usr/lib/libcrypto.0.9.8.dylib (compatibility version 0.9.8, current
version 0.9.8)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1226.10.1)
/usr/lib/libcurl.4.dylib (compatibility version 7.0.0, current version
8.0.0)
/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
(compatibility version 5.0.0, current version 6.0.0)
libdxltranslators.dylib (compatibility version 0.0.0, current version 0.0.0)
/usr/local/opt/thrift/lib/libthrift-0.9.3.dylib (compatibility version
0.0.0, current version 0.0.0)
[bin: xzhang{master}]$ otool -L initdb
initdb:
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1213.0.0)
{code}
In this case, there is a difference between the two OS regarding to the
libSystem.B.dylib.
Question is how to fix it? For example, how to change the libSystem.B.dylib to
an older version? or, how to fix the postgres or initdb so that they works on
the new OSX 10.11.3?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HAWQ-490) Add version and compatibility detection for HAWQ + GPORCA
[
https://issues.apache.org/jira/browse/HAWQ-490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15183793#comment-15183793
]
xin zhang commented on HAWQ-490:
+1. There has to be a standard way to figure out dependencies, and some best
practice in the OSS community.
At this moment, I see following building blocks:
. Add tag marking for the release of dependent repos, e.g., GPORCA, GPOS, and
GPXERCES in our case.
. Figure out OSS best practice of version dependency in package manager
(https://en.wikipedia.org/wiki/Package_manager). At least we need a popular
Linux flavor (apt-get) and an OSX one (brew) for deployment and development.
. Automate the testing (e.g. Travis) with dependencies using those package
managers.
> Add version and compatibility detection for HAWQ + GPORCA
> -
>
> Key: HAWQ-490
> URL: https://issues.apache.org/jira/browse/HAWQ-490
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Build
>Reporter: Jacob Max Frank
>Assignee: Lei Chang
>Priority: Minor
>
> Autoconf should be able to detect GPORCA version information and check for
> compatibility with the version of HAWQ being built. Additionally, running
> {{select gp_opt_version();}} on HAWQ compiled with GPORCA should output
> correct version information for its components (GPOPT, GPOS, and GPXerces).
> [~rvs] suggested using {{pkgutil}}. Alternate potential strategies include
> using a {{git submodule}} or pulling values from a {{version.h}} file.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (HAWQ-479) Upgrade JSON-C dependency from 0.6 to 0.12
xin zhang created HAWQ-479: -- Summary: Upgrade JSON-C dependency from 0.6 to 0.12 Key: HAWQ-479 URL: https://issues.apache.org/jira/browse/HAWQ-479 Project: Apache HAWQ Issue Type: Improvement Components: Build Reporter: xin zhang Assignee: Lei Chang In order to support building HAWQ with GPORCA, we have to bump the JSON-C version from 0.6 to 0.12. This requires changing the path of JSON from *json/json.h* to *json-c/json.h*. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-130) Analyzedb utility failing when a table was created using quotes having upper case letters
[ https://issues.apache.org/jira/browse/HAWQ-130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang resolved HAWQ-130. Resolution: Fixed > Analyzedb utility failing when a table was created using quotes having upper > case letters > - > > Key: HAWQ-130 > URL: https://issues.apache.org/jira/browse/HAWQ-130 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > > The analyzedb utility returned an error if the utility encountered a table or > schema name that contained uppercase characters (the name was enclosed in > quotes and contained upper case characters). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-221) Cleanup unused files related to optimizer
[ https://issues.apache.org/jira/browse/HAWQ-221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang closed HAWQ-221. -- https://github.com/apache/incubator-hawq/pull/159 > Cleanup unused files related to optimizer > - > > Key: HAWQ-221 > URL: https://issues.apache.org/jira/browse/HAWQ-221 > Project: Apache HAWQ > Issue Type: Task > Components: Optimizer >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > > There are three files originally used for running gpopt as a standalone > process. These code are #ifdef out and were cleaned up on the gpdb side. I'm > cleaning them up for Hawq as well since there's no plan of running gpopt as a > standalone process in near future. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-130) Analyzedb utility failing when a table was created using quotes having upper case letters
[ https://issues.apache.org/jira/browse/HAWQ-130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang closed HAWQ-130. -- Already in PR. https://github.com/apache/incubator-hawq/pull/104 > Analyzedb utility failing when a table was created using quotes having upper > case letters > - > > Key: HAWQ-130 > URL: https://issues.apache.org/jira/browse/HAWQ-130 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > > The analyzedb utility returned an error if the utility encountered a table or > schema name that contained uppercase characters (the name was enclosed in > quotes and contained upper case characters). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-148) Bump up optimizer and gpos version
[ https://issues.apache.org/jira/browse/HAWQ-148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang closed HAWQ-148. -- PR finished https://github.com/apache/incubator-hawq/pull/159 > Bump up optimizer and gpos version > -- > > Key: HAWQ-148 > URL: https://issues.apache.org/jira/browse/HAWQ-148 > Project: Apache HAWQ > Issue Type: Task > Components: Optimizer >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-148) Bump up optimizer and gpos version
[ https://issues.apache.org/jira/browse/HAWQ-148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang resolved HAWQ-148. Resolution: Fixed > Bump up optimizer and gpos version > -- > > Key: HAWQ-148 > URL: https://issues.apache.org/jira/browse/HAWQ-148 > Project: Apache HAWQ > Issue Type: Task > Components: Optimizer >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-146) Re-enable non-uniform partitioning DDLs
[ https://issues.apache.org/jira/browse/HAWQ-146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang closed HAWQ-146. -- Merged PR: https://github.com/apache/incubator-hawq/pull/159 > Re-enable non-uniform partitioning DDLs > --- > > Key: HAWQ-146 > URL: https://issues.apache.org/jira/browse/HAWQ-146 > Project: Apache HAWQ > Issue Type: Task > Components: DDL >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > > Previously we disabled DDLs that could create non-uniform partitioning > hierarchy. We are enabling those now. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-146) Re-enable non-uniform partitioning DDLs
[ https://issues.apache.org/jira/browse/HAWQ-146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xin zhang resolved HAWQ-146. Resolution: Fixed > Re-enable non-uniform partitioning DDLs > --- > > Key: HAWQ-146 > URL: https://issues.apache.org/jira/browse/HAWQ-146 > Project: Apache HAWQ > Issue Type: Task > Components: DDL >Reporter: Entong Shen >Assignee: xin zhang > Labels: closed-pr > > Previously we disabled DDLs that could create non-uniform partitioning > hierarchy. We are enabling those now. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
