Page History
...
| Info |
|---|
| If you need to connect to Mapr, Hortonworks, or Cloudera distributions of Hive, you must remove the Apache Hive JDBC Drivers that come preinstalled in <ADS_INSTALL>/lib/drivers. Replace them with drivers from your distribution before you choose a new distribution type in the Distribution drop-down within the General Tab. Follow the steps to connect to Hortonworks, Cloudera, or MapR Distributions of Hive on the Apache Hive JDBC Drivers page. |
| Table of Contents |
|---|
General Tab
Before choosing any distribution in the Distribution drop-down, make sure you follow the instructions in the Apache Hive JDBC Drivers page about how to replace the current drivers with those from your Hive Distribution.
...
- Always Display Column Name in Results: Allows to show/hide column names in query results.
- Enable DB Filters for Query Window: Enables/Disables db filters for query windows using this connection.
- Only Display Databases that User has Access to: Displays only the databases the current user (from the Login Name on the General tab) has access to within the schema browser.
- Fetch Size: determines the Fetch Size (number of rows physically retrieved from the database at one time by the JDBC driver).
- Connections Pooled: Enables connection pooling. Read more about connection pooling here.
- Force Auto-Commit: When this option is selected, it sets auto-commit to TRUE for any Query Window to this server and disables the icons on the toolbar.
- Group Table and View Objects:
- Show Table Extended (Single query to group table and view objects) -
- Show Table (Merge table and view objects) -
- Show Table and Describe (Separate query per object) - - Data Warehouse Mode: Read Only or Read/Write
- Object Folder Display: [Default], [Name], [Schema].[Name] or [Name]([Schema]) sets how the Schemas will be displayed.
...
For more information, see Connection Monitor.