Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Once you've pasted the Cloudera JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Cloudera and connect.

Image Modified

Using Cloudera Connector Drivers to Connect to Cloudera

...

Once you've pasted the Mapr JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Mapr and connect.

Image Modified

Connecting to an Amazon EMR Distribution of Hive

...

Info

Note: When using the Amazon Connector driver version 1.0.4, it is recommended that you add this parameter - ?UseNativeQuery=1 to the Server Properties->Driver->Parameters field. This alleviates an issue related to the way the JDBC drivers handle complex data columns.

Image Modified

Using Apache Hive JDBC Drivers to Connect to Amazon EMR

...

Once you've pasted the Apache Hive JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Amazon EMR and connect.

Image Modified

OSX Driver Location Navigation 

To get to the driver location in OSX, select "Finder". Select "Applications". Locate the Aqua Data Studio app and right click on it. Select "Show Package Contents" 

Image Modified