Hello Carl,

There's no UTF-8 support in Impala yet, but you could write your own
UDF to handle it (or contribute a patch).

Regards

On 18 December 2017 at 07:38, Dong Bo 董博 <[email protected]> wrote:
> Hi Forks,
>
>
>
> Impala treats Chinese word as 3 letters , for English word 1 letter, Is
> there any settings to make it easy to substring a mixed String just like
> what hive does?
>
>
>
> Eg :  select substr('test测试test', 1 ,5 ) ,
>
> returns :  test测  ,  NOT : test�
>
>
>
>
>
> Thanks
>
> Carl

Reply via email to