flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From twalthr <...@git.apache.org>
Subject [GitHub] flink pull request #4127: [FLINK-6892][table]Add L/RPAD supported in SQL
Date Wed, 10 Jan 2018 09:50:07 GMT
Github user twalthr commented on a diff in the pull request:

    https://github.com/apache/flink/pull/4127#discussion_r160628359
  
    --- Diff: docs/dev/table/sql.md ---
    @@ -1744,6 +1743,29 @@ CONCAT_WS(separator, string1, string2,...)
           </td>
           <td>
             <p>Returns the string that results from concatenating the arguments using
a separator. The separator is added between the strings to be concatenated. Returns NULL If
the separator is NULL. CONCAT_WS() does not skip empty strings. However, it does skip any
NULL argument. E.g. <code>CONCAT_WS("~", "AA", "BB", "", "CC")</code> returns
<code>AA~BB~~CC</code></p>
    +  </td>
    +    </tr>
    +
    +        <tr>
    +      <td>
    +        {% highlight text %}
    +LPAD(text string, len integer, pad string)
    +{% endhighlight %}
    +      </td>
    +      <td>
    +        <p>Returns the string text, left-padded with the string pad to a length
of len characters. If text is longer than len, the return value is shortened to len characters.</p>
    --- End diff --
    
    Can you add two examples where the length is greater/smaller that the string.


---

Mime
View raw message