[linkis-dist] Index optimization and dll script optimization

[binbinCheng]

Search before asking

• [X] I had searched in the issues and found no similar feature requirement.

Problem Description

The index name in the linkis_ddl.sql script is not standardized enough to follow the specification, and some scripts have grammatical errors that need to be fixed

1. Index naming convention

1.1 Ordinary index: inx_field name 1.2 Unique index: uni_ field name 1.3 Primary key index: pk_field name 1.4 Composite index: ain_ field name 1.5 The index name should not exceed 50 characters

2. Optimize the index name of linkis_ddl.sql according to the naming convention of the index

path:linkis-dist/package/db/linkis_ddl.sql

3. Incremental sql scripts need to be provided after index optimization

4. Fix the grammar problem of some scripts in the linkis_ddl.sql script

for example

---

linkis_ddl.sql脚本中索引名称不够规范需按规范来，并且有部分脚本存在语法错误需要修复

1.索引命名规范

1.1 普通索引：inx_字段名 1.2 唯一索引：uni_字段名 1.3 主键索引：pk_字段名 1.4 复合索引：ain_字段名 1.5 索引名尽量不超过50个字符

2.按照索引的命名规范对linkis_ddl.sql进行索引名称优化

path:linkis-dist/package/db/linkis_ddl.sql

3.索引优化完后需提供增量sql脚本

4.修复linkis_ddl.sql脚本中部分脚本的语法问题

比如

Description

No response

Use case

No response

Solutions

No response

Anything else

No response

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!

[github-actions[bot]]

:blush: Welcome to the Apache Linkis (incubating) community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context. We will be here shortly.

If you are interested in contributing to our website project, please let us know! You can check out our contributing guide on :point_right: How to Participate in Project Contribution.

Community

WeChat Assistant	WeChat Public Account

Mailing Lists

name	description	Subscribe	Unsubscribe	archive
[email protected]	community activity information	subscribe	unsubscribe	archive