I am issuing "select columns from %table%' from mysql command line client. For now this is the only client that I know which can connect to QSERVE mysql proxy. It could be that MySQL Query Browser and IntelliJ (via JDBC driver) fail to connect because in addition to connecting they try to get extra information about the the schema. I'll test it tonight.

On Nov 11, 2014, at 10:14 AM, Serge Monkewitz <[log in to unmask]> 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]>
Subject: connecting to qserv database
Date: November 11, 2014 at 9:07:02 AM PST
To: Serge Monkewitz <[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: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