RE: [SparkSQL] Escaping a query for a dataframe query

2017-06-16 Thread mark.jenki...@baesystems.com
e). So just add two extra backslashes before the quote inside the string. sqlContext.sql("SELECT * FROM mytable WHERE (mycolumn BETWEEN 1 AND 2) AND (myudfsearchfor(\"start\\\"end\"))" -- Michael Mior mm...@apache.org<mailto:mm...@apache.org> 2017-06-15 12:05 GMT-04:00

[SparkSQL] Escaping a query for a dataframe query

2017-06-15 Thread mark.jenki...@baesystems.com
Hi, I have a query sqlContext.sql("SELECT * FROM mytable WHERE (mycolumn BETWEEN 1 AND 2) AND (myudfsearchfor(\"start\"end\"))" How should I escape the double quote so that it successfully parses? I know I can use single quotes but I do not want to since I may need to search for a single