Fixed the issue by using sed instead: fread("hadoop fs -text /path/to/the/file.csv |sed -n '1p;/2MS-US/p'", fill=TRUE) The 1p part prints the first line, which are the headers, so this way I was able to keep the headers as well as the rows that match the string.
... View more
