How to join Amazon S3 and Cloudera Impala
Discover how to join Amazon S3 with Cloudera Impala for integrated analysis.
WITH DATA VIRTUALITY PIPES
Replicate Amazon S3 and Cloudera Impala data into one target storage and analyze it with your BI Tool.

About Amazon S3
Amazon Simple Storage Service (Amazon S3) is an object store with a simple web service interface. Users can retrieve and store any amount of data from anywhere in the Internet. Customers use Amazon S3 as primary storage for cloud-native applications, mass repositories, or datalake, for analysis, as a backup and recovery target, as well as disaster recovery and serverless data processing.
About Cloudera Impala
Cloudera Impala is an open-source massively parallel processing (MPP) SQL query engine for data running Apache Hadoop stored in computer clusters. This ways Impala brings scalable parallel database technology to Hadoop, enabling users to issue low-latency SQL queries to data stored in HDFS and Apache HBase without requiring data movement or transformation.
MOVE YOUR DATA WITH PIPES
Pipes allows you to connect to Amazon S3, Cloudera Impala and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.
DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS
depending on your needs.

Pipes
Easy and reliable data replication in the cloud
Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional
Advanced data replication hosted in the cloud or on-premises
Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.
Pipes Professional features include:
- Cloud/On-Premises Hosting
- Complex Data Transformations
- Advanced Jobs & Schedules
- Multiple Target Storages
- Custom Extraction Definitions
- Job Dependencies
- SQL Modelling Layer
- Complex Replication Types
- Custom Job Triggers