Example JDBC data source template for Cloudera Apache Hive connectivity.

Example JDBC data source template for Cloudera Apache Hive connectivity.

Below is an example JDBC data source template for Cloudera Apache Hive.

<
jdbc-type-settings
>

<
type-name
>cloudera_hive<
/type-name
>

<
driver
>com.cloudera.hive.jdbc41.HS2Driver<
/driver
>

<
connection-url-pattern
>jdbc:hive2://host:port10000/database<
/connection-url-pattern
>

<
supports-catalogs
>false<
/supports-catalogs
>

<
supports-schemas
>true<
/supports-schemas
>

<
supports-procedures
>false<
/supports-procedures
>

<
ping-command
>SHOW TABLES<
/ping-command
>

<
column-name-pattern
>`$$name$$`<
/column-name-pattern
>

<
table-name-pattern
>`$$name$$`<
/table-name-pattern
>

<
schema-name-pattern
>`$$name$$`<
/schema-name-pattern
>

<
catalog-name-pattern
>`$$name$$`<
/catalog-name-pattern
>

<
procedure-name-pattern
>`$$name$$`<
/procedure-name-pattern
>

<
column-alias-pattern
>`$$name$$`<
/column-alias-pattern
>

<
/jdbc-type-settings
>