Requirements and compatibility¶
Querona operates as a Windows Service and is entirely self-hosted, therefore no additional Windows components are required, besides explicitly stated dependencies below.
Querona makes the following recommendations for Querona Server deployments:
- A dedicated machine to simplify tuning, management, and diagnostics
- Windows Active Directory
- Multi-core server hardware with two or more cores for production deployments
The disk I/O performance of any modern server-class system should be sufficient. Memory requirements are highly dependent on the product target usage, but 8 GB of RAM may be sufficient for deployments that do not heavy utilize built-in Apache Spark. For small deployments, 4 GB of RAM is sufficient and should be considered a minimum, unless the specific deployment is tested and verified to require less memory.
Supported database management systems for caching¶
Querona supports multiple database platform to cache and process materialized data:
- Apache Spark 2.3.x (built-in)
- Apache Spark 2.2.x
- Apache Spark 2.1.x
- Apache Spark 2.0.x
- Apache Spark 1.6.x
- Azure HDInsight v3.4..3.6
- IBM DB2
- SAP HANA
- Microsoft SQL Server
- Microsoft SQL Data Warehouse
- Microsoft Azure SQL
Deployment of each of the platforms is project specific. Please follow the recommendations and practices documented by respective vendors.
Regarding Spark 2.1.1 - there’s a known bug that causes this version to fail during startup. Please contact us if you are using this version of Spark.
Server operating systems¶
- Windows Server 2016 (Essentials, Standard, Datacenter)
- Windows Server 2012 R2 (Essentials, Standard, Datacenter)
- Windows Server 2012 (Essentials, Standard, Datacenter)
- Windows Server 2008 R2 (minimum SP1) (Standard, Enterprise, Datacenter)
Server core Windows Server installations are not supported.
Querona Server can be installed on a 64-bit Windows operating system. We recommend using a server OS unless your Querona instance is for evaluation or personal use.
Client operating systems¶
- Windows 10 x64 (Professional, Enterprise)
- Windows 8.1 x64 (Professional, Enterprise)
- Windows 7 x64 (minimum SP1) (Professional, Enterprise, Ultimate)
Required platforms and components¶
.Net Framework 4.7.2 or later¶
.Net Framework system requirements documentation is available from Microsoft.
If your system does not have required .Net Framework version built-in, please download it from Windows Update or from an offline installer, that can be found under .Net 4.7.2 offline installer .
Oracle JRE x64 v8 or higher (optional)¶
If compatible JRE is found at the time of installation it will be automatically used. In other cases, a build-in Zulu JRE 1.8 will be installed and used as Java runtime.
YouNeedIT supports the virtualization of Querona Server in supported virtualization environments: Microsoft Hyper-V or VMWare. Other platforms were not tested with Querona but every virtualizer that is certified to work with supported version of Windows should work fine.
Querona requires two databases for operations:
- Metadata database, where Querona keeps its metadata.
- Apache Spark MetaStore database, where Spark keeps its metadata.
Both databases do not depend on each other and can be hosted using different technologies.
For user convenience and quick deployment in development, test or evaluation scenarios, Querona supports a built-in SQLite file database for metadata storage and Derby for Apache Spark.
The following database technologies are supported:
|Metabase owner||Supported technologies|
|Querona||SQLite (built-in) Microsoft SQL Server 2012 or later SQL Azure|
|Apache Spark||Derby (built-in) Microsoft SQL Server 2012 or later SQL Azure|
The following versions of SQL Server are supported for Querona MetaBase and Apache Spark MetaStore:
- SQL Server 2016 or later
- SQL Server 2014 or later
- SQL Server 2012 (minimum SP1)
Your limits on database read operations¶
YouNeedIT does not support any read operations against the Querona or Apache Spark databases that originate from queries, scripts, .dll files, and so on, not provided with Querona or by its support teams. If Support determines that those read operations prevent them from solving your problem, the entire database will be unsupported. To return the database to a supported state, all unsupported read operations must stop.
SQL Server editions¶
Querona supports the following editions of SQL Server and SQL Azure as metadata store:
- SQL Azure v11 or later.
The SQL Express edition is recommended only for evaluation purposes, personal use, or for small teams. We recommend SQL Server Standard, Enterprise or SQL Azure v11 or later for all other scenarios.
You can install Querona on a single server that is joined to an Active Directory domain or that is a member of a workgroup.
Active Directory environment is not required by Querona but is fully supported and recommended for enterprise deployments.
Querona Server requires a service account. That service account becomes the user identity of the installed Windows Service handling requests to Querona.
During installation, you have to specify a user account. The Log on as a service permission will be granted by installer automatically. You must not use the account that you use to install Querona. For example, if you are logged in as domainuser1 when you install Querona, do not use domainuser1 as the account for Querona.
Service account should not be a member of Local Administrators group on Windows. In such case, required permissions will be granted to Administrators group, not the account itself. If at a later time, such account administrators group membership is revoked, you will have to manually grant necessary permissions or reinstall Querona.
Installer grants Log on as a service permission to selected account only during installation.
You may use different accounts to install and run Querona Server:
- Dedicated local account
- Dedicated domain account
Best practices for accounts:
- use Network Service or a dedicated domain account, because they present network credentials, allowing Querona to transparently authenticate against data sources that support Windows Integrated Authentication
- use accounts that have permissions to authenticate users against a domain, because it allows Querona to authenticate incoming users by Windows Integrated Authentication
It is not recommended to manually change service account after installation. Please reinstall Querona Server if you need to change the service user account.
If re-installation of Querona Server is not desired or possible, and manual change of service account after installation is absolutely necessary, you must ensure that:
- the Log on as a service permission is granted to the new service user,
- the read and write permissions to Apache Spark warehouse directory are granted to the new service user,
- necessary permissions to access Querona metabase and Spark metabase deployed on SQL Server are granted to the new service user,
- necessary permissions to access data sources are granted to the new service user,
- necessary http.sys port reservations are available to the new service user.
Querona can scale from a basic installation on a laptop used by a single person all the way up to a highly available deployment used by thousands of people. The following recommendations should apply to most Querona deployments, but your requirements may vary depending on the usage of your team. For example, if you have particularly large data set that you want to materialize using built-in Apache Spark, you may need higher specification machines than what is listed below. Note that all of the machines discussed below could be either physical or virtual.
A single machine, with one dual-core processor, 8 GB of RAM, and a fast hard disk drive. Scaling server up can enable it to handle a larger number of users and workload.
For evaluation or personal use, you can use a basic configuration with as little as 4 GB of RAM, but clearly, this would not be recommended for a production server used by more than one person.
You can install Querona on supported operating systems in various languages. However, Querona user interface is available only in US English.
You can use these browsers with Querona to access it with the web client.
|Browser||Supported Version||Known issues|
|Chrome||most recent (recommended)|
|Internet Explorer||11 and later||May not render Apache Spark application portal properly. For example, query plans will not show up|
Edge, Firefox, and Chrome automatically update themselves, so Querona supports the most recent version.
Querona software may be provided with certain third-party software, including but not limited to open-source software, which is licensed under its applicable third-party software license agreement. For license information about third-party software distributed with Querona software, refer to your Querona license agreement and the 3rd-party-licenses.txt file.