[jira] [Commented] (HAWQ-597) Add Travis CI support under OSX

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360812#comment-15360812
 ] 

ASF GitHub Bot commented on HAWQ-597:
-

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-hawq/pull/765


> Add Travis CI support under OSX
> ---
>
> Key: HAWQ-597
> URL: https://issues.apache.org/jira/browse/HAWQ-597
> Project: Apache HAWQ
>  Issue Type: New Feature
>  Components: Build
>Reporter: hongwu
>Assignee: Lei Chang
>
> Building with a branch of commits could be a disorder. To verify every 
> commit, I write a .travis.yml. Apache/incubator-hawq could still use Jenkins 
> as CI, but travis-ci can help contributor verify local commit before sending 
> pull request.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq pull request #765: HAWQ-597. Update README.md

[asfgit]

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-hawq/pull/765


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-597) Add Travis CI support under OSX

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360789#comment-15360789
 ] 

ASF GitHub Bot commented on HAWQ-597:
-

Github user radarwave commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
+1


> Add Travis CI support under OSX
> ---
>
> Key: HAWQ-597
> URL: https://issues.apache.org/jira/browse/HAWQ-597
> Project: Apache HAWQ
>  Issue Type: New Feature
>  Components: Build
>Reporter: hongwu
>Assignee: Lei Chang
>
> Building with a branch of commits could be a disorder. To verify every 
> commit, I write a .travis.yml. Apache/incubator-hawq could still use Jenkins 
> as CI, but travis-ci can help contributor verify local commit before sending 
> pull request.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq issue #765: HAWQ-597. Update README.md

[radarwave]

Github user radarwave commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
+1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq issue #765: HAWQ-597. Update README.md

[huor]

Github user huor commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
+1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-597) Add Travis CI support under OSX

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360788#comment-15360788
 ] 

ASF GitHub Bot commented on HAWQ-597:
-

Github user huor commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
+1


> Add Travis CI support under OSX
> ---
>
> Key: HAWQ-597
> URL: https://issues.apache.org/jira/browse/HAWQ-597
> Project: Apache HAWQ
>  Issue Type: New Feature
>  Components: Build
>Reporter: hongwu
>Assignee: Lei Chang
>
> Building with a branch of commits could be a disorder. To verify every 
> commit, I write a .travis.yml. Apache/incubator-hawq could still use Jenkins 
> as CI, but travis-ci can help contributor verify local commit before sending 
> pull request.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HAWQ-597) Add Travis CI support under OSX

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360785#comment-15360785
 ] 

ASF GitHub Bot commented on HAWQ-597:
-

GitHub user xunzhang opened a pull request:

https://github.com/apache/incubator-hawq/pull/765

HAWQ-597. Update README.md



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/xunzhang/incubator-hawq HAWQ-597

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-hawq/pull/765.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #765


commit 745bdca4cb8ed27db319f05899ae1554cdc29a29
Author: xunzhang 
Date:   2016-07-04T03:22:20Z

HAWQ-597. Update README.md




> Add Travis CI support under OSX
> ---
>
> Key: HAWQ-597
> URL: https://issues.apache.org/jira/browse/HAWQ-597
> Project: Apache HAWQ
>  Issue Type: New Feature
>  Components: Build
>Reporter: hongwu
>Assignee: Lei Chang
>
> Building with a branch of commits could be a disorder. To verify every 
> commit, I write a .travis.yml. Apache/incubator-hawq could still use Jenkins 
> as CI, but travis-ci can help contributor verify local commit before sending 
> pull request.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HAWQ-597) Add Travis CI support under OSX

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360786#comment-15360786
 ] 

ASF GitHub Bot commented on HAWQ-597:
-

Github user xunzhang commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
cc @huor 


> Add Travis CI support under OSX
> ---
>
> Key: HAWQ-597
> URL: https://issues.apache.org/jira/browse/HAWQ-597
> Project: Apache HAWQ
>  Issue Type: New Feature
>  Components: Build
>Reporter: hongwu
>Assignee: Lei Chang
>
> Building with a branch of commits could be a disorder. To verify every 
> commit, I write a .travis.yml. Apache/incubator-hawq could still use Jenkins 
> as CI, but travis-ci can help contributor verify local commit before sending 
> pull request.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq pull request #765: HAWQ-597. Update README.md

[xunzhang]

GitHub user xunzhang opened a pull request:

https://github.com/apache/incubator-hawq/pull/765

HAWQ-597. Update README.md



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/xunzhang/incubator-hawq HAWQ-597

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-hawq/pull/765.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #765


commit 745bdca4cb8ed27db319f05899ae1554cdc29a29
Author: xunzhang 
Date:   2016-07-04T03:22:20Z

HAWQ-597. Update README.md




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq issue #765: HAWQ-597. Update README.md

[xunzhang]

Github user xunzhang commented on the issue:

https://github.com/apache/incubator-hawq/pull/765
  
cc @huor 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-805) Refactor feature test for exttab1 with new framework

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360777#comment-15360777
 ] 

ASF GitHub Bot commented on HAWQ-805:
-

Github user xunzhang closed the pull request at:

https://github.com/apache/incubator-hawq/pull/724


> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HAWQ-805) Refactor feature test for exttab1 with new framework

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360776#comment-15360776
 ] 

ASF GitHub Bot commented on HAWQ-805:
-

Github user xunzhang commented on the issue:

https://github.com/apache/incubator-hawq/pull/724
  
Merged into master, thanks.


> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq pull request #724: HAWQ-805. Add feature test for exttab1 wit...

[xunzhang]

Github user xunzhang closed the pull request at:

https://github.com/apache/incubator-hawq/pull/724


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Resolved] (HAWQ-805) Refactor feature test for exttab1 with new framework

[hongwu (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

hongwu resolved HAWQ-805.
-
Resolution: Fixed

> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq pull request #764: HAWQ-875. Update HAWQ version to 2.0.1.0

[asfgit]

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-hawq/pull/764


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-875) Upgrade HAWQ version to 2.0.1.0

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360764#comment-15360764
 ] 

ASF GitHub Bot commented on HAWQ-875:
-

Github user yaoj2 commented on the issue:

https://github.com/apache/incubator-hawq/pull/764
  
+1


> Upgrade HAWQ version to 2.0.1.0
> ---
>
> Key: HAWQ-875
> URL: https://issues.apache.org/jira/browse/HAWQ-875
> Project: Apache HAWQ
>  Issue Type: Task
>  Components: Build
>Reporter: Radar Lei
>Assignee: Radar Lei
>
> Since we already have a branch for HAWQ 2.0.0.0, maybe we should start to  
> use a new version number '2.0.1.0'.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq issue #724: HAWQ-805. Add feature test for exttab1 with new f...

[yaoj2]

Github user yaoj2 commented on the issue:

https://github.com/apache/incubator-hawq/pull/724
  
LGTM


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-805) Refactor feature test for exttab1 with new framework

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360762#comment-15360762
 ] 

ASF GitHub Bot commented on HAWQ-805:
-

Github user yaoj2 commented on the issue:

https://github.com/apache/incubator-hawq/pull/724
  
LGTM


> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq issue #764: HAWQ-875. Update HAWQ version to 2.0.1.0

[yaoj2]

Github user yaoj2 commented on the issue:

https://github.com/apache/incubator-hawq/pull/764
  
+1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Resolved] (HAWQ-812) Activate standby master failed after create a new database

[Ming LI (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ming LI resolved HAWQ-812.
--
Resolution: Fixed
  Assignee: Ming LI  (was: Lei Chang)

> Activate standby master failed after create a new database
> --
>
> Key: HAWQ-812
> URL: https://issues.apache.org/jira/browse/HAWQ-812
> Project: Apache HAWQ
>  Issue Type: Bug
>Reporter: Chunling Wang
>Assignee: Ming LI
>
> Activate standby master failed after create a new database. However, it will 
> success if we do not create a new database even we create a new table and 
> insert data. 
> 1. Create a new database 'gptest'
> {code}
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (3 rows)
> [gpadmin@test1 ~]$ createdb gptest
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  gptest| gpadmin | UTF8 |
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (4 rows)
> {code}
> 2. Stop HAWQ master
> {code}
> [gpadmin@test1 ~]$ hawq stop master -a
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq 
> stop'
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: 
> ['stop', 'master']
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 
> connections to the database
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master 
> instance shutdown with mode='smart'
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master
> 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped 
> successfully
> {code}
> 3. Activate standby master
> {code}
> [gpadmin@test1 ~]$ ssh test5 'source 
> /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh;
>  hawq activate standby -a'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 
> 'hawq activate'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log 
> in:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq 
> with args: ['activate', 'standby']
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to 
> activate standby master 'test5'
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is 
> not running, skip
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the 
> running segments
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running 
> standby
> 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master 
> host name in hawq-site.xml
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC 
> hawq_master_address_host already exist in hawq-site.xml
> Update it with value: test5
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current 
> standby from hawq-site.xml
> 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in 
> master only mode
> {code}
> It hangs and can not start master. And the master log is following:
> {code}
> 2016-06-13 20:14:40.268022 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","database 
> system was shut down at 2016-06-13 20:02:50 PDT",,,0,,"xlog.c",6205,
> 2016-06-13 20:14:40.268112 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","found 
> recovery.conf file indicating standby takeover recovery 
> needed",,,0,,"xlog.c",5485,
> 2016-06-13 20:14:40.268131 
> 

[jira] [Commented] (HAWQ-805) Refactor feature test for exttab1 with new framework

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360760#comment-15360760
 ] 

ASF GitHub Bot commented on HAWQ-805:
-

Github user xunzhang commented on a diff in the pull request:

https://github.com/apache/incubator-hawq/pull/724#discussion_r69403100
  
--- Diff: src/test/feature/ExternalSource/sql/exttab1.sql.source ---
@@ -0,0 +1,551 @@
+--
+-- external tables 1 - short and simple functional tests. The full set of 
tests
+-- exists in cdbunit.
+--
+-- start_matchsubs
+--
+-- # replace return code in error message (platform specific)
+--
+-- m/ERROR\:\s+external table .* command ended with .* not found/
+-- s/nosuchcommand\:\s*(command)? not found/nosuchcommand\: NOT FOUND/
+--
+-- m/ERROR\:\s+external table .* command ended with .*No such file.*/
+-- s/nosuchfile\.txt\:\s*No such file (or directory)?/nosuchfile\.txt\: NO 
SUCH FILE/
+-- m/ERROR\:\s+external table .* command ended with .*No such file.*/i
+-- s/cat\: (cannot open)? nosuchfile\.txt/cat\: nosuchfile\.txt/
+--
+-- # remove line number - redhat
+-- m/ERROR\:\s+external table .* command ended with .*NOT FOUND.*/i
+-- s/\s+line \d+\://
+-- # remove cannot open - solaris
+-- m/ERROR\:\s+external table .* command ended with .*cat\: cannot open.*/i
+-- s/cat\: cannot open (.*)$/cat\: $1\: NO SUCH FILE/
+--
+-- end_matchsubs
+SET gp_foreign_data_access = true;
+set optimizer_disable_missing_stats_collection = on;
+CREATE TABLE REG_REGION (R_REGIONKEY INT, R_NAME CHAR(25), R_COMMENT 
VARCHAR(152)) DISTRIBUTED BY (R_REGIONKEY);
+
+-- start_ignore
+-- --
+-- check platform
+-- --
+drop external web table if exists check_echo;
+CREATE EXTERNAL WEB TABLE check_echo (x text)
+execute E'(echo gpfdist)'
+on SEGMENT 0
+format 'text';
+select * from check_echo;
+
+
+-- end_ignore
+
+
+-- --
+-- 'gpfdist' protocol
+-- --
+
+CREATE EXTERNAL WEB TABLE gpfdist_status (x text)
+execute E'( python $GPHOME/bin/lib/gppinggpfdist.py @hostname@:7070 2>&1 
|| echo) '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_start (x text)
+execute E'((@gpwhich_gpfdist@ -p 7070 -d @abs_srcdir@/data  /dev/null 2>&1 &); sleep 2; echo "starting...") '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_stop (x text)
+execute E'(/bin/pkill gpfdist || killall gpfdist) > /dev/null 2>&1; echo 
"stopping..."'
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+-- start_ignore
+select * from gpfdist_stop;
+select * from gpfdist_status;
+select * from gpfdist_start;
+select * from gpfdist_status;
+-- end_ignore
+
+CREATE EXTERNAL TABLE EXT_NATION  ( N_NATIONKEY  INTEGER ,
+N_NAME   CHAR(25) ,
+N_REGIONKEY  INTEGER ,
+N_COMMENTVARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation.tbl' )
+FORMAT 'text' (delimiter '|');
+CREATE EXTERNAL TABLE EXT_REGION  (LIKE REG_REGION)
+location ('gpfdist://@hostname@:7070/region.tbl' )
+FORMAT 'text' (delimiter '|');
+
+SELECT * FROM EXT_NATION;
+SELECT * FROM EXT_REGION;
+SELECT * FROM EXT_REGION as r, EXT_NATION as n WHERE n.N_REGIONKEY = 
r.R_REGIONKEY;
+
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+-- end_ignore
+
+-- drop tables
+DROP EXTERNAL TABLE EXT_NATION;
+DROP EXTERNAL TABLE EXT_REGION;
+
+--
+-- gpfdist in csv (mpp-1519, etc)
+--
+CREATE EXTERNAL WEB TABLE gpfdist_csv_start (x text)
+execute E'((@gpwhich_gpfdist@ -p 7070 -d @abs_srcdir@/data  /dev/null 2>&1 &); sleep 2; echo "starting...") '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+-- 
+-- "
+-- (end the double quote so emacs highlighting works correctly)
+--
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+select * from gpfdist_csv_start;
+select * from gpfdist_status;
+-- end_ignore
+
+create external table ext_whois (
+source_lineno  int,
+domain_namevarchar(350),
+subdomain  varchar(150),
+tldvarchar(50),
+ip_address inet,
+ip_address_int bigint,
+reverse_dnsvarchar(512),
+reverse_domain 

[jira] [Commented] (HAWQ-812) Activate standby master failed after create a new database

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360758#comment-15360758
 ] 

ASF GitHub Bot commented on HAWQ-812:
-

Github user liming01 closed the pull request at:

https://github.com/apache/incubator-hawq/pull/761


> Activate standby master failed after create a new database
> --
>
> Key: HAWQ-812
> URL: https://issues.apache.org/jira/browse/HAWQ-812
> Project: Apache HAWQ
>  Issue Type: Bug
>Reporter: Chunling Wang
>Assignee: Lei Chang
>
> Activate standby master failed after create a new database. However, it will 
> success if we do not create a new database even we create a new table and 
> insert data. 
> 1. Create a new database 'gptest'
> {code}
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (3 rows)
> [gpadmin@test1 ~]$ createdb gptest
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  gptest| gpadmin | UTF8 |
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (4 rows)
> {code}
> 2. Stop HAWQ master
> {code}
> [gpadmin@test1 ~]$ hawq stop master -a
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq 
> stop'
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: 
> ['stop', 'master']
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 
> connections to the database
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master 
> instance shutdown with mode='smart'
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master
> 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped 
> successfully
> {code}
> 3. Activate standby master
> {code}
> [gpadmin@test1 ~]$ ssh test5 'source 
> /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh;
>  hawq activate standby -a'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 
> 'hawq activate'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log 
> in:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq 
> with args: ['activate', 'standby']
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to 
> activate standby master 'test5'
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is 
> not running, skip
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the 
> running segments
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running 
> standby
> 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master 
> host name in hawq-site.xml
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC 
> hawq_master_address_host already exist in hawq-site.xml
> Update it with value: test5
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current 
> standby from hawq-site.xml
> 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in 
> master only mode
> {code}
> It hangs and can not start master. And the master log is following:
> {code}
> 2016-06-13 20:14:40.268022 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","database 
> system was shut down at 2016-06-13 20:02:50 PDT",,,0,,"xlog.c",6205,
> 2016-06-13 20:14:40.268112 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","found 
> recovery.conf file indicating standby takeover recovery 
> 

[GitHub] incubator-hawq issue #724: HAWQ-805. Add feature test for exttab1 with new f...

[huor]

Github user huor commented on the issue:

https://github.com/apache/incubator-hawq/pull/724
  
+1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-805) Refactor feature test for exttab1 with new framework

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360756#comment-15360756
 ] 

ASF GitHub Bot commented on HAWQ-805:
-

Github user huor commented on the issue:

https://github.com/apache/incubator-hawq/pull/724
  
+1


> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq pull request #761: HAWQ-812. only hdfs file/dir can be skippe...

[liming01]

Github user liming01 closed the pull request at:

https://github.com/apache/incubator-hawq/pull/761


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-812) Activate standby master failed after create a new database

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360755#comment-15360755
 ] 

ASF GitHub Bot commented on HAWQ-812:
-

Github user linwen commented on the issue:

https://github.com/apache/incubator-hawq/pull/761
  
LGTM +1


> Activate standby master failed after create a new database
> --
>
> Key: HAWQ-812
> URL: https://issues.apache.org/jira/browse/HAWQ-812
> Project: Apache HAWQ
>  Issue Type: Bug
>Reporter: Chunling Wang
>Assignee: Lei Chang
>
> Activate standby master failed after create a new database. However, it will 
> success if we do not create a new database even we create a new table and 
> insert data. 
> 1. Create a new database 'gptest'
> {code}
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (3 rows)
> [gpadmin@test1 ~]$ createdb gptest
> [gpadmin@test1 ~]$ psql -l
>  List of databases
>Name|  Owner  | Encoding | Access privileges
> ---+-+--+---
>  gptest| gpadmin | UTF8 |
>  postgres  | gpadmin | UTF8 |
>  template0 | gpadmin | UTF8 |
>  template1 | gpadmin | UTF8 |
> (4 rows)
> {code}
> 2. Stop HAWQ master
> {code}
> [gpadmin@test1 ~]$ hawq stop master -a
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq 
> stop'
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:13:44:068559 
> hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: 
> ['stop', 'master']
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 
> connections to the database
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master 
> instance shutdown with mode='smart'
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1
> 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master
> 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped 
> successfully
> {code}
> 3. Activate standby master
> {code}
> [gpadmin@test1 ~]$ ssh test5 'source 
> /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh;
>  hawq activate standby -a'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 
> 'hawq activate'
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log 
> in:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to:
> 20160613:20:14:14:126841 
> hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq 
> with args: ['activate', 'standby']
> 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to 
> activate standby master 'test5'
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is 
> not running, skip
> 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the 
> running segments
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-
> 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running 
> standby
> 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master 
> host name in hawq-site.xml
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC 
> hawq_master_address_host already exist in hawq-site.xml
> Update it with value: test5
> 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current 
> standby from hawq-site.xml
> 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in 
> master only mode
> {code}
> It hangs and can not start master. And the master log is following:
> {code}
> 2016-06-13 20:14:40.268022 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","database 
> system was shut down at 2016-06-13 20:02:50 PDT",,,0,,"xlog.c",6205,
> 2016-06-13 20:14:40.268112 
> PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","found 
> recovery.conf file indicating standby takeover recovery 
> 

[GitHub] incubator-hawq issue #761: HAWQ-812. only hdfs file/dir can be skipped at re...

[linwen]

Github user linwen commented on the issue:

https://github.com/apache/incubator-hawq/pull/761
  
LGTM +1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq pull request #757: HAWQ-877. Need to stop building when build...

[liming01]

Github user liming01 closed the pull request at:

https://github.com/apache/incubator-hawq/pull/757


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Commented] (HAWQ-877) Need to stop building when building error occurs in gpfdist directory

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/HAWQ-877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360750#comment-15360750
 ] 

ASF GitHub Bot commented on HAWQ-877:
-

Github user liming01 closed the pull request at:

https://github.com/apache/incubator-hawq/pull/757


> Need to stop building when building error occurs in gpfdist directory
> -
>
> Key: HAWQ-877
> URL: https://issues.apache.org/jira/browse/HAWQ-877
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Build
>Reporter: Ming LI
>Assignee: Lei Chang
>
> When building gpfdist report error "'openssl/ssl.h' file not found", it 
> doesn't stop building, so the last error we can see it not the right root 
> error. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[GitHub] incubator-hawq issue #761: HAWQ-812. only hdfs file/dir can be skipped at re...

[ztao1987]

Github user ztao1987 commented on the issue:

https://github.com/apache/incubator-hawq/pull/761
  
+1


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[jira] [Updated] (HAWQ-805) Refactor feature test for exttab1 with new framework

[hongwu (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

hongwu updated HAWQ-805:

Summary: Refactor feature test for exttab1 with new framework  (was: Add 
feature test for exttab1 with new framework)

> Refactor feature test for exttab1 with new framework
> 
>
> Key: HAWQ-805
> URL: https://issues.apache.org/jira/browse/HAWQ-805
> Project: Apache HAWQ
>  Issue Type: Test
>  Components: Tests
>Reporter: hongwu
>Assignee: hongwu
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)