meredith620 commented on PR #14531:
URL: https://github.com/apache/doris/pull/14531#issuecomment-1325904937
> Is there any strong requirement to support chinese as table or column
name? If not, I am preferred not add this support because both BE and FE use
column names. There may be some potential problems if use chinese as column or
table name. And also I find there are some problems in github workflow so that
I remove some regression test that use chinese.
First, if using doris in an system from scrach, I think it is not hard to
avoid using chinese table or column names.
We found many of our customers in different industry want to expand their
exists production database's analyis abilitiy by introducing an OLAP system. We
recommend them to try doris, then some of them (not too few) found they have
some chinese table or column names in their database but not supported by
doris, so they can't do the analyis jobs by importing tables. And then they
have to choose other databases not as fast as doris but support unicode names.
So here is the situation:
1. Some companies have chinese table names or column names in their OLTP
database for many years, and they want to introduce an OLAP database now
2. There will be a huge cost and protential risks in bussiness systems to
change table or column names, for they do not have as many developers as big
companies
3. Only changing names in doris after imported is not acceptable. Usually
there are hundred of columns in one table, transfering the OLTP-OLAP names
mapping between technical staffs and data analysts is easy to get wrong but not
easy to check.
And it seems not a weird feature since the popular databases also support
unicode names, e.g. mysql, postgresql. So I think to make doris to support
unicode names (not only chinese) could be a solution for different companies in
different industries.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
