You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2015/09/22 01:12:25 UTC
[10/14] incubator-trafodion git commit: update seabase/TEST028.
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 <qf...@dev02.trafodion.org>
Authored: Mon Sep 21 00:28:39 2015 +0000
Committer: Qifan Chen <qf...@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=