ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-5608) SQL scripts execution capability
Date Tue, 10 Oct 2017 23:08:00 GMT

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

Denis Magda edited comment on IGNITE-5608 at 10/10/17 11:07 PM:
----------------------------------------------------------------

Here is the text for help-
{code}
Script for connecting to Ignite cluster via SQLLine.

Usage: ignitesql.sh <ip_address:port> <options>

In the first parameter, you have to explicitly specify the host to connect to.  Make sure
an Ignite node is running on that host. 

For example:
ignitesql.sh 127.0.0.1

Optionally, you can specify a port:
ignitesql.sh 127.0.0.1:10800

Other options include:
-s   | --schema : Schema.
-dj  | --distributedJoins : Distributed joins flag.
-ej  | --enforceJoinOrder : Enforce join order flag.
-c   | --collocated : Collocated flag.
-r   | --replicatedOnly : Replicated only flag.
-ac  | --autoCloseServerCursor : Auto close server cursor flag.
-ssb | --socketSendBuffer : Socket send buffer size.
-srb | --socketReceiveBuffer : Socket receive buffer size.
-tnd | --tcpNoDelay : TCP no delay flag.
-l   | --lazy : Lazy flag.

See https://apacheignite-sql.readme.io/docs/jdbc-driver for more information about these options.
{code}


was (Author: pgarg):
Here is the text for help-
{code}
Script for connecting to Ignite cluster via SQLLine.
Usage: ignitesql.sh <ip_address:port> <options>
In the first parameter, you have to explicitly specify the host to connect to.  Make sure
an Ignite node is running on that host. 
For example:
ignitesql.sh 127.0.0.1
Optionally, you can specify a port:
ignitesql.sh 127.0.0.1:10800

Other options include:
-s   | --schema : Schema.
-dj  | --distributedJoins : Distributed joins flag.
-ej  | --enforceJoinOrder : Enforce join order flag.
-c   | --collocated : Collocated flag.
-r   | --replicatedOnly : Replicated only flag.
-ac  | --autoCloseServerCursor : Auto close server cursor flag.
-ssb | --socketSendBuffer : Socket send buffer size.
-srb | --socketReceiveBuffer : Socket receive buffer size.
-tnd | --tcpNoDelay : TCP no delay flag.
-l   | --lazy : Lazy flag.

See https://apacheignite-sql.readme.io/docs/jdbc-driver for more information about these options.
{code}

> 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
>            Assignee: Oleg Ostanin
>             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)

Mime
View raw message