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:[email protected]] Sent: Thursday, April 7, 2016 11:51 PM To: [email protected] 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:[email protected]] Sent: Thursday, April 7, 2016 3:50 PM To: [email protected] 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:[email protected]] Sent: Thursday, April 7, 2016 8:38 PM To: [email protected] 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 <[email protected]> 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:[email protected]] > Sent: Thursday, April 7, 2016 12:04 PM > To: dev <[email protected]> > 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 < > [email protected]> 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 > > <[email protected]> > > 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 >
