Igniters, To demonstrate Ignite SQL capabilities at different events, I usually:
1. take an SQL script 2. preload the data from the script with SQLLine tool that is already shipped in Ignite 3. run DML operations from Web Console, code or other SQL tools While SQLLine tool is available once Ignite is downloaded, the user has to look for a sample SQL script and adapt it to Ignite SQL specification (mostly DDL). Let's ship a script or two in Ignite "examples" folder to facilitate the user. In general, I would add : - DDL + DML script (.sql) that creates a schema and preloads data with INSERTS. The script will include a command that turns on/off the streaming mode that is in the development. - DDL script + CSV file with data. This set of scripts are useful for COPY command that should be supported soon. Presently, I would definitely recommend to include the script below that represents a world database of Cities and Countries. It shows how to define affinity collocation, how to use Ignite WITH statement, etc: https://github.com/dmagda/ignite_world_demo/blob/master/ignite_world.sql Parts of this database are already in use in our SQL getting started. As for CSV, we can take that Cities+Countries files and convert INSERT commands to CSV records. Thoughts, ideas? -- Denis
