Application Options Dialog Box

The Application Options functionality consists of the following option-related sections.

The options selected for a specific query override the application options.

Section Description
General Allows you to set the default query time, adjust the number of the files displayed on the Most Recently Used menus, and switch on or off the Connection pooling functionality.
Hive Options Enables you to set options specific to Hive, including whether to execute queries asynchronously and whether to obtain the log after executing a query.
  • Execute hiveserver2 queries asynchronously - When performing Hive queries, the tool invokes server-side execution for queries and does not wait until each query completes. Instead, it makes constant calls to the server to determine the status of the execution and then updates the execution log with changes.
  • Obtain log after executing a query - If hiveserver2 has the GetLog method, the log is obtained from the server and analyzed for error and warning patterns as specified in the Error Pattern and Warning Pattern boxes. If the GetLog method does not exist, this option is ignored.

The Hive options are not applicable to some distributions of Hadoop, including the IBM BigInsights distribution.

Fonts and Colors Allows you to customize the appearance of the SQL Editor and syntax highlighting.
Shell Integration Allows you to select the type of files to be opened when they are double-clicked in Windows Explorer.
Provides options for managing cached SSH credentials.
Query Analyzer Defaults Allows you to modify the Query Analyzer settings, number of results returned by a query. Enables syntax highlighting, and multiple other parameters.
Object Browser Allows you to configure both default options for the Object Browser, but also double-click behavior from the Object Browser.
Code Auto-Complete Provides access to the various auto-complete code options.

Code Snippets

Allows you to create and edit your own code snippets.
Result Set Options Allows you to edit the output format of the data in the Result Set section.
Output Options Allows you to customize options for the Output pane, including whether you want to enable grid output, text output, and/or custom output.
Premium Grid Options Allows you to enable the premium grid control in Query Analyzer and configure its functionality.
Excel/CSV export Allows you to adjust the default data import and export settings.
Database Highlighting Allows you to use different background colors for the different connections and databases. For details on this functionality, refer to Database Highlighting.
SQL Formatters Allows you to select options for the Workbench SQL formatter and configure the use of external formatters in Workbench. Click Add and specify appropriate settings for each external formatter that you want to add.
DB Script Defaults Allows you to specify which objects must be included in the script by default.

Individual Screens

Aginity Workbench for Hadoop * Topic last updated December 19, 2018