Index

Symbols

& operator ^ operator

| operator || function

A

ABS Access Creating a DSN from Tableau access 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 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

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 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 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 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 Floating Point Numbers Images Inserting Merging Nulls Numerics Reals Schemas Selecting Strings Tables Types Unicode Updating VARCHAR Views encoding loading using Console loading using wxloader types 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 MapR tables create images 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 on MapR Kognitio standalone DIAGNOSE Disk Slabs administration Disk usage administration DISTINCT FROM DROP GROUP IMAGE SCHEMA TABLE USER VIEW DSN Create 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 Configuration, [1], [2] External Scripts Configuration, [1], [2], [3], [4], [5], [6], [7], [8] Environment Variables Environments Python, [1], [2], [3], [4], [5] R, [1], [2] RAM requirements anonymous bash, [1], [2], [3] configuration, [1], [2] creating environment variables 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]

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 Kognitio on AWS; Getting started with Kognitio Qlik Sense Tableau Using Zeppelin Zeppelin memory images, [1] running queries, [1], [2], [3] 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], [3] 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 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] Kognitio on MapR, [1]

Installation: by deployment option; installation: Kognitio on MapR; INSTR internal tables, [1] INTERSECT Intervals 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; getting started, [1] launching, [1], [2], [3], [4] launching on launcher using memory Kognitio on Hadoop Configuration Configuration file Create Users Getting started Starting Stopping Using Zeppelin commands deployment getting started, [1], [2], [3] memory images, [1] running queries, [1], [2], [3] 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 Create Users Getting started deployment getting started, [1], [2] restarting reversving MapR memory Kognitio on MapR: installation, [1] Kognitio on MapR: prerequisites, [1] Kognitio PDF Documentation Kognitio Standalone getting started 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 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 LIMIT THREADS, [1], [2], [3] LN Loading Data JSON

Location Hash Values; Locking administration LOG LOG10 Logging administration 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 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 NEXTDAY NTILE

Null data NULL; NULLIF Numerical data types NVL

O

Object Commands 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

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 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 Retail Demo, [1], [2], [3] REVERSE RIGHT ROLLUP ROUND 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 Full syntax basic syntax executing commands 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 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 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 deployment installation upgrade 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 Recover Space administration 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 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 tools Additional Transactions AT Modes TRANSLATE TRIM TRUNC Tutorials Zeppelin, [1]

U

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

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], [3] Using R scripts 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

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 WIDTH_BUCKET

Writable CSV connector WX_CREATE_TNO WX_UPDATE_TNO wxloader

Z

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