Calculated Field function

In order to better support customers' needs for expressions, Yonghong has enhanced and optimized expression functions and ease of use. You need to set use.yonghong.script = true in v8.8，9.0 to enable the following function enhancements. The 9.0.1 version is enabled by default.

1. Two expressions are unified into a "Calculated Field"

Prior to version 8.8, Yonghong products had two expression entries: "New Expression" and "Aggregate Measure Expression". In the 8.8 version, these two types of expressions were merged and unified into a "Create Calculated Field". Users no longer need to distinguish between detail and aggregation expressions, they only need to create corresponding field columns according to the needs of the scenario, which optimizes the user's self-built Calculated Field experience.

2. Support granularity of new Calculated Field

Functions are divided into the following categories: DateTime, Text, Math,Type conversion, Logic, Aggregation,Detail Expression. The function description has been optimized for ease of use to help users quickly find and understand the correct usage of functions. Currently supported databases are Oracle, SybaseIQ in v8.8.The databases supported by version 9.0.1 are ORACLE, SybaseIQ, MYSQL, GBASE8A, DERBY, DB2， HIVE, SPARK, HANA, HBASE, GAUSSDB100, GAUSSDB200, POSTGRESQL, GREENPLUM, PRESTO, KYLIN, IMPALA, MAX COMPUTE, ANALYTICDB, SQLSERVER.