Running Queries in the Web Console
The standard SQL is a declarative language that allows you to obtain the data you want without having to specify the detailed process of data processing. However, the standard SQL has many constraints on processing unstructured data, as well as the drawback that the description of the streaming process is not natural.
Logpresso has inherited the design philosophy of Unix-based operating systems that maximize simplicity, cohesiveness, reusability, and flexibility. One command performs the smallest and the simplest task, but combining multiple commands helps effectively process complex and unstructured data.
The following sections describe how to use queries in the Logpresso web console and the basic structure of Logpresso query.
Query Menu Path by Product
You can use queries in the Logpresso web console. There are many interfaces where you can input query string, but a separate interface for running queries is also provided. The query menu by product suite is as follows:
- ENT, STD: Query or Query > Query
- MAE, SNR: Analysis > Query
Executing a Query
To execute a query, input the query string in the input box and click Run. The query string may be a short statement using a single command or may consist of multiple commands where data is passed from one to the next using pipes (|
).
Query Keyboard Shortcuts
Query input box supports following keyboards shortcuts.
Query Keyboard Shortcuts
Function | Keyboard shortcut |
---|---|
Executing a query | Ctrl+Enter or Shift+Enter |
Viewing the command list and help | Ctrl+Space |
Automatic alignment and indentation of query | Ctrl+Shift+F |
For viewing the command list or help (Ctrl+Space), the operation varies depending on whether you input a command.
- If you press the shortcut keys without providing a command, you can see the command list appears.
- If you press the shortcut keys after providing a command, you can see a list of options available appears.
Automatic alignment and indentation of query commands help the user understand long query commands written across multiple lines by automatically applying indentations and line breaks. This shortcut is only supported by MAE and SNR.