IBM Netezza Fluid Query User Guide

IBM Fluid Query is a data connector that helps you connect data from a variety of sources to the IBM Netezza analytics platform.


IBM Netezza Fluid Query User Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
69
File format
PDF
File size
650 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
BE54CF9F3907F53D70F0D185F9F702C6

About this manual

IBM Fluid Query is a feature for the IBM Netezza platform. This guide describes how to install, configure, and use the data connector and data movement capabilities for querying and accessing data stored in Hadoop service providers.

The data connector can create connections to Hadoop systems such as IBM BigInsights, Cloudera, and Hortonworks. It supports JDBC-based connections to Hive2, BigSql, and Impala services, with only READ operations supported.

What's inside

  • Data connector
  • Data movement
  • Software prerequisites
  • Configuring a connection
  • Registering the data connector functions
  • Data connector command reference
  • Data import configuration
  • Data export configuration
  • Data movement troubleshooting
  • Notices

Specifications

Release1.0
Supported Hadoop service providersIBM BigInsights, Cloudera, Hortonworks
Supported servicesHive2, BigSql, Impala
Supported SQL operationsREAD operations only
NPS release 7.0.2.x IBM Netezza Analytics releasesMinimum 2.5, recommended 2.5.4

Frequently asked questions

Which Hadoop service providers can IBM Fluid Query connect to?

It supports connections to IBM BigInsights, Cloudera, and Hortonworks systems.

What SQL operations are supported by the data connector?

Only READ operations are supported.

Where must JDBC driver files be stored on the NPS appliance?

They must be saved in the directory under /nz/export/ae/products/fluidquery/ shown for each provider.

What are the IBM Netezza Analytics release requirements for NPS 7.0.2.x?

The minimum release is 2.5 and the recommended release is 2.5.4.

Download PDF (650 KB)

More IBM Manuals


View all IBM manuals →