[jira] [Commented] (TRAFODION-1645) Add sql support to retrieve region space and access stats for trafodion tables

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15034228#comment-15034228 ] 

ASF GitHub Bot commented on TRAFODION-1645:
-------------------------------------------

Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/194#discussion_r46314687
  
    --- Diff: core/sql/comexe/ComTdbExeUtil.h ---
    @@ -3452,6 +3453,122 @@ class ComTdbExeUtilHBaseBulkUnLoad : public ComTdbExeUtil
       NABasicPtr   snapshotSuffix_;                         // 30 - 37
       char         fillersExeUtilHbaseUnLoad_[16];          // 38 - 53
     };
    +
    +static const ComTdbVirtTableColumnInfo comTdbRegionStatsVirtTableColumnInfo[] =
    +  {
    +    { "CATALOG_NAME",                   0, COM_USER_COLUMN, REC_BYTE_F_ASCII,  256, FALSE, SQLCHARSETCODE_UTF8 , 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, "",NULL,NULL, COM_UNKNOWN_DIRECTION_LIT, 0  },
    --- End diff --
    
    Just curious: Why fixed length CHAR instead of VARCHAR?


> Add sql support to retrieve region space and access stats for trafodion tables
> ------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1645
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1645
>             Project: Apache Trafodion
>          Issue Type: New Feature
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>            Priority: Minor
>
> Add support to retrieve region related statistics using trafodion sql commands.
> Capabilities needed are listed below:
> -- represent region space and access stats of a trafodion table or index as a  
>    virtual relational table
> -- run sql queries against that virtual table to return data. These queries
>     could be used to aggregate or group or order returned data.
> -- provide support to return region stats in a formatted way for display
> -- provide support to return stats for multiple tables in one query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)