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 <[email protected]> Authored: Tue Dec 1 23:13:48 2015 +0000 Committer: Cloud User <[email protected]> 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));
