Re: Spark Dataset withColumn issue

2020-11-12 Thread Lalwani, Jayesh
Dataset withColumn issue CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you can confirm the sender and know the content is safe. Ohh Thanks a lot On Thu, Nov 12, 2020, 21:23 Subash Prabakar mailto:subashpraba...@gmail.com

Re: Spark Dataset withColumn issue

2020-11-12 Thread Vikas Garg
Ohh Thanks a lot On Thu, Nov 12, 2020, 21:23 Subash Prabakar wrote: > Hi Vikas, > > He suggested to use the select() function after your withColumn function. > > val ds1 = ds.select("Col1", "Col3").withColumn("Col2", > lit("sample”)).select(“Col1”, “Col2”, “Col3") > > > Thanks, > Subash > >

Re: Spark Dataset withColumn issue

2020-11-12 Thread Subash Prabakar
Hi Vikas, He suggested to use the select() function after your withColumn function. val ds1 = ds.select("Col1", "Col3").withColumn("Col2", lit("sample”)).select(“Col1”, “Col2”, “Col3") Thanks, Subash On Thu, Nov 12, 2020 at 9:19 PM Vikas Garg wrote: > I am deriving the col2 using with colunn

Re: Spark Dataset withColumn issue

2020-11-12 Thread Sean Owen
You can still simply select the columns by name in order, after .withColumn() On Thu, Nov 12, 2020 at 9:49 AM Vikas Garg wrote: > I am deriving the col2 using with colunn which is why I cant use it like > you told me > > On Thu, Nov 12, 2020, 20:11 German Schiavon > wrote: > >> ds.select("Col1"

Re: Spark Dataset withColumn issue

2020-11-12 Thread Vikas Garg
I am deriving the col2 using with colunn which is why I cant use it like you told me On Thu, Nov 12, 2020, 20:11 German Schiavon wrote: > ds.select("Col1", "Col2", "Col3") > > On Thu, 12 Nov 2020 at 15:28, Vikas Garg wrote: > >> In Spark Datase, if we add additional column using >> withColumn >

Re: Spark Dataset withColumn issue

2020-11-12 Thread German Schiavon
ds.select("Col1", "Col2", "Col3") On Thu, 12 Nov 2020 at 15:28, Vikas Garg wrote: > In Spark Datase, if we add additional column using > withColumn > then the column is added in the last. > > e.g. > val ds1 = ds.select("Col1", "Col3").withColumn("Col2", lit("sample")) > > the the order of column

Spark Dataset withColumn issue

2020-11-12 Thread Vikas Garg
In Spark Datase, if we add additional column using withColumn then the column is added in the last. e.g. val ds1 = ds.select("Col1", "Col3").withColumn("Col2", lit("sample")) the the order of columns is >> Col1 | Col3 | Col2 I want the order to be >> Col1 | Col2 | Col3 How can I achiev