This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Below are steps to configure the Hive Account in SnapLogic to connect to a Hive Database on HortonWorks
Step 1:
Go to Product Downloads | Cloudera and download the HortonWorks JDBC Driver for A...
When we try connect to hive. from snaplogic we are seeing below issues
Failed to validate account: java.lang.NoClassDefFoundError: Could not initialize class org.apache.hive.jdbc.HiveConnection C...
Hi,
I want to execute multiple queries in Hive execute snap. See the below example
I want to use the database name and create a external table in the particular database . I could not able to a...
We are trying to write data into HDFS as ORC file. There is a ORC writer snap that is available for Standard Mode pipelines. The Snap configuration requires Hive Metastore URL. When we are p...
Hi,
I am trying to connect hive server hosted on AWS ec2 machine which is in private subnet. I am using bastion host and tunneling process to connect to hive in sql-workbench and tableau. when i a...
Created by @pkona
Integrations involving ingesting data into Hive requires creating tables on Hive and creating the schema for data formats like Avro.
This pattern generates the AVRO schema b...
Pattern 3 - Step 1.1 - Ingest - Generate Hive table Avro based on Oracle Table metadata.slp (23 KB)
I’m looking for information on how to set up Kerberos on the SnapLogic groundplex for authentication to Cloudera. I want to use Hive account and snap pack. I see this documentation:
https://docs-s...
...nd Hive tables
Automatically shards large tables
Ingests data into HDFS+Hive tables
All the pipeline execution is done to maximize parallelized execution of the child pipelines across multiple n...
Pattern 3 - Step 1.2 - Oracle to Hive No Sharding_2018_08_24.slp (16 KB)
Pattern 3 - Step 1.1 - Ingest - Generate Hive table Avro based on Oracle Table metadata_2018_08_24.slp (22 KB)
Pattern - Core - Query Hive Table Metadata_2018_08_24.slp (6 KB)
Pattern 3 - Step 1.2.1 Oracle to Hive - process a shard_2018_08_24.slp (10 KB)
Pattern 3 - Step 1.0 - Oracle to Hive Parent_2018_08_24.slp (15 KB)
Anyone successfully use Snaplogic to manage their ETL hive queries?
One of the main capabilities I need is the ability to dynamically initiate pipelines / hive queries based on table references....