one can also use traf metadata tables view to get this info.
select row_data_length, row_total_length from "_MD_".tables_view where schema_name = 'your-sch' and table_name = 'your-tab';
row_data_length: length of row for the data part of table. This is the sum of lengths of all columns in the table plus 1 byte per nullable col.
row_total_length: in addition to row_data_length, this includes hbase overhead for each stored hbase cell/column and
includes key length, timestamp and column family length.
If table is created as an aligned format table, this hbase overhead is minimal as all columns are packed and stored as one cell.
From: Liu, Ming (Ming) [mailto:email@example.com]
Sent: Monday, September 12, 2016 2:49 AM
To: firstname.lastname@example.org; dev <email@example.com>
Subject: RE: command
You can try to search in the system metadata, here is an example
select ROW_TOTAL_LENGTH , ROW_DATA_LENGTH from "_MD_".tables , "_MD_".objects where $B!H(J_MD_$B!I(J.objects.OBJECT_UID = $B!H(J_MD_$B!I(J.tables.table_uid and objects.OBJECT_NAME='your_table_name$B!G(J;
and you can check other columns in the $B!H(J_MD_$B!I(J.tables to see if there are other info you need.
Others may have better approach, since I heard there are some new defined system dictionary and views. Or maybe some new utility to grab these information. But above query is one method.
From: Dido_vansa [mailto:firstname.lastname@example.org]
Sent: Monday, September 12, 2016 2:52 PM
To: user <email@example.com>; dev <firstname.lastname@example.org>
I have a problem about sql command in trafodion .
I want to obtain row length in a table , but I do not understand which command I can use in this case.
I'm looking forward to your reply