System Requirements
This topic covers system requirements for standalone clusters including general requirements for Hadoop on YARN and MapR on YARN deployments.
Operating Systems
Dremio supports the following distributions and versions of Linux:
- RHEL and CentOS 6.7+ and 7.3+ (RPM and Tarball)
- SLES 12 SP2+ (Tarball)
- Ubuntu 14.04+ (Tarball)
- Debian 7+ (Tarball)
Java Development Kit
Dremio requires that Java SE 8 (also known as JDK 1.8) be installed. Supported distributions are OpenJDK and Oracle JDK. Other versions are currently not supported.
Dremio utilizes the Java compiler (javac
) for runtime code generation.
You can check to see if your operating system has Java installed (and which version) with this command:
$ java -version
You can download the latest version of Java SE from the Oracle website.
Server or Instance Hardware
The following hardware are minimum recommendations basedon the Dremio service enabled on the node.
Dremio Node Role | Hardware Required |
---|---|
Master-Coordinator | 8 CPU cores recommended 16GB RAM recommended |
Executor | 4 CPU core minimum (16 cores recommended) 16GB RAM minimum (128GB recommended) Note: Even if you have a machine with 64GB of RAM, only 16GB is used by default. To change this setting, modify the DREMIO_MAX_DIRECT_MEMORY_SIZE_MB property in the dremio-env file and restart the executor node(s). |
Network
There should be a low-latency, high-bandwidth network connection between Dremio and the data sources.
The following ports must be open:
Purpose | Port | From | To |
---|---|---|---|
UI (HTTPS) | 9047 | Corporate network (end users) | Coordinators |
ODBC/JDBC clients (e.g., Tableau, Power BI) | 31010 | Corporate network (end users) | Coordinators |
ZooKeeper (internal) | 2181 | Other Dremio nodes (coordinators and executors) | Coordinators |
Inter-node communication | 45678 | Other Dremio nodes | All Dremio nodes |
Data source reads | Varies | All Dremio nodes | Data source nodes |
Web Sockets
Dremio uses Web Sockets. If you encounter the following error message: "Your Internet connection may be offline, or WebSockets to Dremio are being blocked.", ensure that your environment allows WebSocket communication.
Performance
A 10 GbE network is recommended when connecting to large data sources that hold terabytes or petabytes of data.
In particular, for maximum performance, it is recommended to use a 10 GbE network between coordinators and executors, executors and executors, and executors and data sources.
Privileges
To install Dremio, the following access privileges are required:
ssh
andscp
accessroot
orsudo
privileges
Best Practices
For Unix/Linux operating systems, increase your open file limit for users (this impacts the Dremio processes) to 65536.
If you have a machine with a large amount of RAM (for example, 64GB), increase Dremio's default settings for either the direct memory RAM setting or the HEAP setting. A recommended HEAP value is 8GB.
To increase Dremio's RAM setting:
- In the dremio-env file, modify either the
DREMIO_MAX_DIRECT_MEMORY_SIZE_MB
orDREMIO_MAX_HEAP_MEMORY_SIZE_MB
property.
See Configuring Memory for more information. - Restart the executor node(s).
- In the dremio-env file, modify either the
[warning] Warning: For the
DREMIO_MAX_DIRECT_MEMORY_SIZE_MB
allocation, be sure to leave at least 1-2 GB of memory for the OS.
- To verify the memory assigned to the nodes (heap and direct), run the following query:
SELECT * FROM sys.memory