Index

Symbols

& operator ^ operator

| operator || function

A

ABS Access Creating a DSN from Looker from Tableau access from Apache Superset from Apache Zeppelin Access Commands Access control administration, [1] accessing Kognitio ACOS Add disks Kognitio standalone Add Nodes Kognitio standalone ADD_MONTHS Admin SQL Commands Administration Access control, [1], [2], [3] Authentication Configuration, [1] Configuration file, [1] Disk Slabs Disk Usage Encryption Groups, [1] Hardware, [1], [2], [3], [4], [5], [6], [7] Kognitio standalone, [1], [2], [3], [4], [5], [6], [7] Locking Logging Monitoring, [1], [2], [3], [4], [5], [6], [7] Query sessions Queues RAM Usage Recover disk space Recover Space Security classes Starting Kognitio on Hadoop Starting Kognitio standalone Stopping Kognitio on Hadoop Stopping Kognitio standalone Users

Adminstration Configuration External Group Mapping AGE (plugin function) Aliases in Kognitio ALL (comparison function) ALTER GROUP SCHEMA SEC_CLASS SYSTEM TABLE USER ANALYSE_STRING ANY (comparison function) Apache Superset Connecting to Kognitio Apache Zeppelin Connecting to Kognitio arithmetic operators ASCII ASIN Asymmetric Processing; AT Modes ATAN Authentication administration using kerberos AVG

B

BETWEEN BI tools Kognitio and Qlik Sense, [1], [2] Tableau BITCOUNT bitwise AND see & operator

bitwise OR see | operator bitwise XOR see ^ operator BITWISE_AND BITWISE_OR

C

CASE CAST CEILING CHAR CHAR_LENGTH CHARACTER_LENGTH CHR Client tools Quick Reference COALESCE Command line tools: kodoop Command line tools: kodoop cluster Command line tools: kodoop gateway Command line tools: kodoop mgr Command line tools: kodoop server Commandline kodoop CONCAT (plugin function) concatentation Conditional functions Configuration External Scripts runtime parameter Configuration file standalone Connector Avro DDL Syntax, [1] Glue Glue Example Data Hadoop Filesystem URIs HDFS Hive Hive Example Data Kognitio cross-load MapR-FS ODBC ODBC MySQL ORC Parquet S3 Target String Attributes Target String Format Unloader writable CSV writing

CONNECTOR_ID Connectors, [1] Quick Reference COS COSH COUNT Crash Recovery Kognitio standalone CREATE EXTERNAL TABLE GROUP SCHEMA SEC_CLASS TABLE TABLE IMAGE TEMP TABLE TEMPORARY TABLE USER VIEW VIEW IMAGE CREATE OR REPLACE VIEW CUBE CURRENT_DATE CURRENT_SCHEMA CURRENT_SCHEMA_ID CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION_NUMBER CURRENT_USER_ID

D

Data CHAR Decimals Deleting encoding Floating Point Numbers Images Inserting loading using Console loading using wxloader Merging Nulls Numerics Reals Schemas Selecting Strings Tables Types types Unicode Updating VARCHAR Views Data in Kognitio Manipulating Data types Dates Decimals Floating Point Numbers Intervals Numerics Reals Time Timestamps data types using date-times and intervals Data types; Datasets retail, [1], [2], [3] datasets retail, [1] Datasets: retail create (internal) tables create images create MapR tables queries

datasets: retail create external tables create views Datatype Nulls Datatypes CHAR Strings VARCHAR DATE DATE function date-time data types DAYOFWEEK DECODE DEFRAG TABLE IMAGE DEGREES DELETE; Deleting data Demos retail, [1], [2], [3] training DENSE_RANK Deployment Kognitio on Hadoop Kognitio standalone Derived Tables external scripts DESCRIBE DIAGNOSE Disk Slabs administration Disk usage administration DISTINCT FROM DROP GROUP IMAGE SCHEMA TABLE USER VIEW DSN Create from Console DT_INFO

E

EARTH_DISTANCE EDIT_DISTANCE Encryption administration Environment variables Kognitio on Hadoop ERRORCODE ERRORNUM EXCEPT EXEC; Executing commands from SELECT EXISTS EXP EXPLAIN EXTERNAL SCRIPT ALTER CREATE, [1] DEFAULT PARTITIONS DROP INPUT/OUPUT, [1] INPUT/OUTPUT LIMIT THREADS, [1], [2], [3], [4] ORDER BY, [1], [2] RECEIVES RUN ON NODES, [1] External SCripts as derived tables Configuration, [1], [2] External Scripts anonymous bash, [1], [2], [3] Configuration, [1], [2], [3], [4], [5], [6], [7], [8] configuration, [1], [2] creating environment variables Environment Variables Environments formatting input/output, [1], [2] inline input data invocation invoking, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13] ordering data partitioning perl Python, [1], [2], [3], [4], [5] python, [1] R, [1], [2], [3] RAM requirements

External scripts altering creating dropping Invoking External Scripts, concepts External Scripts, introduction External Table DDL Syntax, [1] External tables EXTRACT

F

FACTORIAL FIRST FIRST_DAY FLOOR FOLLOWING (analytic functions) FORMATSTR FROM_UNIXTIME functions all conditional string functions: A to Z; functions: admin DESCRIBE DIAGNOSE EXPLAIN PICTURE functions: aggregate AVG BITWISE_AND BITWISE_OR COUNT LISTAGG MAX MIN ONE_VALUE SAME_VALUE SDEV STDDEV STDEV SUM VAR functions: analytic DENSE_RANK FIRST FOLLOWING LAG LAST LEAD NTILE ORDER BY OVER PARTITION BY PRECEDING query order by clause query partition clause RANGE RANGE window RANK RATIO_TO_REPORT ROW window ROW_NUMBER ROWS windowing clause functions: analytic functions functions: comparision functions: comparison ALL ANY BETWEEN DISTINCT FROM EXISTS ILIKE IMATCHING IN IS NULL LIKE MATCHING OVERLAPS SIMILAR TO SOME functions: conversion FROM_UNIXTIME TO_UNIXTIME functions: date functions: date and time FROM_UNIXTIME TO_UNIXTIME functions: maths; functions: miscellaneous GENERATE_SERIES VALUES BETWEEN functions: OLAP CUBE GROUPING ROLLUP functions: OLAP data set functions: OLAP grouping sets functions: plugin ADD_MONTHS AGE ANALYSE_STRING BITCOUNT CONCAT DT_INFO EARTH_DISTANCE EDIT_DISTANCE FIRST_DAY FORMATSTR FROM_UNIXTIME GETBITS INITCAP INSIDE_POLYGON INSTR IS_DATE IS_NUMBER IS_TIMESTAMP LAST_DAY LTRIM MAPDAY MAPMONTH MONTHS_BETWEEN NEXTDAY POINT POLYGON PROFILE REPLACE REVERSE ROUND RTRIM SINKCHARS SNIPCHARS SUCKCHARS SWAPCHARS TO_CHAR TO_DATE TO_NUMBER TO_TIME TO_TIMESTAMP TO_UNIXTIME TRANSLATE TRUNC UNICODE_PROFILE

functions: ranking see functions: analytic functions: ranking functions functions: scalar & operator ^ operator | operator ABS ACOS arithmetic operators ASCII ASIN ATAN CASE CAST CEILING CHAR_LENGTH CHARACTER_LENGTH CHR COALESCE concatentation COS COSH CURRENT_DATE CURRENT_SCHEMA CURRENT_SCHEMA_ID CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION_NUMBER CURRENT_USER_ID DATE DAYOFWEEK DECODE DEGREES ERRORCODE ERRORNUM EXP EXTRACT FACTORIAL FLOOR GAMMA GENERATE_KEY GREATEST HASH_CHAIN HASH_MPID HASH_VALUE IMAGE_ID INTTOSTR LEAST LEFT LENGTH LN LOG LOG10 LOWER LPAD MAXLIST MOD MOD operator NULLIF NVL OCTET_LENGTH OVERLAY PI POSITION POSN_IN_LIST POWER RADIANS RIGHT RPAD SCHEMA_ID, [1] SIGN SIN SINH SOUNDEX SQRT STRCHOP STRCOUNT STRPACKINTS STRPOS STRTOINT STRUNPACKINTS SUBSTR SUBSTRING SYSDATE TABLE_ID TAN TANH TIME TIMESTAMP TO_CHAR TO_DATE TO_TIME TO_TIMESTAMP TRIM UCHR UNICODE UPPER USER USER_ID VAL_AT_POSN WIDTH_BUCKET WX_CREATE_TNO WX_UPDATE_TNO functions: set EXCEPT INTERSECT MINUS UNION functions: string LISTAGG functions: window functions functions: windowing see functions: analytic

G

GAMMA GENERATE_KEY GENERATE_SERIES GETBITS Getting Started Kognitio on AWS; Getting started with Kognitio memory images, [1] Qlik Sense running queries, [1], [2], [3] Tableau using memory, [1] using Zeppelin, [1] Using Zeppelin Zeppelin

Getting started with Kognitio on AWS, [1] Getting started with Kognitio on Hadoop, [1], [2], [3], [4] Getting started with Kognitio on MapR, [1] Getting started with Kognitio Standalone Getting started with Kognitio standalone, [1] accessing data creating tables GREATEST GROUPING (OLAP function) Groups administration groups altering groups creating groups dropping groups

H

Hardware and fault tolerance (standalone) Hardware Failure Kognitio standalone HASH_CHAIN

HASH_MPID HASH_VALUE How Kognitio Works asymmetric processing location hash values

I

ILIKE IMAGE_ID Images images dropping Imaging Queue; IMATCHING IN (comparison function) INITCAP INPUT external scripts INSERT; Inserting data Inserting VALUES INSIDE_POLYGON Installation Kognitio standalone

installation Kognitio Console Kognitio on Hadoop, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11] Installation: by deployment option; INSTR internal tables, [1] INTERSECT Intervals intervals INTTOSTR INVALIDATED VIEW IS NULL IS_DATE IS_NUMBER IS_TIMESTAMP

J

JOINS Syntax

JSON Loading Data

K

Kerberos Authentication kodoop cluster commands Kognitio on Hadoop kodoop commandline reference kodoop commands Kognitio on Hadoop kodoop gateway commands Kognitio on Hadoop kodoop mgr commands Kognitio on Hadoop kodoop server commands Kognitio on Hadoop Kognitio, [1] getting started Kognitio command line tool reference Kognitio Console: installation Kognitio for SQL experts Kognitio Image Distribution Kognitio internal tables, [1] Kognitio JDBC Kognitio JDBC SSL Setup Kognitio Launcher, [1], [2], [3], [4], [5], [6] set-up in AWS set-up using a Cloud Formation template Kognitio Launcher Networking for AWS Kognitio ODBC Kognitio on AWS getting started, [1] Getting Started; launching, [1], [2], [3], [4] launching on launcher using memory Kognitio on Hadoop commands Configuration Configuration file Create Users deployment getting started, [1], [2], [3] Getting started memory images, [1] running queries, [1], [2], [3] Starting Stopping upgrade using memory, [1] using Zeppelin, [1], [2] Using Zeppelin

Kognitio on Hadoop: environment variables Kognitio on Hadoop: installation, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11] Kognitio on Hadoop: kodoop cluster command line Kognitio on Hadoop: kodoop command line Kognitio on Hadoop: kodoop gateway command line Kognitio on Hadoop: kodoop mgr command line Kognitio on Hadoop: kodoop server command line Kognitio on Hadoop: prerequisites, [1] Kognitio on MapR getting started, [1] Kognitio PDF Documentation Kognitio REST API Kognitio Standalone getting started Kognitio standalone Add disks Add Nodes Administration, [1], [2], [3], [4], [5], [6], [7] Configuration Configuration file Crash Recovery Create Users deployment getting started Getting started getting started -accessing data getting started -creating tables Hardware Failure installation memory images, [1] Reintegrate Nodes Remove disks Remove Nodes running queries, [1], [2], [3] Software RAID Standby disks Starting Stopping upgrade using memory, [1] Virtual diskstores Kognitio: accessing

L

LAG LAST LAST_DAY LEAD LEAST LEFT LENGTH LIKE LIMIT THREADS, [1], [2], [3] LISTAGG LN Loading Data JSON

Location Hash Values; Locking administration LOG LOG10 Logging administration Looker Connecting to Kognitio LOWER LPAD LTRIM

M

manpage for wxbackup manpage for wxbashtools manpage for wxcsvprofile manpage for wxjson2csv manpage for wxjsonprofile manpage for wxloader manpage for wxloader format manpage for wxrestore manpage for wxsession manpage for wxsessionagent manpage for wxsubmit manpage for wxtabinfo manpage for wxunloader manpage for wxunloader format manpage for wxwcb2csv MAP_DAY MAPMONTH MATCHING Maths functions MAX MAXLIST memory images, [1] MERGE INTO; Merging data MIN MINUS miscellaneous functions MOD MOD operator module: compatiability ADD_MONTHS module: compatibility CONCAT EDIT_DISTANCE FIRST_DAY INITCAP INSTR IS_DATE IS_NUMBER IS_TIMESTAMP LAST_DAY LTRIM MONTHS_BETWEEN NEXTDAY REPLACE ROUND RTRIM TO_CHAR TO_DATE TO_NUMBER TO_TIME TO_TIMESTAMP TRANSLATE TRUNC

module: datetime AGE DT_INFO FROM_UNIXTIME MAPDAY MAPMONTH TO_UNIXTIME module: formatstr FORMATSTR module: geometry INSIDE_POLYGON POINT POLYGON module: miscfuncs EARTH_DISTANCE module: misfuncs BITCOUNT module: strings ANALYSE_STRING GETBITS PROFILE REVERSE SINKCHARS SNIPCHARS SUCKCHARS SWAPCHARS UNICODE_PROFILE Monitoring Disk Slabs Disk Usage Locking Logging Query sessions RAM Usage MONTHS_BETWEEN

N

New Features in Version 8.2.0 and 8.2.1 in Version 8.2.3 in Version 8.2.4 NEXTDAY

NTILE Null data NULL; NULLIF Numerical data types NVL

O

Object Commands Object Metadata DESCRIBE OCTET_LENGTH ODBC Attributes OLAP data set OLAP functions OLAP grouping sets

ONE_VALUE ORDER BY external scripts, [1], [2] ORDER BY (analytic functions) OUTPUT extenal scripts, [1] OVER (analytic functions) OVERLAPS OVERLAY overview

P

PACKDATE PARTITION BY (analytic functions) pdf-documentation PI PICTURE POINT POLYGON

POSITION POSN_IN_LIST POWER PRECEDING (analytic functions) prerequisites Kognitio on Hadoop, [1] PROFILE

Q

Qlik Sense Getting Started Using Kognitio to empower ODAG, [1] Query Alias Joins subselect Query Planning DIAGNOSE EXPLAIN PICTURE

Query Sessions administration Queues administration Quick Reference Sheets

R

RADIANS RAM Usage administration RANGE (analytic functions) RANGE window (analytic functions) RANK RATIO_TO_REPORT RECEIVES Recover disk space REcover space in system tables Reintegrate Nodes Kognitio standalone Remove disks Kognitio standalone Remove Nodes Kognitio standalone RENAME TABLE

REPLACE REQUIRES RAM Restarting Kognitio Imaging Queue; Retail Demo, [1], [2], [3] REVERSE RIGHT ROLLUP ROUND Row Value Constructors (RVC) ROW window (analytic functions) ROW_NUMBER ROWS (analytic functions) RPAD RTRIM RUN ON NODES, [1] running queries, [1], [2], [3] Runtime parameters

S

SAME_VALUE SCHEMA_ID Schemas schemas altering creating dropping setting SCRIPT ENVIRONMENT ALTER CREATE DROP SCRIPT ENVIRONMENT; Script environments altering creating, [1] dropping SDEV security class altering creating Securtiy classes administration SELECT basic syntax executing commands Full syntax simple form SELECT statement SELECT; Selecting data SET CURRENT_SESSION PARAMETER SET SECHEMA SET USER PARAMETER SIGN SIMILAR TO SIN single CREATE OR REPLACE; VIEW IMAGE Training Demo Tutorials; Kognitio and Zeppelin Tutorials; Zeppelin Zeppelin; dynamic forms Single: External Scripts SINH SINKCHARS SNIPCHARS Software RAID Kognitio standalone SOME (comparison function) SOUNDEX

SQL functions SQL reference access commands admin commands functions object commands SQL syntax Quick Reference SQRT standalone Add disks Add Nodes Administration, [1], [2], [3], [4], [5], [6], [7] Crash Recovery deployment Hardware Failure installation Reintegrate Nodes Remove disks Remove Nodes Software RAID Standby disks Starting Stopping upgrade Virtual diskstores Standby disks Kognitio standalone STDDEV STDEV STRCHOP STRCOUNT String functions Strings STRPACKINTS STRPOS STRTOINT STRUNPACKINTS Subselect queries in Kognitio SUBSTR SUBSTRING SUCKCHARS SUM sungle: functions: time SWAPCHARS SYSDATE System Ramstores System Tables administration Recover Space systme altering

T

Table External, [1] TABLE_ID Tableau Connecting to Kognitio Getting Started Tables tables altering creating external tables creating images creating tables creating temporary tables defragmenting images dropping renaming tables, connectors, [1] tables, external tables, internal, [1] tables: anonymous external TAN TANH

TIME, [1] TIMESTAMP, [1] TO_CHAR (compatibility plugin version) TO_DATE (compatibility plugin version) TO_NUMBER (compatibility plugin version) TO_TIME (compatibility plugin version) TO_TIMESTAMP (compatibility plugin version) TO_UNIXTIME Tolerance Fault Hardware Transactions AT Modes TRANSLATE TRIM TRUNC Tutorials Zeppelin, [1]

U

UCHR UNICODE Unicode; UNICODE_PROFILE UNION UPDATE MERGE UPDATE; Updating data upgrade: Kognitio on Hadoop; Upgrade: standalone; UPPER USER USER_ID Users administration Getting started with Kognitio on Hadoop Getting started with Kognitio standalone

users altering users creating users dropping users Using bash scripts with Kognitio Using bash scripts with Kognitio;, [1] using memory, [1] Using perl with Kognitio;, [1] Using Python with Kognitio, [1], [2] Using Python with Kognitio;, [1], [2] Using R scripts with Kognitio; USing R with Kognitio Using R with Kognitio;, [1]

V

VAL_AT_POSN VALUES inserting VALUES BETWEEN VAR VARCHAR Version 8.2.0 New Features Version 8.2.1 New Features Version 8.2.3 New Features

Version 8.2.4 New Features Versions; Views views creating creating images dropping invalidating replacing Virtual diskstores Kognitio standalone

W

What's New in Kognitio 8.2.0 and 8.2.1 in Kognitio 8.2.3 in Kognitio 8.2.4

WIDTH_BUCKET Writable CSV connector WX_CREATE_TNO WX_UPDATE_TNO wxloader

Z

Zeppelin date selector dynamic forms, [1], [2] tutorials, [1], [2], [3]