asterix-app/src/test/resources/fuzzyjoin/pub/040-load-csx.aql

use dataverse fuzzy1;

declare type CSXType as open {
  id: int32, 
  csxid: string,
  title: string,
  authors: string,
  misc: string
}

declare nodegroup group1 on nc1, nc2;

declare dataset CSX(CSXType) 
  primary key id on group1;

// load dataset CSX from nc1:'/asterix/asterix-app/data/pub-small/csx-small-id.txt'
load dataset  CSX
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1:///asterix/asterix-app/data/pub-small/csx-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted;