This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • Overview sqlline tool
Skip to end of metadata
Go to start of metadata

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

 

commandnotestatuscomment
!allExecute the specified SQL against all the current connections.OK---
!autocommitEnable or disable automatic transaction commit modeFAILEDImpossible to disable autocommit
!batchStart or execute a batch of SQL statementsOK---
!briefEnable terse output modeOK---
!verboseEnable verbose output modeOK---
!callExecute a callable statementN/ADoesn't support from our side.
!closeClose the active connectionFAILEDError message: Ambiguous command: [close, closeall]
!closeallClose all current open connectionsOK---
!columnsDisplay columns of a tableOK

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.FAILEDautocommit always true so commit doesn't make sense
!connectConnect to a databaseOK---
!dbinfoList metadata information about the current connection.OK---
!describeSynonym for columns (if an argument is specified) or tables (if no argument is specified).
FAILED

Doesn't work without parameter. so now !describe =!columns

!dropallDrop all tables in the databaseOK---
!exportedkeysList exported foreign keys for a databaseN/ADoesn't support from our side.
!goChange to a different active connectionOK---
!helpDisplay help informationOKHelp shows not all commands that there are in manual.
!historyDisplay the command historyOK---
!importedkeysList imported foreign keys for a databaseN/ADoesn't support from our side.
!indexesDisplay indexes for a tableOK---
!isolationSet the transaction isolation mode for the active connectionFAILEDautocommit always equals true so I can't to test this parameter
!listDisplay all active connectionsOK---
!manualDisplay sqlline manualOK---
!metadataInvoke arbitrary metadata commandsOK---
!nickname

Create a friendly name for the connection (updates command prompt)

OK---
!outputformatChange the method for displaying SQL resultsOK---
!primarykeysDisplay the primary key columns for a tableOK---
!proceduresList stored proceduresN/ADoesn't support from our side.
!properties Connect to the database defined in the specified properties file.OK---
!quitExit SQLLineOK---
!reconnectReconnect to the current databaseOK---
!recordBegin recording all output from SQL commandsOK---
!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
!rollbackRoll back the current transaction (if autocommit is off)FAILEDautocommit always true so rollback doesn't make sense
!runExecute a command scriptOK---
!saveSave the current preferences to some fileFAILED

Doesn't override current parameters in ~/.sqlline/sqlline.properties 

!scanScan class path for JDBC driversFAILEDOutput - 

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

!scriptSave executed commands to a fileOK---
!set

Set a sqlline variable

FAILEDValues of parameters wasn't changed
!sql Execute a SQL against a databaseOK---
!tablesList all the tables in the databaseOK---

 

 

  • No labels