RE: is there docs about systables of trafodion?

[Dave Birdsall <da...@esgyn.com>]

I don't think there is any documentation of the metadata tables at the moment. At least I don't see any in the manuals.

If you simply want to know what columns exist in each table, you can do the following:

Set schema "_MD_";
Get tables;

Then for each table, do "showddl <table-name>".

Some of it is self-explanatory.

If you would like to see documentation in the manuals, please feel free to write a JIRA requesting that. (Or I can do it for you if you wish.)

Thanks,

Dave

-----Original Message-----
From: yingshuai.li@esgyn.cn [mailto:yingshuai.li@esgyn.cn] 
Sent: Friday, December 22, 2017 12:28 AM
To: dev <de...@trafodion.incubator.apache.org>
Subject: is there docs about systables of trafodion?

Hi all,
    i want to get the information about the systables of trafodion in schema _MD_, include column values and its descriptions, is there docs about that?



李英帅
易鲸捷信息技术有限公司
手机：18701691214
邮箱：yingshuai.li@esgyn.cn

Re: is there docs about systables of trafodion?

[Carol Pearson <ca...@gmail.com>]

A year or two ago, I did just that and then used the free version of an
on-line tool to build an ER diagram of the tables at that time. I wanted to
write a bunch of different metadata queries for some research I was doing,
and I found a chart was helpful.

I will poke around to see if I can find the details on my starting point,
and on the tool I used.  I know it wasn't Visio because I didn't have a
license for it at the time, but I don't recall what it was... Either way,
the version I had at the time is a bit out of date now.

In any case, it started out just as Dave described:

 1)  showddl on each metadata table, and also the tables that support
statistics/histograms stored in each schema
 2)  Massage the output with emacs (ok, you could use sed/awk or whatever
other tools you want) to get into a .csv format
 3)  Import .csv fileI into a tool to build a table structure for each
 4)  Format to add the additional info, to display relationships, group
related tables, etc.

-Carol P.


---------------------------------------------------------------
Email:    carol.pearson234@gmail.com
Twitter:  @CarolP222
---------------------------------------------------------------

On Tue, Jan 2, 2018 at 9:34 AM, Dave Birdsall <da...@esgyn.com>
wrote:

> I don't think there is any documentation of the metadata tables at the
> moment. At least I don't see any in the manuals.
>
> If you simply want to know what columns exist in each table, you can do
> the following:
>
> Set schema "_MD_";
> Get tables;
>
> Then for each table, do "showddl <table-name>".
>
> Some of it is self-explanatory.
>
> If you would like to see documentation in the manuals, please feel free to
> write a JIRA requesting that. (Or I can do it for you if you wish.)
>
> Thanks,
>
> Dave
>
> -----Original Message-----
> From: yingshuai.li@esgyn.cn [mailto:yingshuai.li@esgyn.cn]
> Sent: Friday, December 22, 2017 12:28 AM
> To: dev <de...@trafodion.incubator.apache.org>
> Subject: is there docs about systables of trafodion?
>
> Hi all,
>     i want to get the information about the systables of trafodion in
> schema _MD_, include column values and its descriptions, is there docs
> about that?
>
>
>
> 李英帅
> 易鲸捷信息技术有限公司
> 手机：18701691214
> 邮箱：yingshuai.li@esgyn.cn
>