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


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

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

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".

0: jdbc:hive2://localhost:8443/> CREATE TABLE XXXXX from simple IN 'jdbc:hive2://localhost:10000/default%3bprincipal=hive/' (Index(id1));