trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [10/14] incubator-trafodion git commit: update seabase/TEST028.
Date Mon, 21 Sep 2015 23:12:25 GMT
update seabase/TEST028.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/3b293592
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/3b293592
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/3b293592

Branch: refs/heads/master
Commit: 3b293592ba101f0b9e87af978ded129c7a219311
Parents: 052b3bb
Author: Qifan Chen <qfc@dev02.trafodion.org>
Authored: Mon Sep 21 00:28:39 2015 +0000
Committer: Qifan Chen <qfc@dev02.trafodion.org>
Committed: Mon Sep 21 00:28:39 2015 +0000

----------------------------------------------------------------------
 core/sql/regress/seabase/EXPECTED028       | 32 ++++++-------------------
 core/sql/regress/seabase/TEST028           | 31 ++++--------------------
 core/sql/regress/tools/runregr_seabase.ksh |  4 ++--
 3 files changed, 13 insertions(+), 54 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b293592/core/sql/regress/seabase/EXPECTED028
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED028 b/core/sql/regress/seabase/EXPECTED028
index c84e4f2..c57b16c 100644
--- a/core/sql/regress/seabase/EXPECTED028
+++ b/core/sql/regress/seabase/EXPECTED028
@@ -3,7 +3,7 @@
 
 --- SQL operation complete.
 >>
->>insert into hbase."_CELL_".t028tbl1 values 
+>>insert into hbase."_CELL_".t028tbl1 values
 +>('0', 'cf', '1a', -1, '2'),
 +>('1', 'cf', '1a', -1, '102'),
 +>('2', 'cf', '1a', -1, '202'),
@@ -16,6 +16,10 @@
 
 --- 9 row(s) inserted.
 >>
+>>exit;
+
+End of MXCI Session
+
 >>
 >>cqd  USTAT_INTERNAL_SORT 'off';
 
@@ -23,13 +27,12 @@
 >>update statistics for table hbase."_CELL_".t028tbl1 on every column;
 
 --- SQL operation complete.
->>
 >>showstats for table hbase."_CELL_".t028tbl1 on ROW_ID detail;
 
 Detailed Histogram data for Table HBASE."_CELL_".T028TBL1
-Table ID: 6047285781859643730
+Table ID: 378379789629904219
 
-Hist ID:    1955006841
+Hist ID:    2022909903
 Column(s):  ROW_ID
 Total Rows: 9
 Total UEC:  9
@@ -52,26 +55,6 @@ Number    Rowcount         UEC Boundary
 
 
 --- SQL operation complete.
->>showstats for table hbase."_CELL_".t028tbl1 on COL_FAMILY detail;
-
-Detailed Histogram data for Table HBASE."_CELL_".T028TBL1
-Table ID: 6047285781859643730
-
-Hist ID:    1955006834
-Column(s):  COL_FAMILY
-Total Rows: 9
-Total UEC:  1
-Low Value:  ('cf')
-High Value: ('cf')
-Intervals:  1
-
-Number    Rowcount         UEC Boundary
-====== =========== =========== ======================================
-     0           0           0 ('cf')
-     1           9           1 ('cf')
-
-
---- SQL operation complete.
 >>
 >>explain options 'f' select * from hbase."_CELL_".t028tbl1;
 
@@ -95,7 +78,6 @@ LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
 >>drop hbase table t028tbl1;
 
 --- SQL operation complete.
->>
 >>exit;
 
 End of MXCI Session

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b293592/core/sql/regress/seabase/TEST028
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/TEST028 b/core/sql/regress/seabase/TEST028
index edfd58b..d114e06 100644
--- a/core/sql/regress/seabase/TEST028
+++ b/core/sql/regress/seabase/TEST028
@@ -21,34 +21,11 @@
 --
 -- @@@ END COPYRIGHT @@@
 
+-- setup tables
+sh sqlci -i ddl.sb028;
 
-set schema hbase."_CELL_";
-drop hbase table t028tbl1;
-
-log LOG028 clear;
-
-create hbase table t028tbl1(column family 'cf');
-
-insert into hbase."_CELL_".t028tbl1 values 
-('0', 'cf', '1a', -1, '2'),
-('1', 'cf', '1a', -1, '102'),
-('2', 'cf', '1a', -1, '202'),
-('3', 'cf', '1a', -1, '302'),
-('4', 'cf', '1a', -1, '402'),
-('5', 'cf', '1a', -1, '502'),
-('6', 'cf', '1a', -1, '602'),
-('7', 'cf', '1a', -1, '702'),
-('8', 'cf', '1a', -1, '802');
-
-
-cqd  USTAT_INTERNAL_SORT 'off';
-update statistics for table hbase."_CELL_".t028tbl1 on every column;
-
-showstats for table hbase."_CELL_".t028tbl1 on ROW_ID detail;
-showstats for table hbase."_CELL_".t028tbl1 on COL_FAMILY detail;
-
-explain options 'f' select * from hbase."_CELL_".t028tbl1;
-explain options 'f' select * from hbase."_CELL_".t028tbl1 where col_family = 'cf1';
+-- do update stats 
+sh sqlci -i dml.sb028;
 
 drop hbase table t028tbl1;
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b293592/core/sql/regress/tools/runregr_seabase.ksh
----------------------------------------------------------------------
diff --git a/core/sql/regress/tools/runregr_seabase.ksh b/core/sql/regress/tools/runregr_seabase.ksh
index c3f2675..dc3d992 100755
--- a/core/sql/regress/tools/runregr_seabase.ksh
+++ b/core/sql/regress/tools/runregr_seabase.ksh
@@ -210,8 +210,8 @@ else
 fi
 
 echo "copying scripts to $REGRRUNDIR"
-cp $REGRTSTDIR/create_hbase_tables.sh $REGRRUNDIR 2>$NULL
-cp $REGRTSTDIR/drop_hbase_tables.sh $REGRRUNDIR 2>$NULL
+cp $REGRTSTDIR/ddl.sb028 $REGRRUNDIR 2>$NULL
+cp $REGRTSTDIR/dml.sb028 $REGRRUNDIR 2>$NULL
 cp $REGRTSTDIR/FILTER028 $REGRRUNDIR 2>$NULL
 
 skippedfiles=


Mime
View raw message