[
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)
