Escaping special characters in cross filters with Databricks (eg '\') #29415
Unanswered
maximStafeevAtAllscripts
asked this question in
Q&A / Help
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I connected Databricks to Superset and got some strange issue.
One of the column in my data contains username in format 'SERVER_NAME\UserName'
When I click on this value in chart I create cross filter.
It adds to all the queries something like
AND username IN ('SERVER_NAME\UserName')
But Databricks interprets this string as contained symbol '\U'.
We don't know, how force Databricks to not parse strings.
So may be there is a simple way to preprocess all the values in SQL-query?
I need to get this part converted to
('\' -> '\\')
:AND username IN ('SERVER_NAME\\UserName')
Beta Was this translation helpful? Give feedback.
All reactions