quot;m_123")).count
res0: Long =
1
scala> df.filter($"msrid".isin("m_123","m_111","m_145")).count
res1: Long = 3
On Mon, Apr 17, 2017 at 10:50 AM, nayan sharma
wrote:
> Thanks for responding.
> df.filter($”msrid”===“m_123” || $”msrid”===
Thanks for responding.
df.filter($”msrid”===“m_123” || $”msrid”===“m_111”)
there are lots of workaround to my question but Can you let know whats wrong
with the “isin” query.
Regards,
Nayan
> Begin forwarded message:
>
> From: ayan guha
> Subject: Re: isin query
> Date: 17 Apr
How about using OR operator in filter?
On Tue, 18 Apr 2017 at 12:35 am, nayan sharma
wrote:
> Dataframe (df) having column msrid(String) having values
> m_123,m_111,m_145,m_098,m_666
>
> I wanted to filter out rows which are having values m_123,m_111,m_145
>
> df.filter($"msrid".isin("m_123","m_
Dataframe (df) having column msrid(String) having values
m_123,m_111,m_145,m_098,m_666
I wanted to filter out rows which are having values m_123,m_111,m_145
df.filter($"msrid".isin("m_123","m_111","m_145")).count
count =0
while
df.filter($"msrid".isin("m_123")).count
count=121212
I have tried
