Changes between Initial Version and Version 8 of Ticket #772
- Timestamp:
- Jul 14, 2015, 3:10:31 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #772
- Property Status new → assigned
- Property Cc added
- Property Component undecided → conversion
- Property Milestone → 9.2
- Property Owner changed from to
-
Ticket #772 – Description
initial v8 1 The documented inv_csv function does not actually seem to be supported. 2 E.g. 1 Implement an `inv_csv` function for reading nD CSV files. 2 3 Not strictly for CSV, as the formatting doesn't matter much actually, so it's very flexible. 4 Numbers from the input file are read in order of appearance and stored without any reordering in rasdaman; 5 whitespace plus the following characters are ignored: '{', '}', ',', '"', '\'', '(', ')', '[', ']' 6 7 Mandatory extra parameters: 8 - `domain` - minterval, e.g. `[1:5,0:10,2:3]` 9 - `basetype` - array base type, e.g. `RGBPixel`, `long`, `char`, etc. 10 11 == Example == 12 `A` is a 2x3 array of longs: 3 13 {{{ 4 rasql -q "create collection test3d GreySet3" --user rasadmin --passwd ... 5 rasql -q 'insert into test3d values inv_csv($1)' --file test3d.csv --user rasadmin --passwd ... 14 1,2,3,2,1,3 6 15 }}} 7 gives error: 16 Inserting `A` can be done with 8 17 {{{ 9 Executing insert query...rasdaman error 0: Exception: Transfer Failed 18 insert into A values inv_csv($1, "domain=[0:1,0:2];basetype=long") 10 19 }}} 11 with log file message: 20 21 `B` is an 1x2 array of RGB values 12 22 {{{ 13 Request: 'insert into test3d values inv_csv(#MDD0#)'...parsing...checking semantics... 14 QtConversion::checkType() for conversion inv_csv assume the result marray <char> 15 evaluating...importing CSV data not yet implemented 23 {1,2,3},{2,1,3} 16 24 }}} 25 Inserting `B` can be done with 26 {{{ 27 insert into B values inv_csv($1, "domain=[0:0,0:1];basetype=struct {char red, char blue, char green}") 28 }}} 29 `B` could just as well be formatted like this with the same effect: 30 {{{ 31 1 2 3 32 2 1 3 33 }}}
