hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hubertzh...@apache.org
Subject [2/6] incubator-hawq git commit: HAWQ-1359. Add policy test for HAWQ with Ranger enabled.
Date Thu, 02 Mar 2017 01:55:06 GMT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/15.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/15.sql b/src/test/feature/Ranger/sql/admin/15.sql
new file mode 100644
index 0000000..935baa5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/15.sql
@@ -0,0 +1,2 @@
+drop FUNCTION si_lt(text, text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/16.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/16.sql b/src/test/feature/Ranger/sql/admin/16.sql
new file mode 100644
index 0000000..99c08ee
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/16.sql
@@ -0,0 +1,2 @@
+drop FUNCTION normalize_si(text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/17.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/17.sql b/src/test/feature/Ranger/sql/admin/17.sql
new file mode 100644
index 0000000..84d8ed2
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/17.sql
@@ -0,0 +1,2 @@
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/18.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/18.sql b/src/test/feature/Ranger/sql/admin/18.sql
new file mode 100644
index 0000000..3a4aedc
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/18.sql
@@ -0,0 +1,2 @@
+DROP RESOURCE QUEUE myqueue;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/19.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/19.sql b/src/test/feature/Ranger/sql/admin/19.sql
new file mode 100644
index 0000000..a8563c4
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/19.sql
@@ -0,0 +1,2 @@
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;    
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/2.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/2.sql b/src/test/feature/Ranger/sql/admin/2.sql
new file mode 100644
index 0000000..f66cf7a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/2.sql
@@ -0,0 +1,2 @@
+create language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/20.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/20.sql b/src/test/feature/Ranger/sql/admin/20.sql
new file mode 100644
index 0000000..a2e59f1
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/20.sql
@@ -0,0 +1,2 @@
+CREATE TABLE foo(i int) TABLESPACE mytblspace;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/21.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/21.sql b/src/test/feature/Ranger/sql/admin/21.sql
new file mode 100644
index 0000000..6b750fd
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/21.sql
@@ -0,0 +1,2 @@
+insert into foo(i) values(1234);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/22.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/22.sql b/src/test/feature/Ranger/sql/admin/22.sql
new file mode 100644
index 0000000..881831c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/22.sql
@@ -0,0 +1,2 @@
+drop table foo;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/23.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/23.sql b/src/test/feature/Ranger/sql/admin/23.sql
new file mode 100644
index 0000000..2049d96
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/23.sql
@@ -0,0 +1,2 @@
+drop tablespace mytblspace;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/24.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/24.sql b/src/test/feature/Ranger/sql/admin/24.sql
new file mode 100644
index 0000000..3b84fc9
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/24.sql
@@ -0,0 +1,2 @@
+COPY a FROM '/tmp/a.txt';
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/25.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/25.sql b/src/test/feature/Ranger/sql/admin/25.sql
new file mode 100644
index 0000000..fdef22f
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/25.sql
@@ -0,0 +1,2 @@
+COPY a TO STDOUT WITH DELIMITER '|';
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/26.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/26.sql b/src/test/feature/Ranger/sql/admin/26.sql
new file mode 100644
index 0000000..b3602e6
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/26.sql
@@ -0,0 +1,2 @@
+CREATE EXTERNAL TABLE ext_t ( N_NATIONKEY INTEGER ,N_NAME CHAR(25), N_REGIONKEY  INTEGER ,N_COMMENT    VARCHAR(152))location ('gpfdist://localhost:7070/nation_error50.tbl')FORMAT 'text' (delimiter '|')SEGMENT REJECT LIMIT 51;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/27.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/27.sql b/src/test/feature/Ranger/sql/admin/27.sql
new file mode 100644
index 0000000..9e1d5b5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/27.sql
@@ -0,0 +1,2 @@
+select * from ext_t order by N_NATIONKEY;   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/28.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/28.sql b/src/test/feature/Ranger/sql/admin/28.sql
new file mode 100644
index 0000000..2cf4d94
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/28.sql
@@ -0,0 +1,2 @@
+CREATE WRITABLE EXTERNAL TABLE ext_t2 (i int) LOCATION ('gpfdist://localhost:7070/ranger2.out') FORMAT 'TEXT' ( DELIMITER '|' NULL ' ');
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/29.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/29.sql b/src/test/feature/Ranger/sql/admin/29.sql
new file mode 100644
index 0000000..a7ce08c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/29.sql
@@ -0,0 +1,2 @@
+insert into ext_t2(i) values(234);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/3.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/3.sql b/src/test/feature/Ranger/sql/admin/3.sql
new file mode 100644
index 0000000..60256d1
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/3.sql
@@ -0,0 +1,2 @@
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/30.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/30.sql b/src/test/feature/Ranger/sql/admin/30.sql
new file mode 100644
index 0000000..cdb6310
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/30.sql
@@ -0,0 +1,2 @@
+drop EXTERNAL TABLE ext_t;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/31.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/31.sql b/src/test/feature/Ranger/sql/admin/31.sql
new file mode 100644
index 0000000..78c3bac
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/31.sql
@@ -0,0 +1,2 @@
+drop EXTERNAL TABLE ext_t2;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/32.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/32.sql b/src/test/feature/Ranger/sql/admin/32.sql
new file mode 100644
index 0000000..22f3d94
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/32.sql
@@ -0,0 +1,2 @@
+create schema sa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/33.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/33.sql b/src/test/feature/Ranger/sql/admin/33.sql
new file mode 100644
index 0000000..1ecbb3d
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/33.sql
@@ -0,0 +1,2 @@
+create temp table ta(i int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/34.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/34.sql b/src/test/feature/Ranger/sql/admin/34.sql
new file mode 100644
index 0000000..60553a7
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/34.sql
@@ -0,0 +1,2 @@
+create view av as select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/35.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/35.sql b/src/test/feature/Ranger/sql/admin/35.sql
new file mode 100644
index 0000000..c6980eb
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/35.sql
@@ -0,0 +1,2 @@
+create table aa as select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/36.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/36.sql b/src/test/feature/Ranger/sql/admin/36.sql
new file mode 100644
index 0000000..72650fc
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/36.sql
@@ -0,0 +1,2 @@
+create table sa.t(a int, b int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/37.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/37.sql b/src/test/feature/Ranger/sql/admin/37.sql
new file mode 100644
index 0000000..b468240
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/37.sql
@@ -0,0 +1,2 @@
+CREATE SEQUENCE myseq START 1;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/38.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/38.sql b/src/test/feature/Ranger/sql/admin/38.sql
new file mode 100644
index 0000000..e853d79
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/38.sql
@@ -0,0 +1,2 @@
+insert into a values(1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/39.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/39.sql b/src/test/feature/Ranger/sql/admin/39.sql
new file mode 100644
index 0000000..e853d79
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/39.sql
@@ -0,0 +1,2 @@
+insert into a values(1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/4.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/4.sql b/src/test/feature/Ranger/sql/admin/4.sql
new file mode 100644
index 0000000..0cf5902
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/4.sql
@@ -0,0 +1,2 @@
+select * from f4();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/40.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/40.sql b/src/test/feature/Ranger/sql/admin/40.sql
new file mode 100644
index 0000000..b40f4c6
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/40.sql
@@ -0,0 +1,2 @@
+insert into a VALUES (nextval('myseq'));
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/41.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/41.sql b/src/test/feature/Ranger/sql/admin/41.sql
new file mode 100644
index 0000000..385baa2
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/41.sql
@@ -0,0 +1,2 @@
+select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/42.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/42.sql b/src/test/feature/Ranger/sql/admin/42.sql
new file mode 100644
index 0000000..4ceed17
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/42.sql
@@ -0,0 +1,2 @@
+select generate_series(1,3);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/43.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/43.sql b/src/test/feature/Ranger/sql/admin/43.sql
new file mode 100644
index 0000000..480e607
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/43.sql
@@ -0,0 +1,2 @@
+select * from av;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/44.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/44.sql b/src/test/feature/Ranger/sql/admin/44.sql
new file mode 100644
index 0000000..a45225c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/44.sql
@@ -0,0 +1,2 @@
+SELECT setval('myseq', 1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/45.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/45.sql b/src/test/feature/Ranger/sql/admin/45.sql
new file mode 100644
index 0000000..22834c8
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/45.sql
@@ -0,0 +1,2 @@
+SELECT * INTO aaa FROM a WHERE i > 0 order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/46.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/46.sql b/src/test/feature/Ranger/sql/admin/46.sql
new file mode 100644
index 0000000..2065b88
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/46.sql
@@ -0,0 +1,2 @@
+PREPARE fooplan (int) AS INSERT INTO a VALUES($1);EXECUTE fooplan(1);DEALLOCATE fooplan;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/47.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/47.sql b/src/test/feature/Ranger/sql/admin/47.sql
new file mode 100644
index 0000000..e4e2c41
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/47.sql
@@ -0,0 +1,2 @@
+explain select * from a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/48.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/48.sql b/src/test/feature/Ranger/sql/admin/48.sql
new file mode 100644
index 0000000..9f2f20a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/48.sql
@@ -0,0 +1,2 @@
+CREATE FUNCTION scube_accum(numeric, numeric) RETURNS numeric AS 'select $1 + $2 * $2 * $2' LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/49.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/49.sql b/src/test/feature/Ranger/sql/admin/49.sql
new file mode 100644
index 0000000..e6599f1
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/49.sql
@@ -0,0 +1,2 @@
+CREATE AGGREGATE scube(numeric) ( SFUNC = scube_accum, STYPE = numeric, INITCOND = 0 );
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/5.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/5.sql b/src/test/feature/Ranger/sql/admin/5.sql
new file mode 100644
index 0000000..c9c075d
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/5.sql
@@ -0,0 +1,2 @@
+drop function f4();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/50.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/50.sql b/src/test/feature/Ranger/sql/admin/50.sql
new file mode 100644
index 0000000..993576b
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/50.sql
@@ -0,0 +1,2 @@
+ALTER AGGREGATE scube(numeric) RENAME TO scube2;   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/51.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/51.sql b/src/test/feature/Ranger/sql/admin/51.sql
new file mode 100644
index 0000000..b05f5ac
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/51.sql
@@ -0,0 +1,2 @@
+DROP AGGREGATE scube2(numeric);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/52.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/52.sql b/src/test/feature/Ranger/sql/admin/52.sql
new file mode 100644
index 0000000..3b29f9a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/52.sql
@@ -0,0 +1,2 @@
+DROP FUNCTION scube_accum(numeric, numeric);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/53.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/53.sql b/src/test/feature/Ranger/sql/admin/53.sql
new file mode 100644
index 0000000..0707842
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/53.sql
@@ -0,0 +1,2 @@
+CREATE TYPE mytype AS (f1 int, f2 int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/54.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/54.sql b/src/test/feature/Ranger/sql/admin/54.sql
new file mode 100644
index 0000000..ea91e5a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/54.sql
@@ -0,0 +1,2 @@
+CREATE FUNCTION getfoo() RETURNS SETOF mytype AS $$ SELECT i, i FROM a order by i $$ LANGUAGE SQL;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/55.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/55.sql b/src/test/feature/Ranger/sql/admin/55.sql
new file mode 100644
index 0000000..ff62421
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/55.sql
@@ -0,0 +1,2 @@
+select getfoo();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/56.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/56.sql b/src/test/feature/Ranger/sql/admin/56.sql
new file mode 100644
index 0000000..9704249
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/56.sql
@@ -0,0 +1,2 @@
+drop type mytype cascade;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/57.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/57.sql b/src/test/feature/Ranger/sql/admin/57.sql
new file mode 100644
index 0000000..9a3466c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/57.sql
@@ -0,0 +1,2 @@
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/58.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/58.sql b/src/test/feature/Ranger/sql/admin/58.sql
new file mode 100644
index 0000000..8909ac0
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/58.sql
@@ -0,0 +1,2 @@
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/59.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/59.sql b/src/test/feature/Ranger/sql/admin/59.sql
new file mode 100644
index 0000000..7082e2b
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/59.sql
@@ -0,0 +1,2 @@
+\d
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/6.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/6.sql b/src/test/feature/Ranger/sql/admin/6.sql
new file mode 100644
index 0000000..ca4991c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/6.sql
@@ -0,0 +1,2 @@
+drop language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/60.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/60.sql b/src/test/feature/Ranger/sql/admin/60.sql
new file mode 100644
index 0000000..10d68f3
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/60.sql
@@ -0,0 +1,2 @@
+analyze a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/61.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/61.sql b/src/test/feature/Ranger/sql/admin/61.sql
new file mode 100644
index 0000000..ab2560b
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/61.sql
@@ -0,0 +1,2 @@
+analyze;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/62.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/62.sql b/src/test/feature/Ranger/sql/admin/62.sql
new file mode 100644
index 0000000..afb4bd5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/62.sql
@@ -0,0 +1,2 @@
+vacuum aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/63.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/63.sql b/src/test/feature/Ranger/sql/admin/63.sql
new file mode 100644
index 0000000..70f7c2a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/63.sql
@@ -0,0 +1,2 @@
+vacuum analyze;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/64.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/64.sql b/src/test/feature/Ranger/sql/admin/64.sql
new file mode 100644
index 0000000..addef79
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/64.sql
@@ -0,0 +1,2 @@
+truncate aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/65.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/65.sql b/src/test/feature/Ranger/sql/admin/65.sql
new file mode 100644
index 0000000..3785597
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/65.sql
@@ -0,0 +1,2 @@
+alter table a rename column i to j;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/66.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/66.sql b/src/test/feature/Ranger/sql/admin/66.sql
new file mode 100644
index 0000000..c684900
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/66.sql
@@ -0,0 +1,2 @@
+drop SEQUENCE myseq;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/67.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/67.sql b/src/test/feature/Ranger/sql/admin/67.sql
new file mode 100644
index 0000000..faeb08f
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/67.sql
@@ -0,0 +1,2 @@
+drop view av;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/68.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/68.sql b/src/test/feature/Ranger/sql/admin/68.sql
new file mode 100644
index 0000000..3647118
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/68.sql
@@ -0,0 +1,2 @@
+drop table aaa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/69.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/69.sql b/src/test/feature/Ranger/sql/admin/69.sql
new file mode 100644
index 0000000..a99bd9d
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/69.sql
@@ -0,0 +1,2 @@
+drop table aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/7.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/7.sql b/src/test/feature/Ranger/sql/admin/7.sql
new file mode 100644
index 0000000..6a4725c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/7.sql
@@ -0,0 +1,2 @@
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/70.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/70.sql b/src/test/feature/Ranger/sql/admin/70.sql
new file mode 100644
index 0000000..e5b6025
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/70.sql
@@ -0,0 +1,2 @@
+drop table a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/71.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/71.sql b/src/test/feature/Ranger/sql/admin/71.sql
new file mode 100644
index 0000000..5aac8ba
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/71.sql
@@ -0,0 +1,2 @@
+drop schema sa CASCADE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/8.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/8.sql b/src/test/feature/Ranger/sql/admin/8.sql
new file mode 100644
index 0000000..c584d07
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/8.sql
@@ -0,0 +1,2 @@
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/admin/9.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/admin/9.sql b/src/test/feature/Ranger/sql/admin/9.sql
new file mode 100644
index 0000000..13b9067
--- /dev/null
+++ b/src/test/feature/Ranger/sql/admin/9.sql
@@ -0,0 +1,2 @@
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/init_file
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/init_file b/src/test/feature/Ranger/sql/init_file
new file mode 100644
index 0000000..3c1fd76
--- /dev/null
+++ b/src/test/feature/Ranger/sql/init_file
@@ -0,0 +1,7 @@
+-- start_matchignore
+m/You are now connected to database*/
+s/public\|a\|table\|.*\|append only/public\|a\|table\|gpadmin\|append only/
+s/public\|aa\|table\|.*\|append only/public\|aa\|table\|gpadmin\|append only/
+s/public\|aaa\|table\|.*\|append only/public\|aaa\|table\|gpadmin\|append only/
+s/public\|av\|view\|.*\|none/public\|av\|view\|gpadmin\|none/
+-- end_matchignore

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/1.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/1.sql b/src/test/feature/Ranger/sql/normal/1.sql
new file mode 100644
index 0000000..33f1fbe
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/1.sql
@@ -0,0 +1,3 @@
+set session role=usertest1;
+create table a(i int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/10.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/10.sql b/src/test/feature/Ranger/sql/normal/10.sql
new file mode 100644
index 0000000..355aba0
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/10.sql
@@ -0,0 +1,3 @@
+set session role=usertest10;
+CREATE OR REPLACE FUNCTION si_same(text, text) RETURNS int AS $$ BEGIN IF normalize_si($1) < normalize_si($2) THEN RETURN -1; END IF; END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/11.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/11.sql b/src/test/feature/Ranger/sql/normal/11.sql
new file mode 100644
index 0000000..8e43dbd
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/11.sql
@@ -0,0 +1,3 @@
+set session role=usertest11;
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/12.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/12.sql b/src/test/feature/Ranger/sql/normal/12.sql
new file mode 100644
index 0000000..be948a3
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/12.sql
@@ -0,0 +1,3 @@
+set session role=usertest12;
+drop OPERATOR CLASS sva_special_ops USING btree;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/13.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/13.sql b/src/test/feature/Ranger/sql/normal/13.sql
new file mode 100644
index 0000000..7258043
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/13.sql
@@ -0,0 +1,3 @@
+set session role=usertest13;
+drop OPERATOR <# (text,text) CASCADE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/14.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/14.sql b/src/test/feature/Ranger/sql/normal/14.sql
new file mode 100644
index 0000000..8bd2dee
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/14.sql
@@ -0,0 +1,3 @@
+set session role=usertest14;
+drop FUNCTION si_same(text, text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/15.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/15.sql b/src/test/feature/Ranger/sql/normal/15.sql
new file mode 100644
index 0000000..6c69d24
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/15.sql
@@ -0,0 +1,3 @@
+set session role=usertest15;
+drop FUNCTION si_lt(text, text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/16.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/16.sql b/src/test/feature/Ranger/sql/normal/16.sql
new file mode 100644
index 0000000..fd7aca5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/16.sql
@@ -0,0 +1,3 @@
+set session role=usertest16;
+drop FUNCTION normalize_si(text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/17.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/17.sql b/src/test/feature/Ranger/sql/normal/17.sql
new file mode 100644
index 0000000..42de8bb
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/17.sql
@@ -0,0 +1,3 @@
+set session role=usertest17;
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/18.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/18.sql b/src/test/feature/Ranger/sql/normal/18.sql
new file mode 100644
index 0000000..f2c5d5e
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/18.sql
@@ -0,0 +1,3 @@
+set session role=usertest18;
+DROP RESOURCE QUEUE myqueue;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/19.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/19.sql b/src/test/feature/Ranger/sql/normal/19.sql
new file mode 100644
index 0000000..79b9ce0
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/19.sql
@@ -0,0 +1,3 @@
+set session role=usertest19;
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;    
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/2.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/2.sql b/src/test/feature/Ranger/sql/normal/2.sql
new file mode 100644
index 0000000..8d579a5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/2.sql
@@ -0,0 +1,3 @@
+set session role=usertest2;
+create language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/20.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/20.sql b/src/test/feature/Ranger/sql/normal/20.sql
new file mode 100644
index 0000000..b0a09cc
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/20.sql
@@ -0,0 +1,3 @@
+set session role=usertest20;
+CREATE TABLE foo(i int) TABLESPACE mytblspace;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/21.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/21.sql b/src/test/feature/Ranger/sql/normal/21.sql
new file mode 100644
index 0000000..0816560
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/21.sql
@@ -0,0 +1,3 @@
+set session role=usertest21;
+insert into foo(i) values(1234);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/22.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/22.sql b/src/test/feature/Ranger/sql/normal/22.sql
new file mode 100644
index 0000000..b55b462
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/22.sql
@@ -0,0 +1,3 @@
+set session role=usertest22;
+drop table foo;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/23.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/23.sql b/src/test/feature/Ranger/sql/normal/23.sql
new file mode 100644
index 0000000..1552795
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/23.sql
@@ -0,0 +1,3 @@
+set session role=usertest23;
+drop tablespace mytblspace;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/24.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/24.sql b/src/test/feature/Ranger/sql/normal/24.sql
new file mode 100644
index 0000000..7be148c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/24.sql
@@ -0,0 +1,3 @@
+set session role=usertest24;
+COPY a FROM '/tmp/a.txt';
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/25.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/25.sql b/src/test/feature/Ranger/sql/normal/25.sql
new file mode 100644
index 0000000..d02f191
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/25.sql
@@ -0,0 +1,3 @@
+set session role=usertest25;
+COPY a TO STDOUT WITH DELIMITER '|';
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/26.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/26.sql b/src/test/feature/Ranger/sql/normal/26.sql
new file mode 100644
index 0000000..7faf754
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/26.sql
@@ -0,0 +1,3 @@
+set session role=usertest26;
+CREATE EXTERNAL TABLE ext_t ( N_NATIONKEY INTEGER ,N_NAME CHAR(25), N_REGIONKEY  INTEGER ,N_COMMENT    VARCHAR(152))location ('gpfdist://localhost:7070/nation_error50.tbl')FORMAT 'text' (delimiter '|')SEGMENT REJECT LIMIT 51;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/27.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/27.sql b/src/test/feature/Ranger/sql/normal/27.sql
new file mode 100644
index 0000000..4f8707b
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/27.sql
@@ -0,0 +1,3 @@
+set session role=usertest27;
+select * from ext_t order by N_NATIONKEY;   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/28.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/28.sql b/src/test/feature/Ranger/sql/normal/28.sql
new file mode 100644
index 0000000..77b0359
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/28.sql
@@ -0,0 +1,3 @@
+set session role=usertest28;
+CREATE WRITABLE EXTERNAL TABLE ext_t2 (i int) LOCATION ('gpfdist://localhost:7070/ranger2.out') FORMAT 'TEXT' ( DELIMITER '|' NULL ' ');
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/29.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/29.sql b/src/test/feature/Ranger/sql/normal/29.sql
new file mode 100644
index 0000000..b3a7902
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/29.sql
@@ -0,0 +1,3 @@
+set session role=usertest29;
+insert into ext_t2(i) values(234);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/3.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/3.sql b/src/test/feature/Ranger/sql/normal/3.sql
new file mode 100644
index 0000000..30e7f5c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/3.sql
@@ -0,0 +1,3 @@
+set session role=usertest3;
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/30.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/30.sql b/src/test/feature/Ranger/sql/normal/30.sql
new file mode 100644
index 0000000..2c455bc
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/30.sql
@@ -0,0 +1,3 @@
+set session role=usertest30;
+drop EXTERNAL TABLE ext_t;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/31.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/31.sql b/src/test/feature/Ranger/sql/normal/31.sql
new file mode 100644
index 0000000..b218472
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/31.sql
@@ -0,0 +1,3 @@
+set session role=usertest31;
+drop EXTERNAL TABLE ext_t2;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/32.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/32.sql b/src/test/feature/Ranger/sql/normal/32.sql
new file mode 100644
index 0000000..6cbc67c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/32.sql
@@ -0,0 +1,3 @@
+set session role=usertest32;
+create schema sa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/33.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/33.sql b/src/test/feature/Ranger/sql/normal/33.sql
new file mode 100644
index 0000000..8e86e46
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/33.sql
@@ -0,0 +1,3 @@
+set session role=usertest33;
+create temp table ta(i int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/34.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/34.sql b/src/test/feature/Ranger/sql/normal/34.sql
new file mode 100644
index 0000000..c943817
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/34.sql
@@ -0,0 +1,3 @@
+set session role=usertest34;
+create view av as select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/35.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/35.sql b/src/test/feature/Ranger/sql/normal/35.sql
new file mode 100644
index 0000000..39288f6
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/35.sql
@@ -0,0 +1,3 @@
+set session role=usertest35;
+create table aa as select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/36.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/36.sql b/src/test/feature/Ranger/sql/normal/36.sql
new file mode 100644
index 0000000..2c6e709
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/36.sql
@@ -0,0 +1,3 @@
+set session role=usertest36;
+create table sa.t(a int, b int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/37.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/37.sql b/src/test/feature/Ranger/sql/normal/37.sql
new file mode 100644
index 0000000..e25808d
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/37.sql
@@ -0,0 +1,3 @@
+set session role=usertest37;
+CREATE SEQUENCE myseq START 1;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/38.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/38.sql b/src/test/feature/Ranger/sql/normal/38.sql
new file mode 100644
index 0000000..7669aa6
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/38.sql
@@ -0,0 +1,3 @@
+set session role=usertest38;
+insert into a values(1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/39.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/39.sql b/src/test/feature/Ranger/sql/normal/39.sql
new file mode 100644
index 0000000..a211d00
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/39.sql
@@ -0,0 +1,3 @@
+set session role=usertest39;
+insert into a values(1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/4.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/4.sql b/src/test/feature/Ranger/sql/normal/4.sql
new file mode 100644
index 0000000..25b8c3e
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/4.sql
@@ -0,0 +1,3 @@
+set session role=usertest4;
+select * from f4();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/40.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/40.sql b/src/test/feature/Ranger/sql/normal/40.sql
new file mode 100644
index 0000000..cb0ca4a
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/40.sql
@@ -0,0 +1,3 @@
+set session role=usertest40;
+insert into a VALUES (nextval('myseq'));
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/41.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/41.sql b/src/test/feature/Ranger/sql/normal/41.sql
new file mode 100644
index 0000000..57bb612
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/41.sql
@@ -0,0 +1,3 @@
+set session role=usertest41;
+select * from a order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/42.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/42.sql b/src/test/feature/Ranger/sql/normal/42.sql
new file mode 100644
index 0000000..73dee45
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/42.sql
@@ -0,0 +1,3 @@
+set session role=usertest42;
+select generate_series(1,3);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/43.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/43.sql b/src/test/feature/Ranger/sql/normal/43.sql
new file mode 100644
index 0000000..07576a8
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/43.sql
@@ -0,0 +1,3 @@
+set session role=usertest43;
+select * from av;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/44.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/44.sql b/src/test/feature/Ranger/sql/normal/44.sql
new file mode 100644
index 0000000..336b7c5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/44.sql
@@ -0,0 +1,3 @@
+set session role=usertest44;
+SELECT setval('myseq', 1);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/45.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/45.sql b/src/test/feature/Ranger/sql/normal/45.sql
new file mode 100644
index 0000000..78befd1
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/45.sql
@@ -0,0 +1,3 @@
+set session role=usertest45;
+SELECT * INTO aaa FROM a WHERE i > 0 order by i;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/46.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/46.sql b/src/test/feature/Ranger/sql/normal/46.sql
new file mode 100644
index 0000000..e40a5b2
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/46.sql
@@ -0,0 +1,3 @@
+set session role=usertest46;
+PREPARE fooplan (int) AS INSERT INTO a VALUES($1);EXECUTE fooplan(1);DEALLOCATE fooplan;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/47.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/47.sql b/src/test/feature/Ranger/sql/normal/47.sql
new file mode 100644
index 0000000..9955c57
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/47.sql
@@ -0,0 +1,3 @@
+set session role=usertest47;
+explain select * from a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/48.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/48.sql b/src/test/feature/Ranger/sql/normal/48.sql
new file mode 100644
index 0000000..0b288fc
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/48.sql
@@ -0,0 +1,3 @@
+set session role=usertest48;
+CREATE FUNCTION scube_accum(numeric, numeric) RETURNS numeric AS 'select $1 + $2 * $2 * $2' LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/49.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/49.sql b/src/test/feature/Ranger/sql/normal/49.sql
new file mode 100644
index 0000000..08dd254
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/49.sql
@@ -0,0 +1,3 @@
+set session role=usertest49;
+CREATE AGGREGATE scube(numeric) ( SFUNC = scube_accum, STYPE = numeric, INITCOND = 0 );
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/5.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/5.sql b/src/test/feature/Ranger/sql/normal/5.sql
new file mode 100644
index 0000000..0d994c4
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/5.sql
@@ -0,0 +1,3 @@
+set session role=usertest5;
+drop function f4();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/50.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/50.sql b/src/test/feature/Ranger/sql/normal/50.sql
new file mode 100644
index 0000000..2ba3d49
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/50.sql
@@ -0,0 +1,3 @@
+set session role=usertest50;
+ALTER AGGREGATE scube(numeric) RENAME TO scube2;   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/51.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/51.sql b/src/test/feature/Ranger/sql/normal/51.sql
new file mode 100644
index 0000000..11a0cd7
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/51.sql
@@ -0,0 +1,3 @@
+set session role=usertest51;
+DROP AGGREGATE scube2(numeric);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/52.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/52.sql b/src/test/feature/Ranger/sql/normal/52.sql
new file mode 100644
index 0000000..a35aa9d
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/52.sql
@@ -0,0 +1,3 @@
+set session role=usertest52;
+DROP FUNCTION scube_accum(numeric, numeric);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/53.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/53.sql b/src/test/feature/Ranger/sql/normal/53.sql
new file mode 100644
index 0000000..bac2fae
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/53.sql
@@ -0,0 +1,3 @@
+set session role=usertest53;
+CREATE TYPE mytype AS (f1 int, f2 int);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/54.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/54.sql b/src/test/feature/Ranger/sql/normal/54.sql
new file mode 100644
index 0000000..0400efa
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/54.sql
@@ -0,0 +1,3 @@
+set session role=usertest54;
+CREATE FUNCTION getfoo() RETURNS SETOF mytype AS $$ SELECT i, i FROM a order by i $$ LANGUAGE SQL;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/55.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/55.sql b/src/test/feature/Ranger/sql/normal/55.sql
new file mode 100644
index 0000000..736b763
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/55.sql
@@ -0,0 +1,3 @@
+set session role=usertest55;
+select getfoo();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/56.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/56.sql b/src/test/feature/Ranger/sql/normal/56.sql
new file mode 100644
index 0000000..364990f
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/56.sql
@@ -0,0 +1,3 @@
+set session role=usertest56;
+drop type mytype cascade;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/57.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/57.sql b/src/test/feature/Ranger/sql/normal/57.sql
new file mode 100644
index 0000000..c15fab7
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/57.sql
@@ -0,0 +1,3 @@
+set session role=usertest57;
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/58.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/58.sql b/src/test/feature/Ranger/sql/normal/58.sql
new file mode 100644
index 0000000..6f80c61
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/58.sql
@@ -0,0 +1,3 @@
+set session role=usertest58;
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/59.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/59.sql b/src/test/feature/Ranger/sql/normal/59.sql
new file mode 100644
index 0000000..84aaed5
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/59.sql
@@ -0,0 +1,3 @@
+set session role=usertest59;
+\d
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/6.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/6.sql b/src/test/feature/Ranger/sql/normal/6.sql
new file mode 100644
index 0000000..869fbba
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/6.sql
@@ -0,0 +1,3 @@
+set session role=usertest6;
+drop language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/60.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/60.sql b/src/test/feature/Ranger/sql/normal/60.sql
new file mode 100644
index 0000000..1ac8008
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/60.sql
@@ -0,0 +1,3 @@
+set session role=usertest60;
+analyze a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/61.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/61.sql b/src/test/feature/Ranger/sql/normal/61.sql
new file mode 100644
index 0000000..e133a98
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/61.sql
@@ -0,0 +1,3 @@
+set session role=usertest61;
+analyze;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/62.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/62.sql b/src/test/feature/Ranger/sql/normal/62.sql
new file mode 100644
index 0000000..5fa3659
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/62.sql
@@ -0,0 +1,3 @@
+set session role=usertest62;
+vacuum aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/63.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/63.sql b/src/test/feature/Ranger/sql/normal/63.sql
new file mode 100644
index 0000000..d480630
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/63.sql
@@ -0,0 +1,3 @@
+set session role=usertest63;
+vacuum analyze;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/64.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/64.sql b/src/test/feature/Ranger/sql/normal/64.sql
new file mode 100644
index 0000000..26aca9e
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/64.sql
@@ -0,0 +1,3 @@
+set session role=usertest64;
+truncate aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/65.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/65.sql b/src/test/feature/Ranger/sql/normal/65.sql
new file mode 100644
index 0000000..6db582c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/65.sql
@@ -0,0 +1,3 @@
+set session role=usertest65;
+alter table a rename column i to j;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/66.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/66.sql b/src/test/feature/Ranger/sql/normal/66.sql
new file mode 100644
index 0000000..7637754
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/66.sql
@@ -0,0 +1,3 @@
+set session role=usertest66;
+drop SEQUENCE myseq;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/67.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/67.sql b/src/test/feature/Ranger/sql/normal/67.sql
new file mode 100644
index 0000000..a88a61f
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/67.sql
@@ -0,0 +1,3 @@
+set session role=usertest67;
+drop view av;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/68.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/68.sql b/src/test/feature/Ranger/sql/normal/68.sql
new file mode 100644
index 0000000..cc322ad
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/68.sql
@@ -0,0 +1,3 @@
+set session role=usertest68;
+drop table aaa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/69.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/69.sql b/src/test/feature/Ranger/sql/normal/69.sql
new file mode 100644
index 0000000..d252050
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/69.sql
@@ -0,0 +1,3 @@
+set session role=usertest69;
+drop table aa;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/7.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/7.sql b/src/test/feature/Ranger/sql/normal/7.sql
new file mode 100644
index 0000000..47ebd4b
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/7.sql
@@ -0,0 +1,3 @@
+set session role=usertest7;
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/70.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/70.sql b/src/test/feature/Ranger/sql/normal/70.sql
new file mode 100644
index 0000000..620cc97
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/70.sql
@@ -0,0 +1,3 @@
+set session role=usertest70;
+drop table a;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/71.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/71.sql b/src/test/feature/Ranger/sql/normal/71.sql
new file mode 100644
index 0000000..a0600ca
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/71.sql
@@ -0,0 +1,3 @@
+set session role=usertest71;
+drop schema sa CASCADE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/8.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/8.sql b/src/test/feature/Ranger/sql/normal/8.sql
new file mode 100644
index 0000000..cf1ddf8
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/8.sql
@@ -0,0 +1,3 @@
+set session role=usertest8;
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/normal/9.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/normal/9.sql b/src/test/feature/Ranger/sql/normal/9.sql
new file mode 100644
index 0000000..b001581
--- /dev/null
+++ b/src/test/feature/Ranger/sql/normal/9.sql
@@ -0,0 +1,3 @@
+set session role=usertest9;
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/sqlsplit.cpp
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/sqlsplit.cpp b/src/test/feature/Ranger/sql/sqlsplit.cpp
new file mode 100644
index 0000000..61ea00e
--- /dev/null
+++ b/src/test/feature/Ranger/sql/sqlsplit.cpp
@@ -0,0 +1,92 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ * 
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+#include <stdio.h>
+#include <stdlib.h>
+#include <string.h>
+
+int main() {
+    FILE *fin, *fout, *foutsuper;
+    fin = fopen("sqlsplitinput", "r");
+    char line[1000];
+    int i = 0;
+    int isnormalquery = 0;
+    while (fscanf(fin, "%d\n", &isnormalquery) && fgets(line, 1000, fin) != NULL) {
+        i++;
+
+        char sqlname[100];
+		sprintf(sqlname, "normal/%d.sql", i);
+		fout = fopen(sqlname, "w");
+    	fprintf(fout, "set session role=usertest%d;\n", i);
+    	fprintf(fout, "%s\n", line);
+    	fclose(fout);
+
+    	{
+    	char sqlname[100];
+		sprintf(sqlname, "../ans/normal%d_fail.ans", i);
+		fout = fopen(sqlname, "w");
+		fclose(fout);
+    	}
+
+    	{
+		char sqlname[100];
+		sprintf(sqlname, "../ans/super%d_fail.ans", i);
+		fout = fopen(sqlname, "w");
+		fclose(fout);
+		}
+
+    	{
+		char sqlname[100];
+		sprintf(sqlname, "../ans/normal%d_success.ans", i);
+		fout = fopen(sqlname, "w");
+		fclose(fout);
+		}
+
+		{
+		char sqlname[100];
+		sprintf(sqlname, "../ans/super%d_success.ans", i);
+		fout = fopen(sqlname, "w");
+		fclose(fout);
+		}
+    	{
+    	    	char sqlname[100];
+    			sprintf(sqlname, "../ans/admin%d.ans", i);
+    			fout = fopen(sqlname, "w");
+    			fclose(fout);
+    	    	}
+
+
+
+        if (!isnormalquery){
+        	char sqlnamesuper[100];
+			sprintf(sqlnamesuper, "super/%d.sql", i);
+			foutsuper = fopen(sqlnamesuper, "w");
+			fprintf(foutsuper, "set session role=usersuper%d;\n", i);
+			fprintf(foutsuper, "%s\n", line);
+			fclose(foutsuper);
+        }
+
+        char sqlnameadmin[100];
+		sprintf(sqlnameadmin, "admin/%d.sql", i);
+		fout = fopen(sqlnameadmin, "w");
+		fprintf(fout, "%s\n", line);
+		fclose(fout);
+    }
+    fclose(fin);
+}

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/sqlsplitinput
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/sqlsplitinput b/src/test/feature/Ranger/sql/sqlsplitinput
new file mode 100644
index 0000000..564b0a0
--- /dev/null
+++ b/src/test/feature/Ranger/sql/sqlsplitinput
@@ -0,0 +1,142 @@
+1
+create table a(i int);
+0
+create language plpythonu;
+0
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+1
+select * from f4();
+0
+drop function f4();
+0
+drop language plpythonu;
+1
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+1
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+1
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+1
+CREATE OR REPLACE FUNCTION si_same(text, text) RETURNS int AS $$ BEGIN IF normalize_si($1) < normalize_si($2) THEN RETURN -1; END IF; END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+0
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+0
+drop OPERATOR CLASS sva_special_ops USING btree;
+1
+drop OPERATOR <# (text,text) CASCADE;
+1
+drop FUNCTION si_same(text, text);
+1
+drop FUNCTION si_lt(text, text);
+1
+drop FUNCTION normalize_si(text);
+0
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);   
+0
+DROP RESOURCE QUEUE myqueue;
+0
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;    
+1
+CREATE TABLE foo(i int) TABLESPACE mytblspace;
+1
+insert into foo(i) values(1234);
+1
+drop table foo;
+0
+drop tablespace mytblspace;
+0
+COPY a FROM '/tmp/a.txt';
+1
+COPY a TO STDOUT WITH DELIMITER '|';
+1
+CREATE EXTERNAL TABLE ext_t ( N_NATIONKEY INTEGER ,N_NAME CHAR(25), N_REGIONKEY  INTEGER ,N_COMMENT    VARCHAR(152))location ('gpfdist://localhost:7070/nation_error50.tbl')FORMAT 'text' (delimiter '|')SEGMENT REJECT LIMIT 51;
+1
+select * from ext_t order by N_NATIONKEY;   
+1
+CREATE WRITABLE EXTERNAL TABLE ext_t2 (i int) LOCATION ('gpfdist://localhost:7070/ranger2.out') FORMAT 'TEXT' ( DELIMITER '|' NULL ' ');
+1
+insert into ext_t2(i) values(234);
+1
+drop EXTERNAL TABLE ext_t;
+1
+drop EXTERNAL TABLE ext_t2;
+1
+create schema sa;
+1
+create temp table ta(i int);
+1
+create view av as select * from a order by i;
+1
+create table aa as select * from a order by i;
+1
+create table sa.t(a int, b int);
+1
+CREATE SEQUENCE myseq START 1;
+1
+insert into a values(1);
+1
+insert into a values(1);
+1
+insert into a VALUES (nextval('myseq'));
+1
+select * from a order by i;
+1
+select generate_series(1,3);
+1
+select * from av;
+1
+SELECT setval('myseq', 1);
+1
+SELECT * INTO aaa FROM a WHERE i > 0 order by i;
+1
+PREPARE fooplan (int) AS INSERT INTO a VALUES($1);EXECUTE fooplan(1);DEALLOCATE fooplan;
+1
+explain select * from a;
+1
+CREATE FUNCTION scube_accum(numeric, numeric) RETURNS numeric AS 'select $1 + $2 * $2 * $2' LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT;
+1
+CREATE AGGREGATE scube(numeric) ( SFUNC = scube_accum, STYPE = numeric, INITCOND = 0 );
+1
+ALTER AGGREGATE scube(numeric) RENAME TO scube2;   
+1
+DROP AGGREGATE scube2(numeric);
+1
+DROP FUNCTION scube_accum(numeric, numeric);
+1
+CREATE TYPE mytype AS (f1 int, f2 int);
+1
+CREATE FUNCTION getfoo() RETURNS SETOF mytype AS $$ SELECT i, i FROM a order by i $$ LANGUAGE SQL;
+1
+select getfoo();
+1
+drop type mytype cascade;
+1
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+1
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+1
+\d
+1
+analyze a;
+1
+analyze;
+1
+vacuum aa;
+0
+vacuum analyze;
+1
+truncate aa;
+1
+alter table a rename column i to j;
+1
+drop SEQUENCE myseq;
+1
+drop view av;
+1
+drop table aaa;
+1
+drop table aa;
+1
+drop table a;
+1
+drop schema sa CASCADE;

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/11.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/11.sql b/src/test/feature/Ranger/sql/super/11.sql
new file mode 100644
index 0000000..dc1ebf7
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/11.sql
@@ -0,0 +1,3 @@
+set session role=usersuper11;
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/12.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/12.sql b/src/test/feature/Ranger/sql/super/12.sql
new file mode 100644
index 0000000..1caae8e
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/12.sql
@@ -0,0 +1,3 @@
+set session role=usersuper12;
+drop OPERATOR CLASS sva_special_ops USING btree;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/17.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/17.sql b/src/test/feature/Ranger/sql/super/17.sql
new file mode 100644
index 0000000..798e037
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/17.sql
@@ -0,0 +1,3 @@
+set session role=usersuper17;
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);   
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/18.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/18.sql b/src/test/feature/Ranger/sql/super/18.sql
new file mode 100644
index 0000000..e725d6f
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/18.sql
@@ -0,0 +1,3 @@
+set session role=usersuper18;
+DROP RESOURCE QUEUE myqueue;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/19.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/19.sql b/src/test/feature/Ranger/sql/super/19.sql
new file mode 100644
index 0000000..8de36b0
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/19.sql
@@ -0,0 +1,3 @@
+set session role=usersuper19;
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;    
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/2.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/2.sql b/src/test/feature/Ranger/sql/super/2.sql
new file mode 100644
index 0000000..0ae854c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/2.sql
@@ -0,0 +1,3 @@
+set session role=usersuper2;
+create language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/23.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/23.sql b/src/test/feature/Ranger/sql/super/23.sql
new file mode 100644
index 0000000..f83c498
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/23.sql
@@ -0,0 +1,3 @@
+set session role=usersuper23;
+drop tablespace mytblspace;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/24.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/24.sql b/src/test/feature/Ranger/sql/super/24.sql
new file mode 100644
index 0000000..113c6fe
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/24.sql
@@ -0,0 +1,3 @@
+set session role=usersuper24;
+COPY a FROM '/tmp/a.txt';
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/3.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/3.sql b/src/test/feature/Ranger/sql/super/3.sql
new file mode 100644
index 0000000..fd1377c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/3.sql
@@ -0,0 +1,3 @@
+set session role=usersuper3;
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/5.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/5.sql b/src/test/feature/Ranger/sql/super/5.sql
new file mode 100644
index 0000000..a95e012
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/5.sql
@@ -0,0 +1,3 @@
+set session role=usersuper5;
+drop function f4();
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/6.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/6.sql b/src/test/feature/Ranger/sql/super/6.sql
new file mode 100644
index 0000000..9dd3a0c
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/6.sql
@@ -0,0 +1,3 @@
+set session role=usersuper6;
+drop language plpythonu;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/sql/super/63.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/sql/super/63.sql b/src/test/feature/Ranger/sql/super/63.sql
new file mode 100644
index 0000000..463ce54
--- /dev/null
+++ b/src/test/feature/Ranger/sql/super/63.sql
@@ -0,0 +1,3 @@
+set session role=usersuper63;
+vacuum analyze;
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/test_ranger.cpp
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/test_ranger.cpp b/src/test/feature/Ranger/test_ranger.cpp
new file mode 100644
index 0000000..1d9f08e
--- /dev/null
+++ b/src/test/feature/Ranger/test_ranger.cpp
@@ -0,0 +1,159 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ * 
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+#include "test_ranger.h"
+
+#include <string>
+#include <pwd.h>
+
+#include "lib/command.h"
+#include "lib/gpfdist.h"
+#include "lib/sql_util.h"
+#include "lib/string_util.h"
+
+using std::vector;
+using std::string;
+using hawq::test::SQLUtility;
+using hawq::test::Command;
+
+TEST_F(TestHawqRanger, BasicTest) {
+    SQLUtility util;
+
+    if (util.getGUCValue("hawq_acl_type") == "ranger")
+    {
+		hawq::test::GPfdist gpdfist(&util);
+		gpdfist.init_gpfdist();
+
+		string rootPath(util.getTestRootPath());
+		string initfile = hawq::test::stringFormat("Ranger/sql/init_file");
+		auto cmd = hawq::test::stringFormat("ls -l %s/Ranger/sql/normal/*.sql 2>/dev/null | wc -l", rootPath.c_str());
+		int sql_num = std::atoi(Command::getCommandOutput(cmd).c_str());
+		int writableTableCase = 28;
+		string rangerHost = RANGER_HOST;
+		cmd = hawq::test::stringFormat("cp %s/Ranger/data/copydata.txt /tmp/a.txt", rootPath.c_str());
+		Command::getCommandStatus(cmd);
+
+		// clear environment
+		for (int i = 1; i <= sql_num; i++) {
+			// delete user_num
+			std::string normalusername = hawq::test::stringFormat("usertest%d", i);
+			std::string superusername = hawq::test::stringFormat("usersuper%d", i);
+			util.execute(hawq::test::stringFormat("drop role %s;",normalusername.c_str()), false);
+			util.execute(hawq::test::stringFormat("drop role %s;",superusername.c_str()), false);
+			// delete policy
+			std::string cmd = hawq::test::stringFormat("ls -l %s/Ranger/policy/%d/ 2>/dev/null| grep \"^-\" | wc -l ", rootPath.c_str(), i);
+			int policy_num = std::atoi(Command::getCommandOutput(cmd).c_str());
+			for (int j = 1; j <= policy_num; j++) {
+				cmd = hawq::test::stringFormat("python %s/Ranger/rangerpolicy.py -h %s -d policy%d-%d", rootPath.c_str(), rangerHost.c_str(), i, j);
+				Command::getCommandStatus(cmd);
+			}
+		}
+
+		for (int i = 1; i <= sql_num; i++) {
+			// create user_num
+			std::string superusername = hawq::test::stringFormat("usersuper%d", i);;
+			std::string normalusername = hawq::test::stringFormat("usertest%d", i);;
+			util.execute(hawq::test::stringFormat("create role %s with login createdb superuser;", superusername.c_str()),true);
+			if(i == writableTableCase) { //for writable external table
+				util.execute(hawq::test::stringFormat("create role %s with login createdb CREATEEXTTABLE(type='writable') CREATEROLE;", normalusername.c_str()),true);
+			}
+			else {
+				util.execute(hawq::test::stringFormat("create role %s with login createdb CREATEEXTTABLE CREATEROLE;", normalusername.c_str()),true);
+			}
+			cmd = hawq::test::stringFormat("python %s/Ranger/rangeruser.py -h %s -u %s,%s", rootPath.c_str(),
+					rangerHost.c_str(),normalusername.c_str(), superusername.c_str());
+			Command::getCommandStatus(cmd);
+
+			//run sql by different users
+			string normal_sqlfile = hawq::test::stringFormat("Ranger/sql/normal/%d.sql", i);
+			string super_sqlfile = hawq::test::stringFormat("Ranger/sql/super/%d.sql", i);
+			string admin_sqlfile = hawq::test::stringFormat("Ranger/sql/admin/%d.sql", i);
+			string normal_ansfile_fail = hawq::test::stringFormat("Ranger/ans/normal%d_fail.ans", i);
+			string super_ansfile_fail = hawq::test::stringFormat("Ranger/ans/super%d_fail.ans", i);
+			string admin_ansfile = hawq::test::stringFormat("Ranger/ans/adminfirst%d.ans", i);
+
+			cmd = hawq::test::stringFormat("ls -l %s/Ranger/policy/%d/ 2>/dev/null| wc -l", rootPath.c_str(), i);
+			int policy_num = std::atoi(Command::getCommandOutput(cmd).c_str());
+
+			cmd = hawq::test::stringFormat("ls -l %s/Ranger/sql/super/%d.sql 2>/dev/null| wc -l", rootPath.c_str(), i);
+			int supersqlexist = std::atoi(Command::getCommandOutput(cmd).c_str());
+
+			if (policy_num > 0){
+				if (supersqlexist) {
+					util.execSQLFile(super_sqlfile, super_ansfile_fail, initfile, true, true);
+				}
+				else {
+					util.execSQLFile(normal_sqlfile, normal_ansfile_fail, initfile, true, true);
+				}
+			}
+
+			util.execSQLFile(admin_sqlfile, admin_ansfile, initfile, true, true);
+
+
+			for (int j = 1; j <= policy_num; j++) {
+				cmd = hawq::test::stringFormat("python %s/Ranger/rangerpolicy.py -h %s -a %s/Ranger/policy/%d/%d.json", rootPath.c_str(), rangerHost.c_str(), rootPath.c_str(), i, j);
+				Command::getCommandStatus(cmd);
+			}
+		}
+		sleep(60);
+
+
+		for (int i = 1; i <= sql_num; i++) {
+			//run sql by different users
+			string normal_sqlfile = hawq::test::stringFormat("Ranger/sql/normal/%d.sql", i);
+			string super_sqlfile = hawq::test::stringFormat("Ranger/sql/super/%d.sql", i);
+			string normal_ansfile_success = hawq::test::stringFormat("Ranger/ans/normal%d_success.ans", i);
+			string super_ansfile_success = hawq::test::stringFormat("Ranger/ans/super%d_success.ans", i);
+
+
+			cmd = hawq::test::stringFormat("ls -l %s/Ranger/policy/%d/ 2>/dev/null| wc -l", rootPath.c_str(), i);
+			int policy_num = std::atoi(Command::getCommandOutput(cmd).c_str());
+			cmd = hawq::test::stringFormat("ls -l %s/Ranger/sql/super/%d.sql 2>/dev/null | wc -l", rootPath.c_str(), i);
+			int supersqlexist = std::atoi(Command::getCommandOutput(cmd).c_str());
+			util.execSQLFile(normal_sqlfile, normal_ansfile_success, initfile, true, true);
+			if (supersqlexist) {
+				util.execSQLFile(super_sqlfile, super_ansfile_success, initfile, true, true);
+			}
+		}
+
+		//using gpadmin to clear database environment.
+		for (int i = 1; i <= sql_num; i++) {
+			string admin_sqlfile = hawq::test::stringFormat("Ranger/sql/admin/%d.sql", i);
+			string admin_ansfile = hawq::test::stringFormat("Ranger/ans/adminsecond%d.ans", i);
+			util.execSQLFile(admin_sqlfile, admin_ansfile, initfile, true, true);
+		}
+
+		for (int i = 1; i <= sql_num; i++) {
+			// delete user_num
+			std::string normalusername = hawq::test::stringFormat("usertest%d", i);
+			std::string superusername = hawq::test::stringFormat("usersuper%d", i);
+			util.execute(hawq::test::stringFormat("drop role %s;",normalusername.c_str()), false);
+			util.execute(hawq::test::stringFormat("drop role %s;",superusername.c_str()), false);
+			// delete policy
+			std::string cmd = hawq::test::stringFormat("ls -l %s/Ranger/policy/%d/ 2>/dev/null | wc -l", rootPath.c_str(), i);
+			int policy_num = std::atoi(Command::getCommandOutput(cmd).c_str());
+			for (int j = 1; j <= policy_num; j++) {
+				cmd = hawq::test::stringFormat("python %s/Ranger/rangerpolicy.py -h %s -d policy%d-%d", rootPath.c_str(), rangerHost.c_str(), i, j);
+				Command::getCommandStatus(cmd);
+			}
+		}
+
+		gpdfist.finalize_gpfdist();
+    }
+}

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/test_ranger.h
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/test_ranger.h b/src/test/feature/Ranger/test_ranger.h
new file mode 100644
index 0000000..a12a71a
--- /dev/null
+++ b/src/test/feature/Ranger/test_ranger.h
@@ -0,0 +1,33 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ * 
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+#ifndef TEST_HAWQ_RANGER_H
+#define TEST_HAWQ_RANGER_H
+
+#include "gtest/gtest.h"
+
+class TestHawqRanger : public ::testing::Test {
+public:
+	TestHawqRanger() {
+	}
+	~TestHawqRanger() {
+	}
+};
+
+#endif

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/lib/gpfdist.cpp
----------------------------------------------------------------------
diff --git a/src/test/feature/lib/gpfdist.cpp b/src/test/feature/lib/gpfdist.cpp
index fbd4cf1..b3f24aa 100644
--- a/src/test/feature/lib/gpfdist.cpp
+++ b/src/test/feature/lib/gpfdist.cpp
@@ -52,13 +52,6 @@ void GPfdist::init_gpfdist() {
 }
 
 void GPfdist::finalize_gpfdist() {
-	util->execute("drop external table EXT_NATION_WITH_EXIST_ERROR_TABLE;");
-	util->execute("drop external table EXT_NATION1;");
-	util->execute("drop table EXT_NATION_ERROR1 CASCADE;");
-	util->execute("drop external table EXT_NATION2;");
-	util->execute("drop table EXT_NATION_ERROR2 CASCADE;");
-	util->execute("drop external table EXT_NATION3;");
-	util->execute("drop table EXT_NATION_ERROR3 CASCADE;");
 	util->execute("select * from gpfdist_stop;");
 	util->execute("select * from gpfdist_status;");
 	util->execute("drop external table gpfdist_status;");

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/lib/psql.cpp
----------------------------------------------------------------------
diff --git a/src/test/feature/lib/psql.cpp b/src/test/feature/lib/psql.cpp
index b448198..0e71d56 100644
--- a/src/test/feature/lib/psql.cpp
+++ b/src/test/feature/lib/psql.cpp
@@ -106,9 +106,9 @@ PSQL& PSQL::runSQLCommand(const string& sql_cmd) {
   return *this;
 }
 
-PSQL& PSQL::runSQLFile(const string& sql_file) {
+PSQL& PSQL::runSQLFile(const string& sql_file, bool printTupleOnly) {
   this->_last_status =
-      hawq::test::Command::getCommandStatus(this->_getPSQLFileCommand(sql_file));
+      hawq::test::Command::getCommandStatus(this->_getPSQLFileCommand(sql_file, printTupleOnly));
   return *this;
 }
 
@@ -210,9 +210,14 @@ const string PSQL::_getPSQLQueryCommand(const string& query) const {
   return command.append(" -c \"").append(query).append("\"");
 }
 
-const string PSQL::_getPSQLFileCommand(const string& file) const {
+const string PSQL::_getPSQLFileCommand(const string& file, bool printTupleOnly) const {
   string command = this->_getPSQLBaseCommand();
-  return command.append(" -a -f ").append(file);
+  if (printTupleOnly) {
+	  return command.append(" -a -A -t -f").append(file);
+  }
+  else {
+	  return command.append(" -a -f ").append(file);
+  }
 }
 
 bool PSQL::checkDiff(const string& expect_file,



Mime
View raw message