I have a table named orders in hive with following data:
I can do select * from orders where OID="A-102 from hive shell and it provides me the result.
How can i do the same query using Spark SQL and Scala as it doesn't recognize "A-102" as a single string.
Any string with hyphen(A-102) or blank spaces(A 102) are not treated as a single string and only a part of the string is used in the where clause for comparison.
Any suggestions are appreciated.