Index

Symbols

& operator :single: Access control administration, [1] :single: Add disks Kognitio standalone :single: Add Nodes Kognitio standalone :single: 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 on MapR 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 Space Recover disk space Security classes Starting Kognitio on Hadoop Starting Kognitio standalone Stopping Kognitio on Hadoop Stopping Kognitio standalone Users :single: Adminstration Configuration :single: Authentication administration :single: BI tools Kognitio and Qlik Sense :single: CHAR :single: Client tools Quick Reference :single: Configuration External Scripts runtime parameter :single: Configuration file standalone :single: Connectors Quick Reference :single: Crash Recovery Kognitio standalone :single: Data CHAR Decimals Deleting Floating Point Numbers Images Inserting Merging Nulls Numerics Reals Schemas Selecting Strings Tables Types Unicode Updating VARCHAR Views encoding types :single: Data types Dates Decimals Floating Point Numbers Intervals Numerics Reals Time Timestamps :single: Data types; :single: datasets retail, [1], [2], [3], [4], [5] :single: datasets: retail create (internal) tables create MapR tables create external tables create images create views queries :single: Datatype Nulls :single: Datatypes CHAR Strings VARCHAR :single: DATE :single: DELETE; :single: Deleting data :single: Disk Slabs administration :single: Disk usage administration :single: Encryption administration :single: EXEC; :single: Executing commands from SELECT :single: EXTERNAL SCRIPT CREATE DEFAULT PARTITIONS INPUT/OUPUT INPUT/OUTPUT LIMIT THREADS, [1], [2], [3] ORDER BY, [1], [2] RECEIVES RUN ON NODES, [1] :single: External SCripts Configuration, [1], [2], [3], [4], [5], [6], [7], [8] :single: External Scripts Configuration Environment Variables Environments Python, [1], [2], [3], [4], [5] R, [1] RAM requirements anonymous bash, [1], [2] configuration, [1], [2] creating environment variables formatting input/output, [1] inline input data invocation invoking, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12] ordering data partitioning perl python, [1], [2] :single: functions: miscellaneous :single: Getting Started Kognitio on AWS;, [1] :single: Getting started with Kognitio Qlik Sense :single: Getting started with Kognitio on Hadoop :single: Getting started with Kognitio on MapR :single: Getting started with Kognitio standalone :single: Groups administration

:single: Hardware Failure Kognitio standalone :single: Images :single: INPUT external scripts :single: INSERT; :single: Inserting data :Single: Inserting VALUES :single: Intervals :single: Kognitio on AWS Getting Started;, [1] :single: Kognitio on Hadoop Configuration Configuration file Create Users Getting started Starting Stopping :single: Kognitio on MapR Create Users Getting started restarting :single: Kognitio standalone Add Nodes Add disks Administration, [1], [2], [3], [4], [5], [6], [7] Configuration Configuration file Crash Recovery Create Users Getting started Hardware Failure Reintegrate Nodes Remove Nodes Remove disks Software RAID Standby disks Starting Stopping Virtual diskstores :single: LIMIT THREADS, [1], [2] :single: Locking administration :single: Logging administration :single: MERGE INTO; :single: Merging data :single: mmiscellaneous functions :single: Monitoring Disk Slabs Disk Usage Locking Logging Query sessions RAM Usage :single: Null data :single: NULL; :single: Numerical data types :single: ORDER BY external scripts, [1], [2] :single: OUTPUT extenal scripts :single: Qlik Sense Getting Started :single: Query Sessions administration :single: Queues administration :single: Quick Reference Sheets :single: RAM Usage administration :single: RECEIVES :single: Recover disk space :single: REcover space in system tables :single: Reintegrate Nodes Kognitio standalone :single: Remove disks Kognitio standalone :single: Remove Nodes Kognitio standalone :single: REQUIRES RAM :single: RUN ON NODES, [1] :single: Runtime parameters :single: Schemas :single: SCRIPT ENVIRONMENT; :single: Script environments creating :single: Securtiy classes administration :single: SELECT basic syntax executing commands simple form :single: SELECT; :single: Selecting data :single: SET CURRENT_SESSION PARAMETER :single: SET USER PARAMETER :single: Software RAID Kognitio standalone :single: SQL reference :single: SQL syntax Quick Reference :single: standalone Add Nodes Add disks Administration, [1], [2], [3], [4], [5], [6], [7] Crash Recovery Hardware Failure Reintegrate Nodes Remove Nodes Remove disks Software RAID Standby disks Starting Stopping Virtual diskstores :single: Standby disks Kognitio standalone :single: Strings :single: System Tables Recover Space administration :single: Tables :single: TIME :Single: TIMESTAMP :single: Unicode; :single: UPDATE MERGE :single: UPDATE; :single: Updating data :single: Users Getting started with Kognitio on Hadoop Getting started with Kognitio on MapR Getting started with Kognitio standalone administration :single: Using bash scripts with Kognitio :single: Using bash scripts with Kognitio; :single: Using perl with Kognitio;, [1] :single: Using Python with Kognitio, [1], [2] :single: Using Python with Kognitio;, [1], [2], [3] :single: Using R with Kognitio;, [1] :Single: VALUES inserting :single: VARCHAR :single: Views :single: Virtual diskstores Kognitio standalone ^ operator | operator || function

A

ABS Access Creating a DSN from Tableau access from Apache Zeppelin Access Commands accessing Kognitio on Hadoop ACOS ADD_MONTHS Admin SQL Commands Adminstration 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 Zeppelin Connecting to Kognitio arithmetic operators ASCII ASIN Asymmetric Processing; AT Modes ATAN Authentication using kerberos AVG

B

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

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

C

CASE CAST CEILING CHAR_LENGTH CHARACTER_LENGTH CHR 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 Connector Avro DDL Syntax, [1] Glue Glue Example Data HDFS Hadoop Filesystem URIs 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 COS COSH COUNT 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 loading using Console loading using wxloader Data in Kognitio Manipulating data types using date-times and intervals DATE function date-time data types DAYOFWEEK DECODE DEFRAG TABLE IMAGE DEGREES Demos retail, [1], [2], [3] training

DENSE_RANK Deployment Kognitio on Hadoop Kognitio on MapR Kognitio standalone DIAGNOSE DISTINCT FROM DROP GROUP IMAGE SCHEMA TABLE USER VIEW DSN Create DT_INFO

E

EARTH_DISTANCE EDIT_DISTANCE Environment variables Kognitio on Hadoop ERRORCODE ERRORNUM EXCEPT EXISTS EXP EXPLAIN EXTERNAL SCRIPT ALTER CREATE DROP

External scripts Invoking altering creating dropping 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 DIAGNOSE EXPLAIN PICTURE functions: aggregate AVG BITWISE_AND BITWISE_OR COUNT 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 RANGE RANGE window RANK RATIO_TO_REPORT ROW window ROWS ROW_NUMBER query order by clause query partition clause 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

functions: ranking see functions: analytic functions: ranking functions functions: scalar & operator ABS ACOS ASCII ASIN ATAN CASE CAST CEILING CHARACTER_LENGTH CHAR_LENGTH CHR COALESCE 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 ^ operator arithmetic operators concatentation | operator functions: set EXCEPT INTERSECT MINUS UNION functions: window functions functions: windowing see functions: analytic

G

GAMMA GENERATE_KEY GENERATE_SERIES GETBITS Getting started with Kognitio Using Zeppelin Zeppelin memory images, [1] running queries, [1], [2], [3], [4] using Zeppelin, [1] using memory, [1]

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

H

Hardware and fault tolerance (standalone) HASH_CHAIN HASH_MPID

HASH_VALUE How Kognitio Works asymmetric processing location hash values

I

ILIKE IMAGE_ID images dropping IMATCHING IN (comparison function) INITCAP INSIDE_POLYGON Installation Kognitio standalone installation Kognitio Console Kognitio on Hadoop, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11] Kognitio on MapR, [1]

Installation: by deployment option; installation: Kognitio on MapR; INSTR internal tables, [1] INTERSECT intervals INTTOSTR INVALIDATED VIEW IS NULL IS_DATE IS_NUMBER IS_TIMESTAMP

J

jet-util 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 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] launching, [1], [2], [3], [4] launching on launcher using memory Kognitio on Hadoop Using Zeppelin commands deployment getting started, [1], [2], [3], [4] memory images, [1] running queries, [1], [2], [3], [4] upgrade using Zeppelin, [1], [2] using memory, [1]

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 deployment getting started, [1], [2] reversving MapR memory Kognitio on MapR: installation, [1] Kognitio on MapR: prerequisites, [1] Kognitio PDF Documentation Kognitio standalone deployment getting started getting started -accessing data getting started -creating tables installation memory images, [1] running queries, [1], [2], [3] upgrade using memory, [1] Kognitio: accessing

L

LAG LAST LAST_DAY LEAD LEAST LEFT LENGTH LIKE

LN Loading Data JSON Location Hash Values; LOG LOG10 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] MIN MINUS 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 MONTHS_BETWEEN

N

New Features in Version 8.2.0 and 8.2.1 in Version 8.2.3

NEXTDAY NTILE NULLIF NVL

O

Object Commands OCTET_LENGTH ODBC Attributes OLAP data set OLAP functions

OLAP grouping sets ONE_VALUE ORDER BY (analytic functions) OVER (analytic functions) OVERLAPS OVERLAY

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] Kognitio on MapR, [1] PROFILE

Q

Qlik Sense Using Kognitio to empower ODAG, [1] Query Alias Joins subselect

Query Planning DIAGNOSE EXPLAIN PICTURE

R

RADIANS RANGE (analytic functions) RANGE window (analytic functions) RANK RATIO_TO_REPORT RENAME TABLE REPLACE Retail Demo, [1], [2], [3] REVERSE

RIGHT ROLLUP ROUND ROW window (analytic functions) ROW_NUMBER ROWS (analytic functions) RPAD RTRIM running queries, [1], [2], [3], [4]

S

SAME_VALUE SCHEMA_ID schemas altering creating dropping setting SCRIPT ENVIRONMENT ALTER CREATE DROP Script environments altering creating dropping SDEV security class altering creating SELECT Full syntax SELECT statement SET SECHEMA SIGN SIMILAR TO SIN single CREATE OR REPLACE; VIEW IMAGE Training Demo Tutorials; Kognitio and Zeppelin Tutorials; Zeppelin Zeppelin; dynamic forms SINH SINKCHARS

SNIPCHARS SOME (comparison function) SOUNDEX SQL functions SQL reference access commands admin commands functions object commands SQRT standalone deployment installation upgrade STDDEV STDEV STRCHOP STRCOUNT String functions STRPACKINTS STRPOS STRTOINT STRUNPACKINTS Subselect queries in Kognitio SUBSTR SUBSTRING SUCKCHARS SUM sungle: functions: time SWAPCHARS SYSDATE System Ramstores systme altering

T

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

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 tools Additional Transactions AT Modes TRANSLATE TRIM TRUNC Tutorials Zeppelin, [1]

U

UCHR UNICODE UNION upgrade: Kognitio on Hadoop; Upgrade: standalone; UPPER

USER USER_ID users altering users creating users dropping users using memory, [1]

V

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

Versions; views creating creating images dropping invalidating replacing

W

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

Writable CSV connector WX_CREATE_TNO WX_UPDATE_TNO wxloader

Z

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