Skip to main content
Skip table of contents

Start Indexima and make your first query

We will now start the Indexima engine, and make our first Hive queries on it with Beeline to test that everything runs properly.

Start Indexima

Execute queries

You can use any SQL tool to connect to the cluster and make Hive queries. In our example, we will use beeline.

Indexima has a special query SHOW MEMORY ALL that returns data about every nodes on the cluster. Execute it in beeline.

Show memory

SQL
SHOW MEMORY ALL;

You can then execute this short SQL script to create a simple table and insert a few lines.

Validation

SQL
DROP TABLE IF EXISTS diag;
CREATE TABLE diag ( col1 INT, col2 STRING, INDEX (Col1));
INSERT INTO TABLE diag VALUES (1,"row1"),(2,"row2"),(3,"row3"),(4,"row4"),(5,"row5");
INSERT INTO TABLE diag VALUES (6,"row6"),(7,"row7"),(8,"row8"),(9,"row9"),(10,"row10");
INSERT INTO TABLE diag VALUES (11,"row11"),(12,"row12"),(13,"row13"),(14,"row14"),(15,"row15");
INSERT INTO TABLE diag VALUES (16,"row16"),(17,"row17"),(18,"row18"),(19,"row19"),(20,"row20");

If you have an Indexima license, you can then make SELECT queries on this table.

Select

SQL
SELECT COUNT(*) FROM diag;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.