Index

Symbols

& operator ^ 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) 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; 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 CONCAT (plugin function) concatentation CONNECTOR_ID connectors: ORC ORC connectors: Parquet; 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 DIAGNOSE DISTINCT FROM DROP GROUP IMAGE SCHEMA TABLE USER DSN Create DT_INFO

E

EARTH_DISTANCE EDIT_DISTANCE Environment variables Kognitio on Hadoop ERRORCODE

ERRORNUM EXCEPT EXISTS EXP EXPLAIN EXTRACT

F

FACTORIAL FIRST FIRST_DAY FLOOR FOLLOWING (analytic functions) FORMATSTR FROM_UNIXTIME functions functions: admin DIAGNOSE EXPLAIN PICTURE functions: aggregate AVG BITWISE_AND BITWISE_OR COUNT MAX MIN 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: 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 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 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

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 on Hadoop, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12] Kognitio on MapR, [1]

INSTR INTERSECT intervals INTTOSTR IS NULL IS_DATE IS_NUMBER IS_TIMESTAMP

J

jet-util

K

Kerberos Authentication kodoop cluster commands Kognitio on Hadoop kodoop commands Kognitio on Hadoop kodoop gateway commands Kognitio on Hadoop kodoop mgr commands Kognitio on Hadoop kodoop server commands Kognitio on Hadoop Kognitio getting started Kognitio command line tool reference Kognitio Launcher, [1], [2] Kognitio on AWS getting started launching, [1], [2] Kognitio on Hadoop Using Zeppelin getting started, [1], [2], [3], [4] memory images, [1] running queries, [1], [2], [3], [4] 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], [12] 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], [2] Kognitio on MapR: installation, [1] Kognitio on MapR: prerequisites, [1] Kognitio standalone getting started getting started -accessing data getting started -creating tables memory images, [1] running queries, [1], [2], [3] using memory, [1] Kognitio: accessing

L

LAG LAST LAST_DAY LEAD LEAST LEFT LENGTH

LIKE LN 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 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 NEXTDAY

NTILE NULLIF NVL

O

Object Commands OCTET_LENGTH OLAP data set OLAP functions OLAP grouping sets

ORC ORDER BY (analytic functions) OVER (analytic functions) OVERLAPS OVERLAY

P

PACKDATE Parquet 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 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

SCHEMA_ID schemas altering creating dropping setting SDEV security class altering creating SET SECHEMA SIGN SIMILAR TO SIN single CREATE OR REPLACE; VIEW IMAGE Training Demo Tutorials; Kognitio and Zeppelin Tutorials; Zeppelin Zeppelin; dynamic forms SINKCHARS SNIPCHARS SOME (comparison function)

SOUNDEX SQL reference access commands admin commands functions object commands SQRT STDDEV STDEV STRCHOP STRCOUNT STRPACKINTS STRPOS STRTOINT STRUNPACKINTS SUBSTR SUBSTRING SUCKCHARS SUM sungle: functions: time SWAPCHARS SYSDATE systme altering

T

TABLE_ID Tableau Connecting to Kognitio tables altering creating external tables creating images creating tables creating temporary tables defragmenting images dropping renaming 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 TRANSLATE TRIM TRUNC Tutorials Zeppelin, [1]

U

UCHR UNICODE UNION UPPER USER

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

V

VAL_AT_POSN VALUES BETWEEN VAR Version 8.2 New Features

views creating creating images replacing

W

What's New in Kognitio 8.2 WIDTH_BUCKET

WX_CREATE_TNO WX_UPDATE_TNO wxloader

Z

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