Execute queries on TimescaleDB

1. Define the SQL query you'd like to run on the database. This example combines time-series and relational data. It returns the average values for every 15 minute interval for sensors with specific type and location.

2. Execute the query with the prepared statement and read out the result set for all a-type sensors located on the floor:

If the command is successful, you'll see output like this:

Now that you're able to connect, read, and write to a TimescaleDB instance from your Java application, and generate the scaffolding necessary to build a new application from an existing TimescaleDB instance, be sure to check out these advanced TimescaleDB tutorials:

• [Continuous Aggregates][continuous-aggregates]
• [Migrate Your own Data][migrate]