[jira] [Resolved] (KYLIN-5482) Fix the problem that measure name include character that KE does not support when adding measures in batch

["Laura Xia (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-5482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Xia resolved KYLIN-5482.
------------------------------
    Resolution: Fixed

> Fix the problem that measure name include character that KE does not support when adding measures in batch
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-5482
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5482
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Laura Xia
>            Assignee: Laura Xia
>            Priority: Major
>             Fix For: 5.0-alpha
>
>
> h2. 产品行为定义
>  * 问题应该主要发生在"批量添加维度、度量"，其他地方不会遇到这个问题
>  * 批量添加维度、度量时，根据列名自动生成维度名称、度量名称，如果出现列名支持、维度名称和度量名称不支持的特殊字符，则直接去掉特殊字符，如果去掉特殊字符后出现重名情况，则自动添加后缀如 _1,_2 等避开
>  * 考虑到特殊字符的case 比例较少，提示暂时先不加了。之后交互上如果要优化再整体考虑吧
>  
> ----
> 度量名带“不符KE行为”的特殊字符（KE仅支持中文、英文、数字、空格、特殊字符（_ -()%?.）），
> 批量添加时，没有拦截的动作；
> 复现步骤：
> 1、hive建库、建表：
> CREATE TABLE {{{}table_tszf{}}}(
> {{~id}} int comment '左波浪线',
> {{i#d}} int comment '左井号',
> {{id@}} int comment '右艾特');
> 2、导入数据源
> 3、建模，批量添加度量



--
This message was sent by Atlassian Jira
(v8.20.10#820010)