Hi all, Rohit, I believe we should have a plan for upcoming and future release, and opt for the low hanging fruit for upcoming release. This means that we should look at:
1. what do others provide/use 2. (more importantly) what does our main competitor/use to get such data/information from indexes, tables, views, etc. On-boarding that in our solution will make it easier for (potential) adopters to migrate to the Trafodion - HBase solution stack. Having done only a cursory on what (some of) the others (MSSQL, MySQL, ORACLE, PostgresQL) use, I found that all use a complex methodology to get to the details. But most (MSSQL, MySQ, ORACLE) use the SHOW methodology. Only PostgresQL use the DESCRIBE methodology. Therefore I suggest we opt for the SHOW variant to enhance the user experience. Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Fri, Apr 8, 2016 at 3:15 AM, Wei-Shiun Tsai <[email protected]> wrote: > 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:[email protected]] > Sent: Thursday, April 7, 2016 4:55 PM > To: Liu, Ming (Ming) <[email protected]>; > [email protected] > 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)" <[email protected]> > Date: 04/08/2016 12:39 AM (GMT+00:00) > To: [email protected] > 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:[email protected]] > 发送时间: 2016年4月8日 7:07 > 收件人: [email protected] > 主题: 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:[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 > > >
