[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
