[ https://issues.apache.org/jira/browse/KYLIN-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752233#comment-17752233 ]
ASF GitHub Bot commented on KYLIN-5676: --------------------------------------- hit-lacus commented on code in PR #2144: URL: https://github.com/apache/kylin/pull/2144#discussion_r1287864339 ########## kystudio/src/components/studio/StudioModel/TableIndexEdit/locales.js: ########## @@ -22,14 +23,27 @@ export default { moveDown: 'Move down', tableIndexShardByTips: 'Please select columns for detail query. To enhance the query performance, please move the frequently used dimensions to the top of the list, and set a column with relatively large cardinality as ShardBy.', filterByColumns: 'Search by column name', - excludeTableCheckbox: 'Display columns excluded from recommendations', - excludeTableCheckboxTip: 'If an excluded column is added to indexes, this column will store "historical truth"(SCD Type2, As Was).<br/>If you want to use "latest status" (SCD Type 1, As Is) ,please don\'t add this column to any index and add foreign key instead.', - excludedTableIconTip: 'Excluded from recommendations', - manyToManyAntiTableTip: 'For the tables excluded from recommendations, if the join relationship of a table is One-to-Many or Many-to-Many, dimensions from this table can\'t be used in indexes. ', - indexTimeRange: 'Index’s Time Range', - indexTimeRangeTips: 'The data range that the indexes will be built in. With "Batch and Streaming" selected, there will be generated batch indexes and streaming indexes with same content respectively. ', + excludeTableCheckbox: 'Display columns excluded', + excludeTableCheckboxTip1: 'Exclude columns using the slow-changing dimension to record data changes:', + excludeTableCheckboxTip2: 'When you want the column to reflect historical facts (SCD Type2, As Was), please check this option and add it to the index.', + excludeTableCheckboxTip3: 'When you want the column to reflect the latest state of the dimension (SCD Type1, As Is), do not check this option. Instead, add a foreign key to the index.', + excludeTableCheckboxTip4: '<br/>Not familiar with the slow-changing dimension? <a class="ky-a-like" href="https://docs.kyligence.io/books/v4.6/en/Designers-Guide/model/model_design/slowly_changing_dimension.en.html?h=Slowly%20Changing%20Dimension" target="_blank">Check the manual</a>', + manyToManyAntiTableTip: 'The table columns excluded, if the join relationship of a table is One-to-Many or Many-to-Many, dimensions from this table can\'t be used in indexes. ', + indexTimeRange: 'Real-time Index Types', + indexTimeRangeTips: 'After selection, the table index will generate streaming indexes and batch indexes of the same content respectively.', noIndexRangeByHybrid: 'Select index’s data range to display available columns.', textRecognition: 'Text Recognition', - refuseAddIndexTip: 'Can\'t add streaming indexes. Please stop the streaming job and then delete all the streaming segments.' + refuseAddIndexTip: 'Can\'t add streaming indexes. Please stop the streaming job and then delete all the streaming segments.', + sugessionLabel1: 'Rec.1', + sugession1: 'Sort by common usage frequency. Reasonable ordering can significantly improve the efficiency of table queries.', + sugessionLabel2: 'Rec.2', + sugession2: 'Set one high-cardinality column as shardby. The shardby column is used to store data in slices, which can avoid uneven dispersion of table data, improve parallelism and query efficiency.', + tips: 'No cardinality information? Please sample first and try again. ', + goToDataSource: 'Go to sampling', + knowMore: 'For more information, please ', + userManual: 'view the manual', + shardbyManal: 'https://docs.kyligence.io/books/v4.6/en/Designers-Guide/model/model_design/table_index.en.html?q=shardBy', Review Comment: This url is not right. > If the query matches an index that is not built, the front-end prompts you > -------------------------------------------------------------------------- > > Key: KYLIN-5676 > URL: https://issues.apache.org/jira/browse/KYLIN-5676 > Project: Kylin > Issue Type: Bug > Reporter: Laura Xia > Assignee: Laura Xia > Priority: Major > Fix For: 5.0-beta > > -- This message was sent by Atlassian Jira (v8.20.10#820010)