Added asterix project
git-svn-id: https://asterixdb.googlecode.com/svn/trunk/asterix@12 eaa15691-b419-025a-1212-ee371bd00084
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/10.aql b/asterix-app/src/test/resources/runtimets/queries/scan/10.aql
new file mode 100644
index 0000000..7878583
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/10.aql
@@ -0,0 +1,30 @@
+/* scan and print a delimited text file */
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type DBLPType as open {
+ id: int32,
+ dblpid: string,
+ title: string,
+ authors: string,
+ misc: string
+}
+
+
+create nodegroup group1 if not exists on nc1;
+
+create dataset DBLP1(DBLPType)
+ partitioned by key id on group1;
+
+// drop dataset DBLP1;
+load dataset DBLP1
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":"));
+
+
+write output to nc1:"rttest/scan_10.adm";
+
+for $paper in dataset('DBLP1')
+order by $paper.id
+return $paper
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/20.aql b/asterix-app/src/test/resources/runtimets/queries/scan/20.aql
new file mode 100644
index 0000000..a07aab2
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/20.aql
@@ -0,0 +1,29 @@
+/* scan and print an ADM file as a dataset of closed records */
+
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type DBLPType as closed {
+ id: int32,
+ dblpid: string,
+ title: string,
+ authors: string,
+ misc: string
+}
+
+create nodegroup group1 if not exists on nc1;
+
+create dataset DBLPadm(DBLPType)
+ partitioned by key id on group1;
+
+// drop dataset DBLPadm;
+load dataset DBLPadm
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/dblp-small/dblp-small.adm"),("format"="adm"));
+
+write output to nc1:"rttest/scan_20.adm";
+
+for $paper in dataset('DBLPadm')
+order by $paper.id
+return $paper
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/30.aql b/asterix-app/src/test/resources/runtimets/queries/scan/30.aql
new file mode 100644
index 0000000..057bdae
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/30.aql
@@ -0,0 +1,23 @@
+/* scan and print 2 ADM file splits as an external dataset of closed records */
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type DBLPType as closed {
+ id: int32,
+ dblpid: string,
+ title: string,
+ authors: string,
+ misc: string
+}
+
+create nodegroup group1 if not exists on nc1;
+
+create external dataset DBLPsplits(DBLPType)
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/dblp-small/dblp-small.adm"),("format"="adm"));
+
+write output to nc1:"rttest/scan_30.adm";
+
+for $paper in dataset('DBLPsplits')
+return $paper
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/alltypes_01.aql b/asterix-app/src/test/resources/runtimets/queries/scan/alltypes_01.aql
new file mode 100644
index 0000000..e772502
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/alltypes_01.aql
@@ -0,0 +1,44 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+
+create type AddressType as open {
+ number: int32,
+ street: string,
+ city: string
+}
+
+
+create type AllType as open {
+ id: int32,
+ name: string,
+ age: float,
+ salary: double,
+ married: boolean,
+ interests: {{string}},
+ children: [string],
+ address: AddressType,
+ dob: date,
+ time: time,
+ datetime: datetime,
+ duration: duration,
+ location2d: point,
+ location3d: point3d,
+ line: line,
+ polygon: polygon,
+ circle: circle
+
+ // binary
+ // union
+}
+
+
+create external dataset All(AllType)
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/allData.json"),("format"="adm"));
+
+write output to nc1:"rttest/scan_alltypes_01.adm";
+
+for $a in dataset('All')
+return $a
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/numeric_types_01.aql b/asterix-app/src/test/resources/runtimets/queries/scan/numeric_types_01.aql
new file mode 100644
index 0000000..f716d1c
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/numeric_types_01.aql
@@ -0,0 +1,23 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type NumericType as open {
+ id: int32,
+ int8Field: int8?,
+ int16Field: int16?,
+ int32Field: int32?,
+ int64Field: int64?,
+ floatField: float?,
+ doubleField: double?
+}
+
+
+create external dataset Numeric(NumericType)
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/numericData.adm"),("format"="adm"));
+
+write output to nc1:"rttest/scan_numeric_types_01.adm";
+
+for $a in dataset('Numeric')
+return $a
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_01.aql b/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_01.aql
new file mode 100644
index 0000000..1ad5244
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_01.aql
@@ -0,0 +1,22 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+
+create type SpatialType as open {
+ id: int32,
+ point: point,
+ point3d: point3d,
+ line: line,
+ polygon: polygon,
+ circle: circle
+}
+
+create external dataset Spatial(SpatialType)
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/spatialData.json"),("format"="adm"));
+
+write output to nc1:"rttest/scan_spatial_types_01.adm";
+
+for $a in dataset('Spatial')
+return $a
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_02.aql b/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_02.aql
new file mode 100644
index 0000000..6bca691
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/spatial_types_02.aql
@@ -0,0 +1,27 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type SpatialType as open {
+ id: int32,
+ point: point,
+ point3d: point3d,
+ line: line,
+ polygon: polygon,
+ circle: circle
+}
+
+create nodegroup group1 on nc1;
+
+create dataset Spatial2(SpatialType)
+ partitioned by key id on group1;
+
+load dataset Spatial2
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/spatialData.txt"),("format"="delimited-text"),("delimiter"="|")) pre-sorted;
+
+
+write output to nc1:"rttest/scan_spatial_types_02.adm";
+
+for $a in dataset('Spatial2')
+return $a
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_01.aql b/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_01.aql
new file mode 100644
index 0000000..d5074a0
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_01.aql
@@ -0,0 +1,20 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type TempType as open {
+ id: int32,
+ date: date,
+ time: time,
+ datetime: datetime,
+ duration: duration
+}
+
+create external dataset Temp(TempType)
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/tempData.json"),("format"="adm"));
+
+write output to nc1:"rttest/scan_temp_types_01.adm";
+
+for $a in dataset('Temp')
+return $a
diff --git a/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_02.aql b/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_02.aql
new file mode 100644
index 0000000..22289ef
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/scan/temp_types_02.aql
@@ -0,0 +1,26 @@
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type TempType as closed {
+ id: int32,
+ date: date,
+ time: time,
+ datetime: datetime,
+ duration: duration
+}
+
+create nodegroup group1 on nc1;
+
+create dataset Temp2(TempType)
+ partitioned by key id on group1;
+
+load dataset Temp2
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/nontagged/tempData.txt"),("format"="delimited-text"),("delimiter"="|")) pre-sorted;
+
+
+write output to nc1:"rttest/scan_temp_types_02.adm";
+
+for $a in dataset('Temp2')
+return $a