Hi,
any suggestions on how to implement OR clause and IN clause in the SparkSQL
language integrated queries.
For example:
'SELECT name FROM people WHERE age >= 10 AND month = 2' can be written as
val teenagers = people.where('age >= 10).where('month === 2).select('name)
How do we write 'SELECT name FROM people WHERE age >= 10 OR month = 2' ?
Also how do we write 'SELECT name FROM people WHERE month in ( 2,6)' ??
Any suggestions will be greatly appreciated.
Thanks,
Prem
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/SparkSQL-Language-Integrated-query-OR-clause-and-IN-clause-tp9298.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
