java.lang.OutOfMemoryError: UTF16 String size exceeding default value

I was trying to load a tsv files from urls (max file size was 1.05 GB or 1129672402 Bytes)

Executing Spark Scala scripts inside running Spark Application

I have a Java application which performs some Spark pipeline operations e.g.: