Advanced Topics

This section contains a set of topics about advanced usage scenarios with Dremio:

• Configuration Files - Reference information about the dremio.conf and dremio.env configuration files.
• Connect to a Ranger Host use SSL - Connect a Ranger host using Secure Socket Layer (SSL) in Dremio.
• Creating and Querying Wide Tables - Create wide tables in Dremio and make them available for queries.
• Dremio Preferences - Customize the behavior of specific features in the Dremio console.
• Gandiva-based Execution - Learn about Gandiva, supported functions, and limitations.
• Hash Aggregation Spilling - Learn about hash aggregation spilling implemented in Dremio, how to enable/disable it, and the limitations.
• Query Relational Database Sources Directly - Run external queries against relational-database sources.
• Ranger-Based Authorization - Check the Apache Ranger policy permissions and then allow/disallow access as defined by the Ranger policy.
• Refresh Metadata - Learn more about automatic refreshes, scheduling refreshes, triggering refreshes, and limitations in how metadata is refreshed.
• Runtime Filtering - Improve query performance with runtime filtering.
• S3 on Amazon EMR Configuration - Configure for S3-backed Hive tables on Amazon EMR.
• Start, Stop, and Status - Learn how to start up and shut down Dremio on YARN and non-YARN deployments for RPM and Tarball installations.
• Upgrade with Custom Sources - Follow steps to safely enable functionality of new features when you upgrade Dremio if your environment utilizes external query (which is only supported via ARP sources).