[jira] [Comment Edited] (IGNITE-5608) SQL scripts execution capability

["Denis Magda (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16193166#comment-16193166 ] 

Denis Magda edited comment on IGNITE-5608 at 10/5/17 4:44 PM:
--------------------------------------------------------------

SQLLine tool was selected as an Ignite CML tool SQL connectivity. Present capabilities:
https://cwiki.apache.org/confluence/display/IGNITE/Overview+sqlline+tool

Ignite community will deliver the tool in binary releases. It's recommended to create a shell script to simplify the connectivity phase:
* name the script as {{ignitedb.sh}} for Unix and {{ignitedb.bat}} for Windows.
* the script uses the following connection string by default: {{.sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true --verbose=true --showWarnings=true --showNestedErrs=true -u jdbc:ignite:thin://127.0.0.1/}}
* make up parameters list to adjust Ignite specific part of the connection string: Ignite IP and port, streaming mode, etc. The full list of supported parameters is here: https://apacheignite-sql.readme.io/docs/jdbc-driver#jdbc-thin-driver


was (Author: dmagda):
SQLLine tool was selected as an Ignite CML tool SQL connectivity. Present capabilities:
https://cwiki.apache.org/confluence/display/IGNITE/Overview+sqlline+tool

Ignite community will deliver the tool in binary releases. It's recommended to create a shell script to simplify the connectivity phase:
* name the script as `ignitedb.sh` for Unix and `ignitedb.bat` for Windows.
* the script uses the following connection string by default: `.sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true --verbose=true --showWarnings=true --showNestedErrs=true -u jdbc:ignite:thin://127.0.0.1/`
* make up parameters list to adjust Ignite specific part of the connection string: Ignite IP and port, stearming mode, etc. The full list of supported parameters is here: https://apacheignite-sql.readme.io/docs/jdbc-driver#jdbc-thin-driver

> SQL scripts execution capability
> --------------------------------
>
>                 Key: IGNITE-5608
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5608
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>            Reporter: Denis Magda
>             Fix For: 2.3
>
>
> There should be a way to feed an SQL script to Ignite and execute it right away. A script can consist of DDL command that will define cluster and SQL configuration as well as of DML commands that, for instance, preload data into Ignite.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)