Bellow you can find overview internal commands of command line tool [1] that can send some sql queries to Apache Ignite grid via JDBC Thin client.
1 - GitHub link https://github.com/julianhyde/sqlline
| command | note | status | comment |
|---|---|---|---|
| !all | Execute the specified SQL against all the current connections. | OK | --- |
| !autocommit | Enable or disable automatic transaction commit mode | FAILED | Impossible to disable autocommit |
| !batch | Start or execute a batch of SQL statements | OK | --- |
| !brief | Enable terse output mode | OK | --- |
| !verbose | Enable verbose output mode | OK | --- |
| !call | Execute a callable statement | N/A | Doesn't support from our side. |
| !close | Close the active connection | FAILED | Error message: Ambiguous command: [close, closeall] |
| !closeall | Close all current open connections | OK | --- |
| !columns | Display columns of a table | OK | Display int instead of type of field e.g. -5 = java.lang.Long, 12 = java.lang.String |
| !commit | Commit the current transaction, if autocommit is off. | FAILED | autocommit always true so commit doesn't make sense |
| !connect | Connect to a database | OK | --- |
| !dbinfo | List metadata information about the current connection. | OK | --- |
| !describe | Synonym for columns (if an argument is specified) or tables (if no argument is specified). | FAILED | Doesn't work without parameter. so now !describe =!columns |
| !dropall | Drop all tables in the database | OK | --- |
| !exportedkeys | List exported foreign keys for a database | N/A | Doesn't support from our side. |
| !go | Change to a different active connection | OK | --- |
| !help | Display help information | OK | Help shows not all commands that there are in manual. |
| !history | Display the command history | OK | --- |
| !importedkeys | List imported foreign keys for a database | N/A | Doesn't support from our side. |
| !indexes | Display indexes for a table | OK | --- |
| !isolation | Set the transaction isolation mode for the active connection | FAILED | autocommit always equals true so I can't to test this parameter |
| !list | Display all active connections | OK | --- |
| !manual | Display sqlline manual | OK | --- |
| !metadata | Invoke arbitrary metadata commands | OK | --- |
| !nickname | Create a friendly name for the connection (updates command prompt) | OK | --- |
| !outputformat | Change the method for displaying SQL results | OK | --- |
| !primarykeys | Display the primary key columns for a table | OK | --- |
| !procedures | List stored procedures | N/A | Doesn't support from our side. |
| !properties | Connect to the database defined in the specified properties file. | OK | --- |
| !quit | Exit SQLLine | OK | --- |
| !reconnect | Reconnect to the current database | OK | --- |
| !record | Begin recording all output from SQL commands | OK | --- |
| !rehash | Get a list of all tables and columns from the database in order to include them in the list for tab-completion of SQL statements. This is done automatically on connect when the fastconnect option is enabled. | FAILED - with and without fastconnect
| NPE from sqlline side |
| !rollback | Roll back the current transaction (if autocommit is off) | FAILED | autocommit always true so rollback doesn't make sense |
| !run | Execute a command script | OK | --- |
| !save | Save the current preferences to some file | FAILED | Doesn't override current parameters in ~/.sqlline/sqlline.properties |
| !scan | Scan class path for JDBC drivers | FAILED | Output - Compliant Compliant Version Compliant Compliant Version Driver Class Compliant Compliant Version Compliant Compliant Version Driver Classno 1.0 org.apache.ignite.IgniteJdbcDriverCompliant Compliant Version Compliant Compliant Version Driver Classno |
| !script | Save executed commands to a file | OK | --- |
| !set | Set a sqlline variable | FAILED | Values of parameters wasn't changed |
| !sql | Execute a SQL against a database | OK | --- |
| !tables | List all the tables in the database | OK | --- |
Overview
Content Tools
Apps
