The following information lists miscellaneous requirements, tips and suggestions for working with the Apache Drill connector. The purpose is to help you achieve stable performance and avoid issues when you access your data from Apache Drill Spotfire.
Tip |
Description |
DSN information |
When you create or select a DSN to use for creating a connection to Apache Drill in Spotfire, consider the following:
|
Use well-defined views |
For stable performance, it is recommended that the Apache Drill data that you want to analyze in Spotfire is properly configured and has a well-defined schema. Data with dynamic schemas and that has not been properly configured can cause unpredictable issues and exceptions, where Apache Drill fails to execute queries. |
Apache Drill data must be available as views |
The data that you want to access in Spotfire must be available as views in Apache Drill. Data that is not available as a view in Apache Drill is not displayed when you select data in the Views in Connection dialog. However, you can access data that is not available in a view by using custom queries. |
Some Drill plugins might affect performance |
Apache Drill systems can connect to data in a range of different types of data sources. To achieve this, various plugins are used. Different plugins might cause varying performance in Spotfire. |