For those wishing to connect Tableau from TableauSoftware.com to GridSQL

A small modification of the code is needed in order to connect Tableau to GridSQL. If you are not a programmer, you could ask me to send you updated jars.

The parseStatement method is Parser.java needs to be replaced with the following:

public void parseStatement(String sqlStatement) throws ParseException {
    	if (sqlStatement.startsWith("EXPLAIN VERBOSE SELECT")) {
    		sqlStatement = "EXECUTE DIRECT ON NODES 1 '" + sqlStatement.replaceAll("'", "''") + "';";
    	}
    	if (sqlStatement.equals("select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname")) {
    		sqlStatement = "EXECUTE DIRECT ON NODES 1 'select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in (''r'', ''v'') and nspname not in (''pg_catalog'', ''information_schema'', ''pg_toast'', ''pg_temp_1'') and n.oid = relnamespace order by nspname, relname'";
        	System.out.println(sqlStatement);
    	}
    	if (sqlStatement.startsWith("select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like ")) {
    		sqlStatement = "select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like 'main2' and n.nspname like 'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum".replaceAll("'", "''");
    		sqlStatement = "EXECUTE DIRECT ON NODES 1 '" + sqlStatement + "'";
    	}
        // trim whitespace at beginning and end
        if (sqlStatement.length() > 0) {
            int beginIndex = 0;
            int endIndex = sqlStatement.length() - 1;

while (Character.isWhitespace(sqlStatement.charAt(beginIndex))
                    && beginIndex < endIndex) {
                beginIndex++;
            }

while ((Character.isWhitespace(sqlStatement.charAt(endIndex)) || Character.isISOControl(sqlStatement.charAt(endIndex)))
                    && beginIndex < endIndex) {
                endIndex--;
            }

sqlStatement = sqlStatement.substring(beginIndex, endIndex + 1);
        }
        parse(sqlStatement);
    }