Connecting to Tableau 8.2

[arthurhsk]

Hi,

I have prestogres up and running now. I just tried to use tableau 8.2 to connect Prestodb.

Q1: If I specify "default" as the database name, I cannot connect Tableau to PrestoDB,
Connect on a server: select PostgreSQL
sever: localhost
port: 9900
database: default
Error: Unable to connect to the ODBC data source, FATAL: database “default” does not exist.

Q2: If I specify "Postgres" as database name,
Connect on a server: select PostgreSQL
sever: localhost
port: 9900
database: postgres
I can log into PrestoDB, but it cannot display any table

On the command line, I can see "default" DB exists
postgres=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+-------+----------+-----------+-------+-------------------
default | pg | UTF8 | C | C |

My PrestoDB version is v0.79

Could you share how you get Tableau connected to Presto?
Regards
Arthur

[arthurhsk]

(Forgot to mention: Above tests are done in Tableau 8.2 for Mac.)

Have just tried Windows Tableau (Windows 8.1, Tableau 8.2, Presto 0.79):
Also installed Tableau's PostgreSQL ODBC driver.

The schema "Default" can be displayed in Windows version, can get the list of tables as well.
However, if drag any table to worksheet area, it always returns error "Could not send Query/connection dead)

Please help!

[arthurhsk]

Also for the log, I found following:

< 2014-11-19 23:47:16.400 HKT >WARNING: Result column "?column?" is renamed to "?column?" because the name appears twice in a query result
< 2014-11-19 23:47:16.400 HKT >CONTEXT: PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:47:16.400 HKT >WARNING: Result column "?column?" is renamed to "?column?__" because the name appears twice in a query result
< 2014-11-19 23:47:16.400 HKT >CONTEXT: PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:47:16.400 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:47:16.400 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:47:16.400 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:47:16.400 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:47:16.400 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:47:16.400 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:47:16.400 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:47:16.400 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:47:16.400 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?_" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:47:33.057 HKT >FATAL: database "default" does not exist
< 2014-11-19 23:49:05.434 HKT >FATAL: database "default" does not exist
< 2014-11-19 23:50:35.302 HKT >WARNING: Result column "?column?" is renamed to "?column?" because the name appears twice in a query result
< 2014-11-19 23:50:35.302 HKT >CONTEXT: PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:50:35.302 HKT >WARNING: Result column "?column?" is renamed to "?column?__" because the name appears twice in a query result
< 2014-11-19 23:50:35.302 HKT >CONTEXT: PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:50:35.302 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:50:35.302 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:50:35.302 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:50:35.302 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:50:35.302 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:50:35.302 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"
< 2014-11-19 23:50:35.302 HKT >WARNING: column "?column?" has type "unknown"
< 2014-11-19 23:50:35.302 HKT >DETAIL: Proceeding with relation creation anyway.
< 2014-11-19 23:50:35.302 HKT >CONTEXT: SQL statement "create temporary table presto_result (
"?column?" unknown,
"?column?_" unknown,
"?column?" unknown
)"
PL/Python function "run_system_catalog_as_temp_table"

[frsyuki]

Oh, I haven't tested with Tableau 8.2. I tested only with Tableau 8.1 + Windows 8.
Apparently, tableau ran a query to get 3 constants (like "SELECT 1, 2, 3") and ends up with 3 "?column?" an unknown error.

[frsyuki]

I released Prestogres v0.5.0 which includes significant change around query rewriting mechanism.
I haven't found time to check compatibility with Tableau 8.2 but hopefully getting list of tables works at least.

[frsyuki]

I confirmed that Tableau 8.3 on Windows 8 works with Prestogres v0.5.3.