ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7884) Ship SQL scripts with same database in Ignite
Date Mon, 05 Mar 2018 22:00:00 GMT
Denis Magda created IGNITE-7884:

             Summary: Ship SQL scripts with same database in Ignite
                 Key: IGNITE-7884
                 URL: https://issues.apache.org/jira/browse/IGNITE-7884
             Project: Ignite
          Issue Type: New Feature
          Components: examples, sql
    Affects Versions: 2.5
            Reporter: Denis Magda
             Fix For: 2.5

As per discussion on @dev list, let's ship two kind of SQL scripts that can be used to create
and populate a database quickly:



The database below is suggested to be used because it represents real data, allows setting
up affinity collocation and demonstrate meaningful SQL queries with joins:



First, this script can be used as is and executed in any SQL tool such as SQLline.

Second, to demonstrate the use of {{COPY}} command we should take the same script, create
a file that will store DDL statements and turn INSERTS into a CSV file.


This message was sent by Atlassian JIRA

View raw message