Github user chenghao-intel commented on a diff in the pull request:

    https://github.com/apache/spark/pull/7208#discussion_r33894844
  
    --- Diff: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/stringOperations.scala
 ---
    @@ -298,3 +299,56 @@ case class StringLength(child: Expression) extends 
UnaryExpression with ExpectsI
     
       override def prettyName: String = "length"
     }
    +
    +/**
    + *  A function that return soundex code of the given string expression.
    + */
    +case class SoundEx(child: Expression) extends UnaryExpression with 
ExpectsInputTypes {
    +  @transient lazy val so = new Soundex
    +
    +  override def dataType: DataType = StringType
    +
    +  override def inputTypes: Seq[DataType] = Seq(StringType)
    +
    +  override def eval(input: InternalRow): Any = {
    +    val string = child.eval(input)
    +    if (string == null) {
    +      null
    +    } else {
    +      val str: String = string.toString
    +      UTF8String.fromString(so.encode(str))
    +    }
    +  }
    +}
    +
    +/**
    + * Returns string, with the first letter of each word in uppercase,
    + * all other letters in lowercase. Words are delimited by whitespace.
    + */
    +case class InitCap(child: Expression) extends UnaryExpression with 
ExpectsInputTypes {
    +  @transient lazy val so = new Soundex
    +
    +  override def dataType: DataType = StringType
    +
    +  override def inputTypes: Seq[DataType] = Seq(StringType)
    +
    +  override def eval(input: InternalRow): Any = {
    --- End diff --
    
    Probably very difficult, there are some special cases. See 
`java.lang.ConditionalSpecialCasing`. Not sure if there any third-party library 
can work with bytes.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to