Running GeoSpock database queries from the Presto CLI

You can use Presto CLI tool to run SQL queries on your ingested data in the GeoSpock database.

Alternatively, you can access the GeoSpock database:

using a BI tool; see Using Business Intelligence (BI) tools with the GeoSpock database
over HTTP; see Connecting to GeoSpock database over HTTP
using JDBC; see Connecting to GeoSpock database using JDBC

Install the CLI using the instructions provided by Presto.

Use the following command to connect to GeoSpock database:

presto --server https://<host>:8446 --user <user> --password

Where:

<host> is the hostname of GeoSpock database; for example: sqlaccess.<platform_domain_name>. So, for example, if your platform domain is geospock.example.com, set <host> to: sqlaccess.geospock.example.com
<user> is your GeoSpock database username

You will then be prompted for the password to your GeoSpock database account.

If you get an authentication error when running a query, check the username and password used to connect to GeoSpock database.

The CLI accepts queries that span multiple lines but your query must end with a semicolon ;

For example:

SELECT COUNT(*) FROM geospock.default.smallpoi;