You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "xin zhang (JIRA)" <ji...@apache.org> on 2016/10/27 00:46:59 UTC
[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&focusedCommentId=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.000000000 -0700
2 --- ./results/hcatalog_lookup.out 2016-10-26 15:53:37.000000000 -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)