diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/create-index.aql b/asterix/asterix-app/src/test/resources/demo0927/local/create-index.aql
new file mode 100644
index 0000000..3ecd163
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/create-index.aql
@@ -0,0 +1,25 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1,nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+create index NameIndex on Customers(name);
\ No newline at end of file
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-int.aql b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-int.aql
new file mode 100644
index 0000000..3acb8f8
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-int.aql
@@ -0,0 +1,31 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+write output to nc1:"/tmp/mycustomers.adm";
+
+for $c in dataset('Customers')
+where $c.age < 21 
+//  return $c
+return { "custname":$c.name, "custage": $c.age }
+
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-str.aql b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-str.aql
new file mode 100644
index 0000000..35401cf
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-filter-str.aql
@@ -0,0 +1,31 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+write output to nc1:"/tmp/mycustomers.adm";
+
+for $c in dataset('Customers')
+where $c.name = 'Noreen Doe' 
+  return $c
+// return { "custname":$c.name }
+
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/dataset-scan.aql b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-scan.aql
new file mode 100644
index 0000000..2f8746c
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/dataset-scan.aql
@@ -0,0 +1,29 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+write output to nc1:"/tmp/mycustomers.adm";
+
+for $c in dataset('Customers')
+return $c
+// return { "custname":$c.name }
\ No newline at end of file
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/declare-index.aql b/asterix/asterix-app/src/test/resources/demo0927/local/declare-index.aql
new file mode 100644
index 0000000..ecacc49
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/declare-index.aql
@@ -0,0 +1,25 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1,nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+declare index NameIndex on Customers(name);
\ No newline at end of file
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/join-cust-ord.aql b/asterix/asterix-app/src/test/resources/demo0927/local/join-cust-ord.aql
new file mode 100644
index 0000000..b262860
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/join-cust-ord.aql
@@ -0,0 +1,42 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+
+declare type OrderType as closed {
+  oid: int32,
+  cid: int32,
+  orderstatus: string,
+  orderpriority: string,
+  clerk: string,
+  total: float
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+declare dataset Orders(OrderType)
+  partitioned by key oid on group1;
+
+write output to nc1:"/tmp/custorder.adm";
+
+for $c in dataset('Customers')
+for $o in dataset('Orders')
+where $c.cid = $o.cid
+return {"cust":$c.name, "ordertot":$o.total} 
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/load-cust.aql b/asterix/asterix-app/src/test/resources/demo0927/local/load-cust.aql
new file mode 100644
index 0000000..b71731c
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/load-cust.aql
@@ -0,0 +1,28 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+load dataset Customers 
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1:///tmp/customerData.adm"),("format"="json")) pre-sorted;
+
diff --git a/asterix/asterix-app/src/test/resources/demo0927/local/load-ord.aql b/asterix/asterix-app/src/test/resources/demo0927/local/load-ord.aql
new file mode 100644
index 0000000..15ba4cf
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/local/load-ord.aql
@@ -0,0 +1,20 @@
+use dataverse demo0927;
+
+declare type OrderType as closed {
+  oid: int32,
+  cid: int32,
+  orderstatus: string,
+  orderpriority: string,
+  clerk: string,
+  total: float
+}
+
+declare nodegroup group1 on nc1, nc2;
+
+declare dataset Orders(OrderType)
+  partitioned by key oid on group1;
+
+load dataset Orders from nc1:"/tmp/orderData.json";
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1:///tmp/orderData.json"),("format"="adm")) pre-sorted;
+
diff --git a/asterix/asterix-app/src/test/resources/demo0927/rainbow/01-load-cust.aql b/asterix/asterix-app/src/test/resources/demo0927/rainbow/01-load-cust.aql
new file mode 100644
index 0000000..74502a0
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/rainbow/01-load-cust.aql
@@ -0,0 +1,26 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+load dataset Customers from rainbow-01:"/home/hyracks/demo-data/customerData.json";
+//  delete dataset Customers;
\ No newline at end of file
diff --git a/asterix/asterix-app/src/test/resources/demo0927/rainbow/02-filter-cust.aql b/asterix/asterix-app/src/test/resources/demo0927/rainbow/02-filter-cust.aql
new file mode 100644
index 0000000..2ed1304
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/rainbow/02-filter-cust.aql
@@ -0,0 +1,31 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+
+write output to rainbow-01:"/home/hyracks/mycustomers.adm";
+
+for $c in dataset('Customers')
+// where $c.age < 21
+where $c.name = 'Noreen Doe' 
+  return $c
+// return { "custname":$c.name }
diff --git a/asterix/asterix-app/src/test/resources/demo0927/rainbow/03-load-ord.aql b/asterix/asterix-app/src/test/resources/demo0927/rainbow/03-load-ord.aql
new file mode 100644
index 0000000..a9bfe61
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/rainbow/03-load-ord.aql
@@ -0,0 +1,18 @@
+use dataverse demo0927;
+
+declare type OrderType as closed {
+  oid: int32,
+  cid: int32,
+  orderstatus: string,
+  orderpriority: string,
+  clerk: string,
+  total: float
+}
+
+declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05;
+
+declare dataset Orders(OrderType)
+  partitioned by key oid on group1;
+
+load dataset Orders from rainbow-01:"/home/hyracks/demo-data/orderData.json";
+// delete dataset Orders;
diff --git a/asterix/asterix-app/src/test/resources/demo0927/rainbow/04-join-custord.aql b/asterix/asterix-app/src/test/resources/demo0927/rainbow/04-join-custord.aql
new file mode 100644
index 0000000..57cc397
--- /dev/null
+++ b/asterix/asterix-app/src/test/resources/demo0927/rainbow/04-join-custord.aql
@@ -0,0 +1,42 @@
+use dataverse demo0927;
+
+declare type CustomerType as closed {
+  cid: int32, 
+  name: string,
+  age: int32?,
+  address: AddressType?,
+  lastorder: {
+    oid: int32,
+    total: float
+  }
+}
+
+declare type AddressType as closed {
+  number: int32, 
+  street: string,
+  city: string
+}
+
+
+declare type OrderType as closed {
+  oid: int32,
+  cid: int32,
+  orderstatus: string,
+  orderpriority: string,
+  clerk: string,
+  total: float
+}
+
+declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05;
+
+declare dataset Customers(CustomerType) 
+  partitioned by key cid on group1;
+declare dataset Orders(OrderType)
+  partitioned by key oid on group1;
+
+write output to rainbow-01:"/home/hyracks/custorder.adm";
+
+for $c in dataset('Customers')
+for $o in dataset('Orders')
+where $c.cid = $o.cid and $c.age < 21
+return {"cust":$c.name, "custage": $c.age, "ordertot":$o.total}