Skip to content
Main NavigationIndexima for SnowflakeIndexima WebsiteContact Support
Sidebar Navigation

Quick Start

Install Indexima Core Engine

Install Indexima Console

Run Indexima bench

AWS Deployment Guide

Introduction

Deployment on marketplace

Step by step deployment

Architecture Diagram

AWS Security

AWS Costs

Backup and Recovery

Support

Tech Guides

General requirements

Authentication & Authorization

Install & Upgrade

Downloading Indexima

Install, configure, and run Indexima on a cluster

Setup shared storage

Start Indexima

Azure Marketplace Prerequisites

Install Indexima Engine

Installing Developer Console

Upgrading Indexima

Upgrading Galactica

Upgrading Developer Console

Post Installation & Upgrade Checks

SQL Engine Administration & Monitoring

SQL Engine Authentication

Engine LDAP Authentication

Engine KERBEROS Authentication

Engine Custom authentication

SQL Engine Authorization

Manual implementation of rights

Rights matrix

Row-level security (RLS) within Indexima

Row-level security (RLS) within Indexima & PowerBI Gateway

Use Ranger to implement rights

Configuration to plug Indexima with Ranger

Add an Indexima Policy in Ranger

Audit

SQL Engine Monitoring

(Live) Monitoring via API

Get Queries History

Smart Tables Monitoring

Enterprise SaaS Security

SQL Engine Configuration

Smart Tables Activation & configuration

Configuration Changes

Securing your dataflow

Knox

Knox Prerequisites

Indexima with Knox

Analyzer Module

Indexima Console

Clusters Hub

Console Authentication

Indexima Web Interface (Monitor)

Configure Notifications

Console rights

Console Cluster View

Cluster/Node Status

License

Logs

High-Availability

Dynamic Mode

Load balancing

Zookeeper

Advanced usage & configuration

Backup / Recovery

Big requests

Big indexes

Handle Topology Change

Handling Disaster Recovery Plan (DRP)

Spill to Disk

Data Catalog Integration

Indexima as Windows Service

Indexima as Windows Scheduled task

Connect a standalone Indexima cluster to a kerberized instance

Run 2 clusters on the same nodes

Load / syncronize encrypted files

Compatibility matrix

Storage Compatibility Matrix

Data Source Compatibility matrix

BI Tools Compatibility matrix

Cloudera Compatibility matrix

User Guides

Create Indexima Tables

Physical Tables (Manual Creation)

External Tables (Manual Creation)

Views

Indexima Calculated Fields

Table Creation Wizard

Load or Synchronize data

Files Load (CSV, parquet...)

Load files using the "Load from File" Assistant

Files Load (CSV, parquet...) via command

Data Load via Querying a database

Querying a database for Data load via Assistant

Querying a database for Data load via SQL Command

Synchronize data from ...

Synchronize data from Hive datasource

Synchronize data from external sources

Consume Data from Indexima

BI Tools

Microstrategy

MicroStrategy Developer - Create JDBC Database Connection

MicroStrategy Dossier

Microstrategy- Enhance compatibility with Indexima

ODBC/JDBC Drivers

ODBC-Create a DSN linked to Indexima Engine

Power BI

PowerBI & Indexima connector

Power BI Desktop

Power BI Gateway

Power BI - DAX

Qlik

QlikView_

QlikSense

SAP Business Objects

Spotfire

Tableau

Tableau - Connection & Setup

Tableau - Additional Steps since Tableau 2019.4

Tableau - Connect to a Zookeeper Quorum

Command line Tools

Beeline

Roquettor

SQL Line

Direct DataViz Connection

Tableau Data Source

Optimizing Dataspaces

Indexima Advanced Analyzer

Optimize Table from Table overview

Checking effectiveness of current Hyper-indexes

Smart Tables

Advanced users

Compact Tables

Indexes standard usage & Free up Indexes space

Table aliasing

Use a specified index

Indexima Interface

Dashboard

Data Catalog

Notifications_

Query History

SQL Console

Cluster Hub

References

Configuration files

galactica.conf

galactica_ext.conf

galactica-env.sh

hive-site.xml

log4j2.xml

notifications.json

optimize_index.json

supported_dbs.json

atlas-application.properties

Visualdoop/ldap.properties

Visualdoop/config.sh

API References

Authentication

Cluster status

Queries History

Events History

Indexes & Dictionaries

Diagnosis export

Cluster connections

Execute SQL statements

SQL References

Backup functions

EXPORT

IMPORT

SQL References Rights

CREATE USER

DROP USER

GRANT

REVOKE

SHOW PRINCIPALS

SHOW ROLE GRANT

SHOW ROLES

Cluster Functions

SHOW TABLECOUNT

SHOW CONFIG

SHOW MEMORY

SET_

CHECK TABLES

DESCRIBE

SQL in general

Built-in SQL Functions

Other functions

Pushdown functions

SQL Aggregate Functions

Supported Data Types

SQL for Schemas

CREATE DATABASE/SCHEMA

DROP DATABASE/SCHEMA

SQL for Tables

ALTER TABLE
ALIAS

DROP ALIAS

SET ALIAS

SHOW ALIAS

ANALYTICS

OPTIMIZER (Analyzer mode)

COLUMN

ADD COLUMNS

DROP COLUMN

COMPACT

FILTER

ADD FILTER

DROP FILTER

SHOW FILTERS

INDEX

ADD INDEX

DROP INDEX

SET SYNCHRONIZE

APPLY Topology

COMMIT

CREATE TABLE

DROP TABLE

Insert/Load/Synchronize Data

INSERT INTO

LOAD DATA (Files Load)

LOAD DATA (using a Select statement)

SYNCHRONIZE

UNLOAD SCHEMA

UNLOAD TABLE

SQL for Views

CREATE VIEW

Troubleshooting

Indexima Diagnosis

Tips

Core Engine (Galactica) threads monitoring

Garbage collector

Increase Open file limit

Linux scripts

Automating the start of INDEXIMA Cluster

Best practices when using Kerberos

Collecting a Kerberos ticket

isrunning.sh

Out of Memory Killer

Errors

TSaslTransportException: No data or no sasl data in the stream found in galactica logs

When the Index is too big

Expired License

Query too long

Unable to create new native thread

SYNCHRONIZE Operation not working

Releases

2026.2 (Released on September 30th, 2026)

2026.2 - Parameter Changes

2026.2 - Services Packs

2025.1 (Released on June 6th, 2025)

2025.1 - Parameter Changes

2025.1 - Services Packs

2024.1 (Released on September 30, 2024)

2024.1 - Parameter Changes

2024.1 - Services Packs

2023.2 (Released on July 31, 2023)

2023.2 - Parameter Changes

2023.2 - Services Packs

2022.3 (Released on November 9, 2022)

2022.3 - Parameter Changes

2022.3 - Services Packs

2022.2 (Released on May 25, 2022)

2022.2 - Parameter Changes

2022.2 - Services Packs

2022.1 (Released on January 26, 2022)

2022.1 - Parameter Changes

2022.1 - Services Packs

2021.5 (Released on October 20th, 2021)

2021.5 - Parameter Changes

2021.5 - Services Packs

2021.4 (Released on August 25th, 2021)

2021.4 - Parameter Changes

2021.4 - Services Packs

2021.3 (Released on June 30th, 2021)

2021.3 - Parameter Changes

2021.3 - Services Packs

2021.2 (Released on May 3rd, 2021)

2021.2 - Parameter Changes

2021.2 - Services Packs

2021.1 (released on March 12th, 2021)

2021.1 - Parameter Changes

2021.1 - Services Packs

End of life support policy

Deprecated Versions

1.7.12 (Released on January 25th , 2021)

1.7.12 Parameter Changes

1.7.12 - Services Packs

1.7.11 (Released on November 10th, 2020)

1.7.11 Parameters Changes

1.7.11 - Services Packs

1.7.10 (Released on Sept 21th, 2020)

1.7.10 Parameters Changes

1.7.10 Services Packs

1.7.9 (Released on August 12th, 2020)

1.7.9. Parameters Changes

1.7.9 Services Packs

1.7.8 (Released on July 6th, 2020)

1.7.8 Parameters Changes

1.7.8 Services Packs

1.7.7 (Released on May 20th, 2020)

1.7.7 Parameters Changes

1.7.6 (Released on March 26th, 2020)

1.7.5

1.7.4

1.7.3

1.7.2

1.7.1

Vulnerabilities

CVE-2021-44228 - log4j2

CVE-2021-45105 & CVE-2021-45046 Log4j Vulnerabilities

CVE-2021-44832 (Vulnerability to RCE via JDBC Appender)

Trial Platform

Best Practices

Best Practices with Indexima

Full load every day (no incremental load)

Monitor an Indexima Cluster

Rolling Data / Reload Data

Best Practices with PowerBI

PBI Best Practices - General Guidances

PBI Best Practices - Highlights from the Indexima team

PBI Best Practices - Date Dimension Table

PBI Best Practices - Preferred DAX Formulas

Left.Anti

How to switch Environnement ?

Best Practices with QlikView and QilkSense

Best Practices with SAP Business Objects

Best Practices with Tableau

Median with Tableau

Tips.

Analyze usage by Report/Dashboard

Ticketing

On this page
Table of Contents for current page
Documentation / References / SQL References

SQL for Schemas ​

  • CREATE DATABASE/SCHEMA
  • DROP DATABASE/SCHEMA
Previous pageSupported Data Types
Next pageCREATE DATABASE/SCHEMA