Quick Reference Sheets¶
One page sheets designed for printing out. Click links to download.
Details for Kognitio drivers and access:
JDBC driver 8.2.1 to 8.2.3- this is the legacy JDBC driver for use with Kognitio 8.2.3 or earlier.
Quick reference for SQL synatax for:
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:
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:
KogSQL- command-line JDBC client tool, designed for interactive use.
For loading and unloading data from the command line:
For administrators there are various utilities for backing up and restoring Kognitio to different locations: