| 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 dataset Temp2(TempType) |
| partitioned by key id; |
| |
| 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 |