- 1150 Views
- 1 replies
- 0 kudos
How to use Java MaskFormatter in sparksql?
I create a function based on Java MaskFormatter function in Databricks/Scala.But when I call it from sparksql, I received error messageError in SQL statement: AnalysisException: Undefined function: formatAccount. This function is neither a built-in/t...
- 1150 Views
- 1 replies
- 0 kudos
- 0 kudos
@Tim zhang​ :The issue is that the formatAccount function is defined as a Scala function, but SparkSQL is looking for a SQL function. You need to register the Scala function as a SQL function so that it can be called from SparkSQL. You can register t...
- 0 kudos
- 5369 Views
- 6 replies
- 3 kudos
Resolved! How to parse/extract/format a string based a pattern?
How to parse, extract or form a string based on a pattern?SQL server has a function which will format the string based on a pattern. example,a string is "abcdefgh", the pattern is XX-XX-XXXX,the the string will be "ab-cd-efgh".How to archive this wit...
- 5369 Views
- 6 replies
- 3 kudos
- 3 kudos
@Tim zhang​ ,thanks for your code, and here is your answer I asked this question in Stackoverflow and got this answer Here is the Stackoverflow link- https://stackoverflow.com/questions/74845760/how-to-parse-a-pattern-and-use-it-to-format-a-string-u...
- 3 kudos