What is the difference between a Hive JDBC connection and a regular Hive connection?

Hive data source can be connected in two ways, as a JDBC data source and as a normal hadoop data source. This article clearly explains the difference between those two connections.

Linux

In the official documentation of TIBCO Spotfire Data Science, we have two types of connection to Hive data source. 

1. Hive as a JDBC Data source

When you connect Hive as a JDBC data source, you can only use non-analytical operators in the workflow. This type of connection is made when users have restrictions to access the HDFS file system on the Hadoop platform. 

Please refer to the following document to connect TIBCO Spotfire Data Science to a Hive JDBC Data source. 

2. Hive as a regular Hadoop Data source

When you connect Hive as a regular Hadoop data source, you can access both analytical and non-analytical operators in the workflow. When users don't have any restrictions to access the HDFS file system on the Hadoop platform they can make this type of connection to TIBCO Spotfire Data Science. 

Please refer to the following document to connect TIBCO Spotfire Data Science to Hive as a regular Hadoop data source. 

To understand the difference between analytical and non-analytical operators please refer to the following document. 

NOTE: Hive is a service that runs on top of the Hadoop platforms like Cloudera, Hortonworks, etc.