You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2016/04/16 00:03:25 UTC
[jira] [Commented] (TRAFODION-1891) New SQL Get command to return
LOB related information
[ https://issues.apache.org/jira/browse/TRAFODION-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15243731#comment-15243731 ]
Sandhya Sundaresan commented on TRAFODION-1891:
-----------------------------------------------
Two ways to get lob info for lob tables :
"get lob stats for table <t>"
This will give a formatted output that will show lob eelate information for eahc columns of the table that has lob datatype.
>>get lob stats for table tlob130gt;
Lob Information for table: "TRAFODION".LOB130.TLOB130GT
=========================
ColumnName : C2
Lob Location : /lobs
LOB Data File: LOBP_03328818418788117478_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
LOB Data File: LOBP_03328818418788117478_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
LOB Data File: LOBP_03328818418788117478_0003
LOB EOD : 71
LOB Used Len : 56
select * from table(lob stats<table name>)
The above will give a tabular output that db manager could use.
The format is as follows :
static const ComTdbVirtTableColumnInfo comTdbLobInfoVirtTableColumnInfo[] =
{
{ "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 },
{ "SCHEMA_NAME", 1, 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 },
{ "OBJECT_NAME", 2, 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 },
{ "COLUMN_NAME", 3, 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 },
{ "LOB_LOCATION", 4, 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 },
{ "LOB_DATA_FILE", 5, 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 },
{ "LOB_DATA_FILE_SIZE_EOD", 6, 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 },
{ "LOB_DATA_FILE_SIZE_USED", 7, 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 }
};
> New SQL Get command to return LOB related information
> ------------------------------------------------------
>
> Key: TRAFODION-1891
> URL: https://issues.apache.org/jira/browse/TRAFODION-1891
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
>
> The current SQL "get " commands do not return any information on LOB columns. They return only Hbase specific region statistics. This new command will return information on LOB data files associated with each LOB column in a table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)