 |
 |
Tatiana We are not (yet) supporting any "show" commands, but are planning to. If there is burning need, we can increase the priority, (and schedule it for Summer 2015) Jacek On 11/11/2014 10:14 AM, Serge Monkewitz wrote: > Hi Tatiana, > > I’m moving this discussions to the qserv mailing list. There’s a > page on the SQL constructs that qserv supports here: > https://dev.lsstcorp.org/trac/wiki/db/ScalableArchSQL. > > In general, it’s SQL 92 minus sub-queries, and with some spatial > support. That means that MySQL specific syntax usually isn’t supported. > Unfortunately, I’m not aware of a page that lists out the exact > MySQLisms that we do support, but I believe it’s limited to: > > SHOW TABLES > SHOW DATABSES > DESCRIBE > > Are you saying that the JDBC driver itself is issuing SHOW COLUMNS, or > is that initiated on your end? > > Cheers, > Serge > > Begin forwarded message: > >> *From: *Tatiana Goldina <[log in to unmask] >> <mailto:[log in to unmask]>> >> *Subject: **connecting to qserv database* >> *Date: *November 11, 2014 at 9:07:02 AM PST >> *To: *Serge Monkewitz <[log in to unmask] <mailto:[log in to unmask]>> >> >> Hi Serge, >> >> John Rector has set a QSERV for us here at IPAC, and we are trying to >> figure out how to access it. >> >> It seems that I can not access it with a MySql GUI client or JDBC >> (jdbc:mysql://lsst-db1.ipac.caltech.edu >> <http://lsst-db1.ipac.caltech.edu>:4040/LSST) >> >> I am able to access it with command line mysql client. I can get the >> tables with "show tables;" but >> >> mysql> show columns from DeepSource from LSST; >> ERROR 4110 (Proxy): Qserv error: 'ParseException:ANTLR parse >> error:unexpected token: show:' >> >> (The same error that we get when trying to connect with JDBC.) >> >> On the other hand "describe DeepSource;" works. >> >> How do I find out which commands are supported? >> >> Tatiana > > > ------------------------------------------------------------------------ > > Use REPLY-ALL to reply to list > > To unsubscribe from the QSERV-L list, click the following link: > https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 > ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1