I used the COPY command from mapdql to export a 100 million row table to a csv file. It mostly worked - however, there is randomly through the file a few unprintable characters such as ^S or ^F. Also, there were a few lines where two database rows appeared on the same line separated by a “*” character.
I am not sure if there a stability/file system problems with my Ubuntu 16.04 Linux system or if the mapd mapdql/COPY command introduced these errors into the file.
Has anyone else seen these kinds of issues using the COPY command to make a CSV file?