The Deephaven Query Cookbook

The Deephaven Query Language is easy to learn, but most people want to jump on in without combing through many of the details. That's exactly where the Deephaven Query Cookbook comes into play. Each recipe in the cookbook provides a set of scripts to accomplish commonly used key tasks.

Depending upon your learning style, you can read the short explanations for each step and then run the provided code against our sample data, or you can copy our queries and adjust them as needed to run against your own data. This helps you move quickly from problem to solution, saving you time each step of the way.

Note: For those who are not at all familiar with Deephaven, please first take a look at the Quick Start Guide. The Quick Start Guide is designed to familiarize new users with the interface, provide examples of using the Deephaven query language to generate tables and plots, save queries, and build a customized workspace.

The Deephaven Query Cookbook is divided into the following sections:

Basic Capabilities provides a look at the core functionality for querying within Deephaven.
Join Methods focuses on the unions of different tables.
Plotting demonstrates methods for visualizing data.
Time provides examples of how to work with and manipulate time in your queries
More to Know provides additional functionality to take your querying to the next level.
Practical Examples is a collection of basic to advanced examples for real-life scenarios.

Each chapter is then further divided into specific recipes that then demonstrate a variety of operations. At the end of each section, you can copy the entire script or only certain snippets to use as a reference or as a source for further experimentation on your own.

The Groovy and Python scripts used in the Query Cookbook are also available for download as premade Deephaven Notebooks. To learn more about using Deephaven Notebooks, please refer to the Notebook section of the User Manual.

Download the Query Cookbook Notebooks

All of the scripts contained in this section can be used with the data found in the LearnIris namespace, which should already be installed with Deephaven. (Contact your system administrator if the data is not installed.)

If you have any questions along the way, refer to the Deephaven User Guide, where you can review the Deephaven documentation or watch our instructional videos.

Last Updated: 23 September 2019 12:17 -04:00 UTC Deephaven v.1.20181212 (See other versions)