[IGNITE-6656] SQLLine Documentation

• Type: Task
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 2.3
• Component/s: documentation
• Assignee: Prachi Garg
• Reporter: Denis A. Magda
• Created: 17/Oct/17 18:47
• Updated: 26/Oct/17 19:47
• Resolved: 26/Oct/17 19:47

Description

SQLLine is officially used as a default command line tool for SQL connectivity in Ignite. Document the tool usage on a dedicated page:
https://apacheignite-sql.readme.io/docs/sqlline

Consider the following sections:

1. The tool overview with a list of commands that are supported and not by Ignite. The current list is here [1]. Split the list into 2 parts on readme.io (supported and not) and briefly describe eache command.
2. Connectivity section. Start a cluster and connect to the tool using ./ignitesql.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/ script. Add a tab for ignite.bat file as well.
3. Usage section. Execute DDL and DML commands taken from the getting started as it's done here [2]. When tables and indexes are created, run !metadata to show the structure.

Use private 2.3 builds generated by TC to make sure the doc is ready for the release.

[1] https://cwiki.apache.org/confluence/display/IGNITE/Overview+sqlline+tool
[2] https://apacheignite-sql.readme.io/v2.1/docs/sql-tooling