Re: Tab delimited csv import and empty columns

2020-07-30 Thread German Schiavon Matteo
Hey, I understand that your empty values in your CSV are "" , if so, try this option: *.option("emptyValue", "\"\"")* Hope it helps On Thu, 30 Jul 2020 at 08:49, Stephen Coy wrote: > Hi there, > > I’m trying to import a tab delimited file with: > > Dataset catalogData = sparkSession >

Tab delimited csv import and empty columns

2020-07-30 Thread Stephen Coy
Hi there, I’m trying to import a tab delimited file with: Dataset catalogData = sparkSession .read() .option("sep", "\t") .option("header", "true") .csv(args[0]) .cache(); This works great, except for the fact that any column that is empty is given the value null, when I need these