trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit <rohit.j...@esgyn.com>
Subject RE: 答复: In sqlci: how to show column names and associated data types?
Date Thu, 07 Apr 2016 23:55:01 GMT

    
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message