You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2015/12/03 20:51:40 UTC
[7/9] incubator-trafodion git commit: fixes based on review comments.
fixes based on review comments.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/c73e0652
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/c73e0652
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/c73e0652
Branch: refs/heads/master
Commit: c73e0652a669ca54199f905faa68253287edb688
Parents: b4b9203
Author: Cloud User <ce...@ansharma-1.novalocal>
Authored: Tue Dec 1 23:13:48 2015 +0000
Committer: Cloud User <ce...@ansharma-1.novalocal>
Committed: Tue Dec 1 23:13:48 2015 +0000
----------------------------------------------------------------------
core/sql/comexe/ComTdbExeUtil.h | 10 +--
core/sql/executor/ExExeUtilGet.cpp | 46 ++++++++++---
core/sql/parser/ParKeyWords.cpp | 2 +-
core/sql/parser/sqlparser.y | 30 ++++++---
core/sql/regress/seabase/EXPECTED002 | 103 ++++++++++++++++++++++--------
core/sql/regress/seabase/TEST002 | 10 +++
6 files changed, 149 insertions(+), 52 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/comexe/ComTdbExeUtil.h
----------------------------------------------------------------------
diff --git a/core/sql/comexe/ComTdbExeUtil.h b/core/sql/comexe/ComTdbExeUtil.h
index b33ab5b..be1825b 100644
--- a/core/sql/comexe/ComTdbExeUtil.h
+++ b/core/sql/comexe/ComTdbExeUtil.h
@@ -3470,13 +3470,15 @@ static const ComTdbVirtTableColumnInfo comTdbRegionStatsVirtTableColumnInfo[] =
{ "WRITE_REQUESTS_COUNT", 11, COM_USER_COLUMN, REC_BIN64_SIGNED, 8, FALSE, SQLCHARSETCODE_UTF8 , 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, "",NULL,NULL, COM_UNKNOWN_DIRECTION_LIT, 0 }
};
+#define STATS_NAME_MAX_LEN 256
+#define STATS_REGION_NAME_MAX_LEN 512
struct ComTdbRegionStatsVirtTableColumnStruct
{
- char catalogName[256];
- char schemaName[256];
- char objectName[256];
+ char catalogName[STATS_NAME_MAX_LEN];
+ char schemaName[STATS_NAME_MAX_LEN];
+ char objectName[STATS_NAME_MAX_LEN];
Int64 regionNum;
- char regionName[512];
+ char regionName[STATS_REGION_NAME_MAX_LEN];
Lng32 numStores;
Lng32 numStoreFiles;
Int64 storeFileUncompSize;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index 963a999..cbf1d89 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -5404,8 +5404,8 @@ ExExeUtilRegionStatsTcb::ExExeUtilRegionStatsTcb(
tableName_ = new(glob->getDefaultHeap()) char[2000];
- // get hbase rootdir location
- hbaseRootdir_ = new(glob->getDefaultHeap()) char[1000];
+ // get hbase rootdir location. Max linux pathlength is 1024.
+ hbaseRootdir_ = new(glob->getDefaultHeap()) char[1030];
strcpy(hbaseRootdir_, "/hbase");
step_ = INITIAL_;
@@ -5708,6 +5708,25 @@ ExExeUtilRegionStatsFormatTcb::ExExeUtilRegionStatsFormatTcb(
step_ = INITIAL_;
}
+static NAString removeTrailingBlanks(char * name, Lng32 maxLen)
+{
+ NAString nas;
+
+ if (! name)
+ return nas;
+
+ Lng32 i = maxLen;
+ while ((i > 0) && (name[i-1] == ' '))
+ {
+ i--;
+ }
+
+ if (i > 0)
+ nas = NAString(name, i);
+
+ return nas;
+}
+
short ExExeUtilRegionStatsFormatTcb::initTotals()
{
statsTotals_->numStores = 0;
@@ -5724,11 +5743,14 @@ short ExExeUtilRegionStatsFormatTcb::initTotals()
short ExExeUtilRegionStatsFormatTcb::computeTotals()
{
str_pad(statsTotals_->catalogName, sizeof(statsTotals_->catalogName), ' ');
- str_cpy_and_null(statsTotals_->catalogName, catName_, strlen(catName_), '\0', ' ', TRUE);
+ str_cpy_all(statsTotals_->catalogName, catName_, strlen(catName_));
+
str_pad(statsTotals_->schemaName, sizeof(statsTotals_->schemaName), ' ');
- str_cpy_and_null(statsTotals_->schemaName, schName_, strlen(schName_), '\0', ' ', TRUE);
+ str_cpy_all(statsTotals_->schemaName, schName_, strlen(schName_));
+
str_pad(statsTotals_->objectName, sizeof(statsTotals_->objectName), ' ');
- str_cpy_and_null(statsTotals_->objectName, objName_, strlen(objName_), '\0', ' ', TRUE);
+ str_cpy_all(statsTotals_->objectName, objName_, strlen(objName_));
+
str_pad(statsTotals_->regionName, sizeof(statsTotals_->regionName), ' ');
for (Int32 currIndex = 0; currIndex < regionInfoList_->getSize(); currIndex++)
@@ -5877,11 +5899,14 @@ short ExExeUtilRegionStatsFormatTcb::work()
if (moveRowToUpQueue(buf, strlen(buf), &rc))
return rc;
- NAString objName = statsTotals_->catalogName;
+ NAString objName =
+ removeTrailingBlanks(statsTotals_->catalogName, STATS_NAME_MAX_LEN);
objName += ".";
- objName += statsTotals_->schemaName;
+ objName +=
+ removeTrailingBlanks(statsTotals_->schemaName, STATS_NAME_MAX_LEN);
objName += ".";
- objName += statsTotals_->objectName;
+ objName +=
+ removeTrailingBlanks(statsTotals_->objectName, STATS_NAME_MAX_LEN);
str_sprintf(buf, " ObjectName: %s", objName.data());
if (moveRowToUpQueue(buf, strlen(buf), &rc))
@@ -5985,7 +6010,7 @@ short ExExeUtilRegionStatsFormatTcb::work()
break;
}
- if (populateStats(currIndex_, TRUE))
+ if (populateStats(currIndex_))
{
step_ = HANDLE_ERROR_;
break;
@@ -6016,7 +6041,8 @@ short ExExeUtilRegionStatsFormatTcb::work()
if (moveRowToUpQueue(buf, strlen(buf), &rc))
return rc;
- str_sprintf(buf, " RegionName: %s", stats_->regionName);
+ str_sprintf(buf, " RegionName: %s",
+ removeTrailingBlanks(stats_->regionName, STATS_REGION_NAME_MAX_LEN).data(), TRUE);
if (moveRowToUpQueue(buf, strlen(buf), &rc))
return rc;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/parser/ParKeyWords.cpp
----------------------------------------------------------------------
diff --git a/core/sql/parser/ParKeyWords.cpp b/core/sql/parser/ParKeyWords.cpp
index 8c467ed..b46660e 100644
--- a/core/sql/parser/ParKeyWords.cpp
+++ b/core/sql/parser/ParKeyWords.cpp
@@ -1030,7 +1030,7 @@ ParKeyWord ParKeyWords::keyWords_[] = {
// used in QAT tests
ParKeyWord("STATEMENT", TOK_STATEMENT, NONRESTOKEN_),
ParKeyWord("STATIC", TOK_STATIC, NONRESTOKEN_),
- ParKeyWord("STATISTICS", TOK_STATISTICS, SECOND_|NONRESTOKEN_),
+ ParKeyWord("STATISTICS", TOK_STATISTICS, NONRESTOKEN_),
ParKeyWord("STATS", TOK_STATS, NONRESTOKEN_),
ParKeyWord("STATUS", TOK_STATUS, NONRESTOKEN_),
ParKeyWord("STDDEV", TOK_STDDEV, NONRESTOKEN_),
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/parser/sqlparser.y
----------------------------------------------------------------------
diff --git a/core/sql/parser/sqlparser.y b/core/sql/parser/sqlparser.y
index 671d0c1..fe9d74e 100755
--- a/core/sql/parser/sqlparser.y
+++ b/core/sql/parser/sqlparser.y
@@ -2783,6 +2783,7 @@ static void enableMakeQuotedStringISO88591Mechanism()
%type <relx> exe_util_cleanup_volatile_tables
%type <relx> exe_util_aqr
%type <relx> exe_util_get_region_access_stats
+%type <boolean> stats_or_statistics
%type <aqrOptionsList> aqr_options_list
%type <aqrOption> aqr_option
%type <uint> aqr_task
@@ -6008,23 +6009,23 @@ TOK_TABLE '(' TOK_INTERNALSP '(' character_string_literal ')' ')'
$$ = lle;
}
-| TOK_TABLE '(' TOK_REGION TOK_STATS '(' ')' ')'
+| TOK_TABLE '(' TOK_REGION stats_or_statistics '(' ')' ')'
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(CorrName(""), FALSE, FALSE, FALSE, NULL, PARSERHEAP());
}
-| TOK_TABLE '(' TOK_REGION TOK_STATS '(' table_name ')' ')'
+| TOK_TABLE '(' TOK_REGION stats_or_statistics '(' table_name ')' ')'
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$6, FALSE, FALSE, FALSE, NULL, PARSERHEAP());
}
-| TOK_TABLE '(' TOK_REGION TOK_STATS '(' TOK_INDEX table_name ')' ')'
+| TOK_TABLE '(' TOK_REGION stats_or_statistics '(' TOK_INDEX table_name ')' ')'
{
$7->setSpecialType(ExtendedQualName::INDEX_TABLE);
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$7, FALSE, TRUE, FALSE, NULL, PARSERHEAP());
}
-| TOK_TABLE '(' TOK_REGION TOK_STATS '(' TOK_USING rel_subquery ')' ')'
+| TOK_TABLE '(' TOK_REGION stats_or_statistics '(' TOK_USING rel_subquery ')' ')'
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(CorrName("DUMMY"), FALSE, FALSE, FALSE, $7, PARSERHEAP());
@@ -16211,43 +16212,52 @@ exe_util_init_hbase : TOK_INITIALIZE TOK_TRAFODION
}
/* type relx */
-exe_util_get_region_access_stats : TOK_GET TOK_REGION TOK_STATS TOK_FOR TOK_TABLE table_name
+exe_util_get_region_access_stats : TOK_GET TOK_REGION stats_or_statistics TOK_FOR TOK_TABLE table_name
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$6, FALSE, FALSE, TRUE, NULL, PARSERHEAP());
}
- | TOK_GET TOK_REGION TOK_STATS TOK_FOR TOK_INDEX table_name
+ | TOK_GET TOK_REGION stats_or_statistics TOK_FOR TOK_INDEX table_name
{
$6->setSpecialType(ExtendedQualName::INDEX_TABLE);
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$6, FALSE, TRUE, TRUE, NULL, PARSERHEAP());
}
- | TOK_GET TOK_REGION TOK_STATS TOK_FOR rel_subquery
+ | TOK_GET TOK_REGION stats_or_statistics TOK_FOR rel_subquery
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(
CorrName("DUMMY"), FALSE, TRUE, TRUE, $5, PARSERHEAP());
}
- | TOK_GET TOK_REGION TOK_STATS TOK_FOR TOK_TABLE table_name ',' TOK_SUMMARY
+ | TOK_GET TOK_REGION stats_or_statistics TOK_FOR TOK_TABLE table_name ',' TOK_SUMMARY
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$6, TRUE, FALSE, TRUE, NULL, PARSERHEAP());
}
- | TOK_GET TOK_REGION TOK_STATS TOK_FOR TOK_INDEX table_name ',' TOK_SUMMARY
+ | TOK_GET TOK_REGION stats_or_statistics TOK_FOR TOK_INDEX table_name ',' TOK_SUMMARY
{
$6->setSpecialType(ExtendedQualName::INDEX_TABLE);
$$ = new (PARSERHEAP())
ExeUtilRegionStats(*$6, TRUE, TRUE, TRUE, NULL, PARSERHEAP());
}
- | TOK_GET TOK_REGION TOK_STATS TOK_FOR rel_subquery ',' TOK_SUMMARY
+ | TOK_GET TOK_REGION stats_or_statistics TOK_FOR rel_subquery ',' TOK_SUMMARY
{
$$ = new (PARSERHEAP())
ExeUtilRegionStats(
CorrName("DUMMY"), TRUE, TRUE, TRUE, $5, PARSERHEAP());
}
+stats_or_statistics : TOK_STATS
+ {
+ $$ = TRUE;
+ }
+ | TOK_STATISTICS
+ {
+ $$ = TRUE;
+ }
+
/*
* The purpose of dummy_token_lookahead is to force the lexer to look
* one token ahead. This may be necessary in cases where the parser
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/regress/seabase/EXPECTED002
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED002 b/core/sql/regress/seabase/EXPECTED002
index 1b56260..22131c5 100644
--- a/core/sql/regress/seabase/EXPECTED002
+++ b/core/sql/regress/seabase/EXPECTED002
@@ -62,7 +62,7 @@ A B
>>invoke table(region stats ());
-- Definition of Trafodion table TRAFODION.T002SCH.EXE_UTIL_REGION_STATS__
--- Definition current Sat Nov 28 16:07:27 2015
+-- Definition current Tue Dec 1 20:28:59 2015
(
CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE
@@ -87,7 +87,7 @@ A B
>>invoke table(region stats (t002t1));
-- Definition of Trafodion table TRAFODION.T002SCH.EXE_UTIL_REGION_STATS__
--- Definition current Sat Nov 28 16:07:28 2015
+-- Definition current Tue Dec 1 20:29:01 2015
(
CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE
@@ -120,7 +120,7 @@ A B
(EXPR) REGION_NUM REGION_NAME NUM_STORES NUM_STORE_FILES STORE_FILE_UNCOMP_SIZE STORE_FILE_SIZE MEM_STORE_SIZE (EXPR) (EXPR)
-------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------- ---------------------- -------------------- -------------------- ----------------------------- ------------------------------
-T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1/8bb4f679579199d03d7f610bec389948 2 0 0 0 0 ReadRequestsCount: 2 WriteRequestsCount: 1
+T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1/d8e501bc4b1e00c4a363ddbfddb73ce6 2 0 0 0 0 ReadRequestsCount: 2 WriteRequestsCount: 1
--- 1 row(s) selected.
>>
@@ -134,7 +134,7 @@ T002SCH.T002T1 1
(EXPR) REGION_NUM REGION_NAME NUM_STORES NUM_STORE_FILES STORE_FILE_UNCOMP_SIZE STORE_FILE_SIZE MEM_STORE_SIZE (EXPR) (EXPR)
-------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------- ---------------------- -------------------- -------------------- ----------------------------- ------------------------------
-T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I1/063997b7b1aa3d335501fc78296708ba 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
+T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I1/6ecaf721eab09f276a465486204b9224 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
--- 1 row(s) selected.
>>
@@ -148,10 +148,10 @@ T002SCH.T002T1 1
(EXPR) REGION_NUM REGION_NAME NUM_STORES NUM_STORE_FILES STORE_FILE_UNCOMP_SIZE STORE_FILE_SIZE MEM_STORE_SIZE (EXPR) (EXPR)
-------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------- ---------------------- -------------------- -------------------- ----------------------------- ------------------------------
-T002SCH.T002T2 1 TRAFODION.T002SCH.T002T2/57b9567e1e3ade7a22dba5447579dd6f 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
-T002SCH.T002T2 2 TRAFODION.T002SCH.T002T2/48d51d2d9395038ad05201c03701330b 2 0 0 0 0 ReadRequestsCount: 1 WriteRequestsCount: 1
-T002SCH.T002T2 3 TRAFODION.T002SCH.T002T2/bbe7fd3cb6b812f201be57047c266ce9 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
-T002SCH.T002T2 4 TRAFODION.T002SCH.T002T2/e3fd1521aca16734c6e1afe2a493d5d7 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
+T002SCH.T002T2 1 TRAFODION.T002SCH.T002T2/08950a2e799b5158e7bc01f7d381da15 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
+T002SCH.T002T2 2 TRAFODION.T002SCH.T002T2/8f5f1f95e9f83eb80059038985b55e56 2 0 0 0 0 ReadRequestsCount: 1 WriteRequestsCount: 1
+T002SCH.T002T2 3 TRAFODION.T002SCH.T002T2/74c3d257b6633eeb7097c587dadd2e1e 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
+T002SCH.T002T2 4 TRAFODION.T002SCH.T002T2/eb2ed476df0e857b6a8eaa9618b1923b 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 0
--- 4 row(s) selected.
>>
@@ -165,7 +165,7 @@ T002SCH.T002T2 4
(EXPR) REGION_NUM REGION_NAME NUM_STORES NUM_STORE_FILES STORE_FILE_UNCOMP_SIZE STORE_FILE_SIZE MEM_STORE_SIZE (EXPR) (EXPR)
-------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------- ---------------------- -------------------- -------------------- ----------------------------- ------------------------------
-T002SCH.T002T2 1 TRAFODION.T002SCH.T002T2I1/47d3338bc9349068a1461da09fe0d3bd 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
+T002SCH.T002T2 1 TRAFODION.T002SCH.T002T2I1/94aaac02a94952f6bd9b33f408f8c0dc 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
--- 1 row(s) selected.
>>
@@ -185,6 +185,22 @@ T002SCH.T002T1 0
--- 2 row(s) selected.
>>
+>>select left(trim(schema_name) || '.' || trim(object_name), 14),
++> sum(store_file_size),
++> 'ReadRequestsCount: ' || cast(sum(read_requests_count) as varchar(10)),
++> 'WriteRequestsCount: ' || cast(sum(write_requests_count) as varchar(10))
++> from table(region statistics (using (select * from (
++> get tables in schema t002sch, no header, return full names) x(a) )))
++> group by 1 order by 2 desc;
+
+(EXPR) (EXPR) (EXPR) (EXPR)
+-------------------------------------------------------- -------------------- ----------------------------- ------------------------------
+
+T002SCH.T002T2 0 ReadRequestsCount: 1 WriteRequestsCount: 1
+T002SCH.T002T1 0 ReadRequestsCount: 2 WriteRequestsCount: 1
+
+--- 2 row(s) selected.
+>>
>>get region stats for table t002t1;
@@ -206,7 +222,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T1/8bb4f679579199d03d7f610bec389948
+ RegionName: TRAFODION.T002SCH.T002T1/d8e501bc4b1e00c4a363ddbfddb73ce6
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -238,7 +254,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T1I1/063997b7b1aa3d335501fc78296708ba
+ RegionName: TRAFODION.T002SCH.T002T1I1/6ecaf721eab09f276a465486204b9224
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -270,7 +286,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T2/57b9567e1e3ade7a22dba5447579dd6f
+ RegionName: TRAFODION.T002SCH.T002T2/08950a2e799b5158e7bc01f7d381da15
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -280,7 +296,7 @@ Stats Details
WriteRequestsCount: 0
RegionNum: 2
- RegionName: TRAFODION.T002SCH.T002T2/48d51d2d9395038ad05201c03701330b
+ RegionName: TRAFODION.T002SCH.T002T2/8f5f1f95e9f83eb80059038985b55e56
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -290,7 +306,7 @@ Stats Details
WriteRequestsCount: 1
RegionNum: 3
- RegionName: TRAFODION.T002SCH.T002T2/bbe7fd3cb6b812f201be57047c266ce9
+ RegionName: TRAFODION.T002SCH.T002T2/74c3d257b6633eeb7097c587dadd2e1e
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -300,7 +316,7 @@ Stats Details
WriteRequestsCount: 0
RegionNum: 4
- RegionName: TRAFODION.T002SCH.T002T2/e3fd1521aca16734c6e1afe2a493d5d7
+ RegionName: TRAFODION.T002SCH.T002T2/eb2ed476df0e857b6a8eaa9618b1923b
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -325,20 +341,53 @@ Stats Summary
TotalUncompressedSize: 0
TotalStoreFileSize: 0
TotalMemStoreSize: 0
- TotalReadRequestsCount: 1
+ TotalReadRequestsCount: 0
TotalWriteRequestsCount: 1
Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T2I1/47d3338bc9349068a1461da09fe0d3bd
+ RegionName: TRAFODION.T002SCH.T002T2I1/94aaac02a94952f6bd9b33f408f8c0dc
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
StoreFileSize: 0 (less than 1MB)
MemStoreSize: 0 (less than 1MB)
- ReadRequestsCount: 1
+ ReadRequestsCount: 0
+ WriteRequestsCount: 1
+
+
+--- SQL operation complete.
+>>
+>>get region statistics for table t002t1;
+
+
+Stats Summary
+=============
+
+ ObjectName: TRAFODION.T002SCH.T002T1
+ NumRegions: 1
+ RegionsLocation: /hbase/data/default
+ TotalNumStores: 2
+ TotalNumStoreFiles: 0
+ TotalUncompressedSize: 0
+ TotalStoreFileSize: 0
+ TotalMemStoreSize: 0
+ TotalReadRequestsCount: 2
+ TotalWriteRequestsCount: 1
+
+Stats Details
+=============
+
+ RegionNum: 1
+ RegionName: TRAFODION.T002SCH.T002T1/d8e501bc4b1e00c4a363ddbfddb73ce6
+ NumStores: 2
+ NumStoreFiles: 0
+ UncompressedSize: 0 (less than 1MB)
+ StoreFileSize: 0 (less than 1MB)
+ MemStoreSize: 0 (less than 1MB)
+ ReadRequestsCount: 2
WriteRequestsCount: 1
@@ -367,7 +416,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T1/8bb4f679579199d03d7f610bec389948
+ RegionName: TRAFODION.T002SCH.T002T1/d8e501bc4b1e00c4a363ddbfddb73ce6
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -395,7 +444,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T2/57b9567e1e3ade7a22dba5447579dd6f
+ RegionName: TRAFODION.T002SCH.T002T2/08950a2e799b5158e7bc01f7d381da15
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -405,7 +454,7 @@ Stats Details
WriteRequestsCount: 0
RegionNum: 2
- RegionName: TRAFODION.T002SCH.T002T2/48d51d2d9395038ad05201c03701330b
+ RegionName: TRAFODION.T002SCH.T002T2/8f5f1f95e9f83eb80059038985b55e56
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -415,7 +464,7 @@ Stats Details
WriteRequestsCount: 1
RegionNum: 3
- RegionName: TRAFODION.T002SCH.T002T2/bbe7fd3cb6b812f201be57047c266ce9
+ RegionName: TRAFODION.T002SCH.T002T2/74c3d257b6633eeb7097c587dadd2e1e
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -425,7 +474,7 @@ Stats Details
WriteRequestsCount: 0
RegionNum: 4
- RegionName: TRAFODION.T002SCH.T002T2/e3fd1521aca16734c6e1afe2a493d5d7
+ RegionName: TRAFODION.T002SCH.T002T2/eb2ed476df0e857b6a8eaa9618b1923b
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -449,8 +498,8 @@ Stats Details
(EXPR) REGION_NUM REGION_NAME NUM_STORES NUM_STORE_FILES STORE_FILE_UNCOMP_SIZE STORE_FILE_SIZE MEM_STORE_SIZE (EXPR) (EXPR)
-------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------- ---------------------- -------------------- -------------------- ----------------------------- ------------------------------
-T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I1/063997b7b1aa3d335501fc78296708ba 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
-T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I2/e1d921638743bb5988eb7e011dbdd3f3 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
+T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I1/6ecaf721eab09f276a465486204b9224 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
+T002SCH.T002T1 1 TRAFODION.T002SCH.T002T1I2/b36b08f5d1152de7006cc11bc2c07e26 2 0 0 0 0 ReadRequestsCount: 0 WriteRequestsCount: 1
--- 2 row(s) selected.
>>get region stats for
@@ -476,7 +525,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T1I1/063997b7b1aa3d335501fc78296708ba
+ RegionName: TRAFODION.T002SCH.T002T1I1/6ecaf721eab09f276a465486204b9224
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
@@ -504,7 +553,7 @@ Stats Details
=============
RegionNum: 1
- RegionName: TRAFODION.T002SCH.T002T1I2/e1d921638743bb5988eb7e011dbdd3f3
+ RegionName: TRAFODION.T002SCH.T002T1I2/b36b08f5d1152de7006cc11bc2c07e26
NumStores: 2
NumStoreFiles: 0
UncompressedSize: 0 (less than 1MB)
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c73e0652/core/sql/regress/seabase/TEST002
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/TEST002 b/core/sql/regress/seabase/TEST002
index 60c159e..7a97e49 100644
--- a/core/sql/regress/seabase/TEST002
+++ b/core/sql/regress/seabase/TEST002
@@ -95,11 +95,21 @@ select left(trim(schema_name) || '.' || trim(object_name), 14),
get tables in schema t002sch, no header, return full names) x(a) )))
group by 1 order by 2 desc;
+select left(trim(schema_name) || '.' || trim(object_name), 14),
+ sum(store_file_size),
+ 'ReadRequestsCount: ' || cast(sum(read_requests_count) as varchar(10)),
+ 'WriteRequestsCount: ' || cast(sum(write_requests_count) as varchar(10))
+ from table(region statistics (using (select * from (
+ get tables in schema t002sch, no header, return full names) x(a) )))
+ group by 1 order by 2 desc;
+
get region stats for table t002t1;
get region stats for index t002t1i1;
get region stats for table t002t2;
get region stats for index t002t2i1;
+get region statistics for table t002t1;
+
get region stats for
(select * from
(get tables in schema t002sch, no header, return full names)x(a));