Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-7884

Ship SQL scripts with same database in Ignite

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5
    • Fix Version/s: 2.5
    • Component/s: examples, sql
    • Labels:
      None

      Description

      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:

      http://apache-ignite-developers.2346864.n4.nabble.com/Shipping-SQL-script-CSV-files-in-Ignite-examples-td27440.html

       

      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:

      https://github.com/dmagda/ignite_world_demo/blob/master/ignite_world.sql

       

      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.

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vozerov Vladimir Ozerov
                Reporter:
                dmagda Denis A. Magda
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: