Cyrillic names for views

[Nick Gressky <gr...@gmail.com>]

Good afternoon!

I tried to create a view with a Cyrillic name, but all the symbols were
transformed into '?'. Is there any way to add Russian locale support?

I'm using Apache Drill 1.15

Thanks in advance

Re: Cyrillic names for views

[Vitalii Diravka <vi...@apache.org>]

Hi Nick,

Looks like Cyrillic View name works fine for me:

0: jdbc:drill:zk=local> create view МояВьюха as select employee_id,
full_name from cp.`employee.json` limit 2;
+-------+-----------------------------------------------------------+
|  ok   |                          summary                          |
+-------+-----------------------------------------------------------+
| true  | View 'МояВьюха' created successfully in 'dfs.tmp' schema  |
+-------+-----------------------------------------------------------+
1 row selected (0.125 seconds)
0: jdbc:drill:zk=local> describe МояВьюха;
+--------------+------------+--------------+
| COLUMN_NAME  | DATA_TYPE  | IS_NULLABLE  |
+--------------+------------+--------------+
| employee_id  | ANY        | YES          |
| full_name    | ANY        | YES          |
+--------------+------------+--------------+
2 rows selected (0.241 seconds)
0: jdbc:drill:zk=local> select * from МояВьюха;
+--------------+------------------+
| employee_id  |    full_name     |
+--------------+------------------+
| 1            | Sheri Nowmer     |
| 2            | Derrick Whelply  |
+--------------+------------------+
2 rows selected (0.173 seconds)
0: jdbc:drill:zk=local>

*My locale is:*
vitalii@vitalii-pc:~$ locale
LANG=en_US.UTF-8
LANGUAGE=en_US
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LC_COLLATE="en_US.UTF-8"
LC_MONETARY=en_US.UTF-8
LC_MESSAGES="en_US.UTF-8"
LC_PAPER=en_US.UTF-8
LC_NAME=en_US.UTF-8
LC_ADDRESS=en_US.UTF-8
LC_TELEPHONE=en_US.UTF-8
LC_MEASUREMENT=en_US.UTF-8
LC_IDENTIFICATION=en_US.UTF-8
LC_ALL=
vitalii@vitalii-pc:~$

Kind regards
Vitalii


On Tue, Mar 5, 2019 at 12:25 PM Nick Gressky <gr...@gmail.com>
wrote:

> Good afternoon!
>
> I tried to create a view with a Cyrillic name, but all the symbols were
> transformed into '?'. Is there any way to add Russian locale support?
>
> I'm using Apache Drill 1.15
>
> Thanks in advance
>