Search code examples
apache-spark-sqlsnappydata

Import complex data type(Array) from csv to snappydata

From my previous question I came to know the way one can insert array.

Now I want to insert a latge amount of data into the table. From this reference of snappydata i was able to import a large amount into the tables. But when i tried to import complex data type like Array it isn't supporting. 

CSV sample:
'name',1,[1,2,4]
or
'name',1,array(1,2,4)

Can anyone tell me how can I insert array into table from CSV file?

Solution

  • I solved the above question by converting the CSV to JSON. I followed the documentation for json to snappydata.