Cloudera Hive
The Cloudera Hive connector provides read-only access to data and metadata in Cloudera Hive.
A connection admin can set up a connection to Cloudera Hive in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Cloudera Hive. This allows users to access Cloudera Hive data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see Managing data fabric tables.
A primary connector in preview is fully functional for its documented scope and receives the same ServiceNow support as other primary connectors. For details on specific functionality limitations, see KBB0010487.
The connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.
- Sort
- Limit
- Filter
- GroupBy
- avg()
- count()
- max()
- min()
- sum()
- References
Supported data types
The following table lists supported Cloudera Hive data types and the default matching data types in a data fabric table.
| Cloudera Hive | Data fabric table |
|---|---|
| BOOLEAN | Boolean |
| TINYINT | Long |
| SMALLINT | Long |
| INTEGER | Long |
| BIGINT | Long |
| REAL | Decimal |
| FLOAT | Decimal |
| DOUBLE | Decimal |
| NUMERIC | Decimal |
| DECIMAL | Decimal |
| CHAR | String |
| VARCHAR | String |
| DATE | Date |
| TIMESTAMP | Date/Time |
| BINARY | File attachment |