During the installation of BigInsights 4.x, the Big SQL data-directory field (bigsql_db_path) is left with the default value. This places the Big SQL database storage paths under the /var directory, which is usually on the root file system on internal storage. You should redefine the Big SQL storage paths to use multiple file systems on external storage. Follow these steps to change the storage paths …
For each configuration XML file of a stack service, Ambari web UI displays an Advanced section and a Custom section. Custom section allows users to add additional properties to the configuration XML file.
When integrating your own services to the stack, or adding new configurations to existing services, you can hide the custom sections on the Ambari web UI so that end users can not insert additional properties to the configuration.
Big SQL LOAD and ANALYZE are implemented as MapReduce jobs. Like any other MapReduce job, configuring YARN and MapReduce memory properties is key to running LOAD and ANALYZE optimally. MapReduce jobs tend run into OutOfMemory java errors if YARN and MapReduce memory settings are too small; If the properties are too large, the number of concurrent map and reduce tasks will decrease, also negatively impacting performance and wasting memory.