[ 
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)

Reply via email to