Beeline

Indexima being a Hive based engine, you can use Beeline to connect to it.

Example

BASH

beeline -u jdbc:hive2://localhost:10000

You can add credentials directly with the options -n and -p

BASH

beeline -u jdbc:hive2://localhost:10000 -n admin -p admin

The syntax and options are exactly the same as when trying to connect to a Hive server. You can learn more about all the Beeline commands with the -h option, or by consulting the official Beeline documentation

Adapt SQL sent to indexima through beeline

After connecting to Indexima, when using a URL in the SQL Statement mainly for table creation, note that semicolon (;) needs to be replaced by "%3b".

SQL

0: jdbc:hive2://localhost:8443/> CREATE TABLE XXXXX from simple IN 'jdbc:hive2://localhost:10000/default%3bprincipal=hive/ns369699.ip-94-23-47.eu@INDEXIMA.COM' (Index(id1));