trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wei-Shiun Tsai <wei-shiun.t...@esgyn.com>
Subject RE: 答复: In sqlci: how to show column names and associated data types?
Date Fri, 08 Apr 2016 01:15:12 GMT
Maybe the solution is to implement a Linux-style alias command to allow
users define this sort of simple mappings to their liking themselves (for
each sqlci/trafci session, or some similar design like defaults table),
instead of trying to cover various aliases one by one.

Weishiun

-----Original Message-----
From: Rohit [mailto:rohit.jain@esgyn.com]
Sent: Thursday, April 7, 2016 4:55 PM
To: Liu, Ming (Ming) <ming.liu@esgyn.cn>; dev@trafodion.incubator.apache.org
Subject: RE: 答复: In sqlci: how to show column names and associated data
types?



I have also see "use <schema>".  But before we make any changes we probably
need some due diligence, since every change has a cost. At least a QA cost.
Rohit

-------- Original message --------
From: "Liu, Ming (Ming)" <ming.liu@esgyn.cn>
Date: 04/08/2016  12:39 AM  (GMT+00:00)
To: dev@trafodion.incubator.apache.org
Subject: 答复: In sqlci: how to show column names and associated data types?

+1 for 'describe' and 'show tables'.
Also helpful to have

'set database' => 'set schema' ,
'show databases' => 'get schemas'
etc...

Migration is sometimes very painful due to 'small' differences.

Thanks,
Ming

-----邮件原件-----
发件人: Rohit Jain [mailto:rohit.jain@esgyn.com]
发送时间: 2016年4月8日 7:07
收件人: dev@trafodion.incubator.apache.org
主题: RE: In sqlci: how to show column names and associated data types?

I was asking Pierre since it did not come naturally to him.  But in Hive
there are SHOW commands to see objects and DESCRIBE commands to show their
DDL.  I just don't know how prevalent those terms are across the Hadoop
eco-system and whether it makes sense for us to adopt them as aliases as we
are playing in that ecosystem.  I did not see anything equivalent in Phoenix
though there very well might be.

-----Original Message-----
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Thursday, April 7, 2016 11:51 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: In sqlci: how to show column names and associated data types?

Do you have one in mind?

-----Original Message-----
From: Rohit Jain [mailto:rohit.jain@esgyn.com]
Sent: Thursday, April 7, 2016 3:50 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: In sqlci: how to show column names and associated data types?

Is it worthwhile considering creating a synonym for this syntax that is more
prevalent for equivalent functionality in other environments?

-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Thursday, April 7, 2016 8:38 PM
To: dev@trafodion.incubator.apache.org
Subject: Re: In sqlci: how to show column names and associated data types?

Thanks all,

The command presented by Eric was the easiest/shortest solution. I had
forgotten that one. Must be age/time of day. :-)

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Thu, Apr 7, 2016 at 9:15 PM, Anoop Sharma <anoop.sharma@esgyn.com> wrote:

> to add to what has already been mentioned, one can also use traf
> metadata views to look at table/column details in a relational way.
>
>   select * from "_MD_".columns_view where schema_name = '<sch>' and
> table_name = '<tab>';
>
> will show details of all columns in table <tab>
>
> invoke "_MD_".columns_view
> will show the columns that make up the view columns_view.
>
> anoop
>
> -----Original Message-----
> From: Qifan Chen [mailto:qifan.chen@esgyn.com]
> Sent: Thursday, April 7, 2016 12:04 PM
> To: dev <dev@trafodion.incubator.apache.org>
> Subject: Re: In sqlci: how to show column names and associated data types?
>
> Any SQL actions from within sqlci can be logged via the log command.
>
> log <logfile> clear;  -- start logging into <logfile>.  Clear any
> content in <logfile> first.
>
> showddl <t>;
>
> log;  --stop logging
>
> --Qifan
>
> On Thu, Apr 7, 2016 at 1:56 PM, Selva Govindarajan <
> selva.govindarajan@esgyn.com> wrote:
>
> > You can either issue
> >
> > invoke trafodion.<schema_name>.tablename or showddl
> > trafodion.<schema_name>.tablename
> >
> > Showddl output is such that it can be used to re-create the table
> > when needed.
> >
> > Selva
> >
> > On Thu, Apr 7, 2016 at 11:52 AM, Pierre Smits
> > <pierre.smits@gmail.com>
> > wrote:
> >
> > > Hi all,
> > >
> > > Maybe this is question answered in the documentation/pages
> > > already, but I might be overlooking it: how do I, in sqlci, get
> > > the information of a
> > table
> > > (meaning the column names, their data types and such) in a
> > > TRAFODION.SCHEMA?
> > >
> > > Best regards,
> > >
> > > Pierre Smits
> > >
> > > ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions &
> > > services
> > >
> > > OFBiz Extensions Marketplace
> > > http://oem.ofbizci.net/oci-2/
> > >
> >
> >
> >
> > --
> > - cheers
> > selvag
> >
>
>
>
> --
> Regards, --Qifan
>

Mime
View raw message