Trouble loading CSV


#1

Spawning a new ticket from SciDB community edition installer script

@balekaki asked

… i am having trouble to load my csv data file in my scidb array. For example

AFL% load(intensityFlat ,'/tmp/intensity_data.csv', -2, 'CSV');

I am confused with the path --do i create tmp folder and save the csv file inside it or what? How do i go about this?


SciDB community edition installer script
#2

@balekaki

It seems you are trying the example from our doc-page on load.

Yes, as mentioned in the doc, you would need to:

Create a text file /tmp/intensity_data.csv with the following content:

'High',0,100
'High',2,97
'Medium',2,null
'Medium',3,67
'Low',3,null
'Low',4,55

i.e. something like

cat <<EOF > /tmp/intensity_data.csv
'High',0,100
'High',2,97
'Medium',2,null
'Medium',3,67
'Low',3,null
'Low',4,55
EOF