[
https://issues.apache.org/jira/browse/IMPALA-9662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Quanlong Huang updated IMPALA-9662:
-----------------------------------
Description:
The existing mask functions can only deal with ASCII characters. It will be
very useful to provide mask functions that can deal with UTF-8 characters, or
to improve current mask fuctions to deal with them as Hive does. Otherwise,
Impala may leak information since we count each UTF-8 character as two. For
example, if we want to mask the last two characters, Impala only masks the last
UTF-8 character.
{code:sql}
hive> select mask_last_n('SQL引擎', 2, 'x', 'x', 'x', 'x');
SQLxx
impala> select mask_last_n('SQL引擎', 2, 'x', 'x', 'x', 'x');
SQL引�xx
{code}
Some common scenarios:
* Masking the last two UTF-8 characters of Chinese names.
* Show only the first several UTF-8 characters of Chinese addresses and mask
all the remaining characters.
However, this depends on our BE support for UTF-8 strings.
was:
The existing mask functions can only deal with ASCII characters. It will be
very useful to provide mask functions that can deal with UTF-8 characters.
Some common scenarios:
* Masking the last two UTF-8 characters of Chinese names.
* Show only the first several UTF-8 characters of Chinese addresses and mask
all the remaining characters.
However, this depends on our BE support for UTF-8 strings.
> Add builtin functions for masking UTF-8 strings
> -----------------------------------------------
>
> Key: IMPALA-9662
> URL: https://issues.apache.org/jira/browse/IMPALA-9662
> Project: IMPALA
> Issue Type: New Feature
> Reporter: Quanlong Huang
> Priority: Major
>
> The existing mask functions can only deal with ASCII characters. It will be
> very useful to provide mask functions that can deal with UTF-8 characters, or
> to improve current mask fuctions to deal with them as Hive does. Otherwise,
> Impala may leak information since we count each UTF-8 character as two. For
> example, if we want to mask the last two characters, Impala only masks the
> last UTF-8 character.
> {code:sql}
> hive> select mask_last_n('SQL引擎', 2, 'x', 'x', 'x', 'x');
> SQLxx
> impala> select mask_last_n('SQL引擎', 2, 'x', 'x', 'x', 'x');
> SQL引�xx
> {code}
> Some common scenarios:
> * Masking the last two UTF-8 characters of Chinese names.
> * Show only the first several UTF-8 characters of Chinese addresses and mask
> all the remaining characters.
> However, this depends on our BE support for UTF-8 strings.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
