The driver enhances the data source's capabilities with additional client side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, and so on.
See Data Model for information on the available entities and how to query them. No caching: Work with remote data only.The replication commands allow for intelligent incremental updates to cached data. Replication: Copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, and so on.Save data for later offline use or enable fast reporting from the cache. Autocache: Automatically cache data to a lightweight database.See Caching Data to configure replication and caching for a range of scenarios common to remote data access.
See SQL Compliance for a syntax reference and code examples outlining the supported SQL. JDBC remoting is enabled using the popular MySQL wire protocol server. NET, C++, PHP, Python, and so on) and using any standards-based technology (ODBC, JDBC, and so on). The JDBC remoting feature allows hosting the JDBC connection on a server to enable connections from virtually anywhere - various clients on any platform (Java. See JDBC Remoting to configure remote access to the JDBC data source. Query the System Tables to access additional metadata, such as data source capabilities. See Schema Discovery to access schema information through the standard JDBC interfaces. Using from Tools walks through the steps of integration with JDBC tools, using several popular database tools as examples. See Using JDBC for examples of using standard JDBC classes like DataSource, Connection, Statement, ResultSet, and others, to work with Apache Hive data. See the Apache Hive integration guides for information on connecting from other applications. See Getting Started for A-Z guides on authenticating and connecting to Apache Hive data.
Write SQL to retrieve and update Apache Hive data.Deploy a single JAR that does not rely on client-side libraries.The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Applications can then access Apache Hive as a traditional database. The driver wraps the complexity of accessing Apache Hive data in an easy-to-integrate, 100%-Java JDBC driver.