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

Reply via email to