Post-installation configuration#

The following sections walk you through post installation configuration using Querona Admin Portal.

Product License#

Querona requires a valid license to serve requests over TDS endpoint. Without a valid license, only Querona Admin Portal is functional. All view materialization requests and most of federated queries will fail until a valid license is provided.

To upload a license login Querona Admin Portal with administrative privileges and follow these steps:

  1. Navigate to Administer ‣ License and click Change license

  2. Copy the license text from the medium - be extra careful to copy only the text, because any control characters or formatting will prevent the license to be validated

  3. Paste the license text (Xml) into the textbox. If the license is valid, Save button will be enabled

  4. Click Save to activate the license

  5. If server-side validation succeeds, you will be presented with license details including license type, begin and end date, and other properties of a license issued to your organization.

Encryption of incoming connections#

Follow the Encrypt incoming connections to configure Querona to accept only encrypted connections.

Apache Spark configuration tasks#

Driver and Executor memory#

Installer tries to adjust the configuration, based on the available physical RAM and cores. To adjust the settings manually, navigate to Administer ‣ Local Spark instances and configure Driver memory and Executor memory to values that match the amount of RAM you want to assign to Querona’s Apache Spark instance.

Engine configuration#

Adjust the Row count of tables without statistics parameter described in Engine configuration to a value that reflects the average real row counts in tables that you plan to use. This setting is important because when no statistical information is known to Querona, it assumes the value from Row count of tables without statistics. If the value is far from reality, the query optimizer may choose a suboptimal plan that hinders performance.

It is recommended to calculate at least row count statistics for all objects in virtual databases. If such operation would take too long, object statistics can be entered manually.

Virus scanning recommendations#

Important

This chapter contains information that shows how to help lower security settings or how to temporarily turn off security features on a computer. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing them in your particular environment, and to take any appropriate additional steps to help protect the computer.

This chapter contains recommendations that may help an administrator running Querona Server to optimize performance of Querona and Windows operating system, when it is used with antivirus software in a managed business environment.

Action

Description

Turn off real-time scanning of Apache Spark storage

Exclude Apache Spark warehouse data and temporary folders from real-time antivirus scanning:

  • %ProgramData%\Querona\warehouse

  • %ProgramData%\Querona\tmp

Turn off real-time scanning of Querona and Apache Spark log files

Exclude Apache Spark log directory:

  • %ProgramData%\Querona\logs