improvements for demo
- add demo cluster
- add example mugshot.com data and queries
- automatic configuration of a cluster
- set MANAGIX_HOME implicitly
- better AQL lexer error reporting
- better eror reporting in ADM parser
- fix and optimize construction of asterix zip for deployment
Change-Id: I9d80402cef72a15271766031b6f06c7220e4ad5a
Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/95
Reviewed-by: Ian Maxon <imaxon@uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Raman Grover <ramang@uci.edu>
diff --git a/asterix-installer/src/main/resources/examples/mugshot/aql/create.aql b/asterix-installer/src/main/resources/examples/mugshot/aql/create.aql
new file mode 100644
index 0000000..acade56
--- /dev/null
+++ b/asterix-installer/src/main/resources/examples/mugshot/aql/create.aql
@@ -0,0 +1,51 @@
+drop dataverse TinySocial if exists;
+create dataverse TinySocial;
+use dataverse TinySocial;
+
+create type EmploymentType as open {
+ organization-name: string,
+ start-date: date,
+ end-date: date?
+}
+
+create type MugshotUserType as {
+ id: int32,
+ alias: string,
+ name: string,
+ user-since: datetime,
+ address: {
+ street: string,
+ city: string,
+ state: string,
+ zip: string,
+ country: string
+ },
+ friend-ids: {{ int32 }},
+ employment: [EmploymentType]
+}
+
+create type MugshotMessageType as closed {
+ message-id: int32,
+ author-id: int32,
+ timestamp: datetime,
+ in-response-to: int32?,
+ sender-location: point?,
+ tags: {{ string }},
+ message: string
+}
+
+create dataset MugshotUsers(MugshotUserType)
+ primary key id;
+create dataset MugshotMessages(MugshotMessageType)
+ primary key message-id;
+
+create index msUserSinceIdx
+ on MugshotUsers(user-since);
+create index msTimestampIdx
+ on MugshotMessages(timestamp);
+create index msAuthorIdx
+ on MugshotMessages(author-id) type btree;
+create index msSenderLocIndex
+ on MugshotMessages(sender-location) type rtree;
+create index msMessageIdx
+ on MugshotMessages(message) type keyword;