how to split a large csv file in unix command line

Question

I am just splitting a very large csv file in to parts. When ever i run the following command. the doesn't completely split rather returns me the following error. how can i avoid the split the whole file.

       awk -F, '{print > $2}' test1.csv 

       awk: YY1 makes too many open files
       input record number 31608, file test1.csv
       source line number 1

Answer 1

Just close the files after writing:

awk -F, '{print > $2; close($2)}' test1.csv