Quick Reference Sheets

One page sheets designed for printing out. Click links to download.

Accessing Kognitio

Details for Kognitio drivers and access:

Kognitio SQL

Quick reference for SQL synatax for:

Connectors

Kognitio external connectors are designed for fast access to data sources that are external to Kognitio:

A number connectors come as standard with the Kognitio software:

  • Hive - data held in Hive tables as ORC, Parquet or text

  • AWS Glue - data held in AWS Glue tables as ORC, Parquet or text

  • Amazon S3 - data held in AWS S3 object store

  • HDFS - data held in HDFS file system

  • MapR-FS - data held in MapR-FS file system

  • ORC and Parquet - data from ORC or Parquet format files

  • Kognitio Crossload - parallelised access to data from another Kognitio system

  • Map Reduce - data held in HDFS with filtering pushed down to map reduce

  • ODBC - data held in other databases accessed via ODBC

  • JDBC - data held in other databases accessed via JDBC

  • Unloader Connector - use Kognitio’s bulk unloader to access data from other Kognitio systems

The attributes to configure connectors are largely common to all connectors:

Client Utilities

There are a number of client tools shipped with the Kognitio software that are accessible from the command line. These are also available in the Client Tools Bundle. See the Kognitio Downloads page for details

Utilities for submission of SQL:

For loading and unloading data from the command line:

For administrators there are various utilities for backing up and restoring Kognitio to different locations: