Introduction
At the Construction stage, the query editor allows the user to write his query in HQL language as well as to launch an execution.
Functioning
The editor
When writing the query, the editor highlights the functions used.
It's possible to order your query as you wish via line breaks or tabs.
The keyboard shortcut CTRL + Z allows you to undo the last action performed.
Saving
It is possible to save your query at any time by clicking on the Save button or via the keyboard shortcut CTRL+ S.
Starting an execution does not save the query.
At sharing time, it's the query present in the editor that will be saved and shared.
The result of execution
It is possible to run a query execution to preview the result.
The total number of rows present in the result is displayed.
The result, in turn, displays only a sample of the first 100 rows as well as all selected columns.
The execution result expires after 3 days.
Note:
- To achieve a result, a query must run entirely in less than 30min.
- It is only possible to launch 3 executions in parallel.
Further reading
Learn more about the HQL language