Qubole's hosted Presto service is supported in Looker 4.8+.
These are the settings to use Qubole Presto.
As of late summer 2017, Presto v0.142 is supported by Qubole. Looker works with this version, but since this version does not support the DECIMAL datatype, some features - notably symmetric aggregates - are not available.
Presto v0.150 is no longer available from Qubole. This version has serious bugs that interfered with Looker and was never approved for use with Looker.
Presto v0.157 is currently available and well supported. This version can be used with Looker and does support the DECIMAL datatype.
Presto v0.180 is available as beta from Qubole and should work well with Looker.
Qubole Cluster Presto Settings
The following "Presto Settings" should be configured in the Qubole cluster settings:
hive.metastore-cache-ttl = 0s
hive.metastore-refresh-interval = 5s
Qubole Cluster Node Bootstrap Files
As of late June, 2017 Qubole has updated their default configuration and these bootstraps should not be needed. They are documented in the comments for historical and reference purposes.
In the Looker Databases Connection setup, use the label of the cluster from the Qubole Control Panel as the host name. The port number is ignored and can be set to anything. The database should be hive. The username can be left blank, and the password must be set to the user's authentication token. The schema should set to the database/schema name.
If PDTs are enabled, the Temp Database should be set to a database/schema where the user has full privileges to create/drop/rename/alter tables.
Attaching to an Alternate Service Endpoint
By default, the Qubole connections are made to api.qubole.com. Qubole operates some additional endpoints such as us.qubole.com. If you need to connect to a cluster hosted on an alternate endpoint, you can specify it in the "Additional Params" field of the Connection Setup screen. Use the parameter
endpoint=url_of_alternate_endpoint to specify it.
Looker’s ability to provide some features depends on the database dialect’s ability to support that functionality.
In the current Looker release, Qubole Presto v0.142 supports the following Looker features:
In the current Looker release, Qubole Presto v0.157+ supports the following Looker features: