[
https://issues.apache.org/jira/browse/HAWQ-358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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.out 2016-03-25 10:23:17.000000000 -0700
--- ./results/exttab1.out 2016-03-25 10:23:17.000000000 -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 writable external 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.000000000 -0700
--- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700
***************
*** 13,22 ****
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! path | itemname | fieldname | fieldtype
! ------+----------+-----------+-----------
! (0 rows)
!
-- Create function to insert and scan in-memory data to pg_class
CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text)
RETURNS text
AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so',
'convert_to_hcatalog_schema'
--- 13,19 ----
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! ERROR: remote component error (0): (SOMEFILE:SOMEFUNC)
-- Create function to insert and scan in-memory data to pg_class
CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text)
RETURNS text
AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so',
'convert_to_hcatalog_schema'
======================================================================
{code}
was (Author: xzhang.pivotal):
At this moment, only two tests failed:
```
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)
```
```
=======================
2 of 56 tests failed.
=======================
```
The regression.diffs is:
```
*** ./expected/exttab1_optimizer.out 2016-03-25 10:23:17.000000000 -0700
--- ./results/exttab1.out 2016-03-25 10:23:17.000000000 -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 writable external 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.000000000 -0700
--- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700
***************
*** 13,22 ****
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! path | itemname | fieldname | fieldtype
! ------+----------+-----------+-----------
! (0 rows)
!
-- Create function to insert and scan in-memory data to pg_class
CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text)
RETURNS text
AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so',
'convert_to_hcatalog_schema'
--- 13,19 ----
-- enable GUC
SET hcatalog_enable = true;
SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! ERROR: remote component error (0): (SOMEFILE:SOMEFUNC)
-- Create function to insert and scan in-memory data to pg_class
CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text)
RETURNS text
AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so',
'convert_to_hcatalog_schema'
======================================================================
```
> Installcheck good failures in hawq-dev environment
> --------------------------------------------------
>
> Key: HAWQ-358
> URL: https://issues.apache.org/jira/browse/HAWQ-358
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Tests
> Reporter: Caleb Welton
> Assignee: Ruilong Huo
> Fix For: backlog
>
>
> Build and test within a hawq dev environment setup via the instructions
> outlined in the hawq-devel docker enviroment:
> https://hub.docker.com/r/mayjojo/hawq-devel/
> Results in the following errors
> {noformat}
> ...
> test errortbl ... FAILED (6.83 sec)
> ...
> test subplan ... FAILED (8.15 sec)
> ...
> test create_table_distribution ... FAILED (3.47 sec)
> test copy ... FAILED (34.76 sec)
> ...
> test set_functions ... FAILED (4.90 sec)
> ...
> test exttab1 ... FAILED (17.66 sec)
> ...
> {noformat}
> Summary of issues:
> * *errortbl* - every connection to gpfdist results in "connection with
> gpfdist failed for gpfdist://localhost:7070/nation.tbl"
> * *subplan* - trying to create plpython resulted in "could not access file
> "$libdir/plpython": No such file or directory", lack of plpython causes many
> other statements to fail
> * *create_table_distribution* - test likely needs some refactoring to reflect
> calculating correct bucketnum based on current system configuration
> * *copy* - seems to be failing because rows aren't coming out in the expected
> order, test needs fixing to be able to handle this
> * *set_functions* - same plpythonu issue described above
> * *exttab1* - same issue reading from gpfdist described above
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
