RE: command

[Anoop Sharma]

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.

anoop
-Original Message-
From: Liu, Ming (Ming) [mailto:ming@esgyn.cn]
Sent: Monday, September 12, 2016 2:49 AM
To: u...@trafodion.incubator.apache.org; dev
<dev@trafodion.incubator.apache.org>
Subject: RE: command

Hi, Forling,

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 “_MD_”.objects.OBJECT_UID = “_MD_”.tables.table_uid
and objects.OBJECT_NAME='your_table_name’;

and you can check other columns in the “_MD_”.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.

Thanks,
Ming

From: Dido_vansa [mailto:523766...@qq.com]
Sent: Monday, September 12, 2016 2:52 PM
To: user <u...@trafodion.incubator.apache.org
<mailto:u...@trafodion.incubator.apache.org> >; dev
<dev@trafodion.incubator.apache.org
<mailto:dev@trafodion.incubator.apache.org> >
Subject: command

Hi！

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


Best regards，
Forling

RE: command

[Liu, Ming (Ming)]

Hi, Forling,

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 “_MD_”.objects.OBJECT_UID = “_MD_”.tables.table_uid and 
objects.OBJECT_NAME='your_table_name’;

and you can check other columns in the “_MD_”.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.

Thanks,
Ming

From: Dido_vansa [mailto:523766...@qq.com]
Sent: Monday, September 12, 2016 2:52 PM
To: user <u...@trafodion.incubator.apache.org>; dev 
<dev@trafodion.incubator.apache.org>
Subject: command

Hi！

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


Best regards，
Forling

command

[Dido_vansa]

Hi??

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


Best regards??
Forling

Re: Command Interface Guide Ported to Asciidoc

[Dave Birdsall]

You've been busy over the holidays!

On Sat, Dec 26, 2015 at 11:25 PM, Gunnar Tapper <tapper.gun...@gmail.com>
wrote:

> Hi,
>
> I just finished porting the Trafodion Command Interface Guide to asciidoc.
> LOTS of work!
>
> In case you're interested in looking at the guide before it's published on
> trafodion.incubator.apache.org, then you can download the rendered output
> from:
>
> https://drive.google.com/open?id=0BxlwNhWxn8iTVWs3U1JCYXpYYjg
>
> --
> Thanks,
>
> Gunnar
> *If you think you can you can, if you think you can't you're right.*
>