Background You have an EXASolution database and want to connect it via JDBC to Hive for using EXAloader IMPORT/EXPORT statements. Prerequisites Choose one of the following drivers: Cloudera Hive JDBC driver: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-5.html Simba Hive JDBC driver: https://www.simba.com/product/apache-hive-driver-with-sql-connector/?attribute_pa_license-type=evaluation&attribute_pa_os=java&attribute_pa_client-server=server How to create and work with a Hive JDBC connection? Step 1: Configuring the JDBC driver in EXAoperation:    Step 2: Create or replace connection -- Connecting EXAloader via Cloudera Hive driver and Simba Hive driver to Cloudera, MapR and Hortonworks Hadoop distributions -- cloudera-quickstart-vm-5.13.0-0-vmware create or replace connection hive_conn to 'jdbc:hive2://192.168.42.133:10000' user 'cloudera' identified by 'cloudera' ; -- MapR-Sandbox- For -Hadoop-6.1.0-vmware create or replace connection hive_conn to 'jdbc:hive2://192.168.42.134:10000' user 'mapr' identified by 'mapr' ; -- Azure Hortonworks Sandbox with HDP 2.6.4 create or replace connection hive_conn to 'jdbc:hive2://192.168.42.1:10000' user 'raj_ops' identified by 'raj_ops' ; Step 3: EXPORT/IMPORT EXPORT test for Cloudera and Simba driver export exa_syscat into jdbc driver = 'HiveCloudera' at hive_conn table exa_syscat created by ' create table exa_syscat ( schema_name varchar (128), object_name varchar (128), object_type varchar (15), object_comment varchar (2000))' replace ; export exa_syscat into jdbc driver = 'HiveSimba' at hive_conn table exa_syscat created by ' create table exa_syscat ( schema_name varchar (128), object_name varchar (128), object_type varchar (15), object_comment varchar (2000))' replace ; IMPORT test for Cloudera and Simba driver import into ( schema_name varchar (128), object_name varchar (128), object_type varchar (15), object_comment varchar (2000)) from jdbc driver = 'HiveCloudera' at hive_conn table exa_syscat; import into ( schema_name varchar (128), object_name varchar (128), object_type varchar (15), object_comment varchar (2000)) from jdbc driver = 'HiveSimba' at hive_conn table exa_syscat;  
View full article