Read(939) Label: function, basic operations,

  esProc offers a series of operators and related functions to perform general computations.

Ø  ${ }


Ø  %,\

Get and discard the remainder

Ø  &

Generate a new sequence by merging members of two sequences (or two single values) in a certain order; common members appear only once

Ø  &&,||,!

Logical operations

Ø  (x1,x2,,xk)

Compute a series of expressions in sequence, and return the result of the last expression; each expression is allowed to reference the variable value computed by the previous expression for value assignment

Ø  *

Generate a new sequence by duplicating members of a sequence

Ø  ++,--,**,//,%%,\\

Generate a new sequence by performing Arithmetic Operations, Mod operation or integer division between members in the same position in two sequences which are of the same length, such as alignment addition, alignment subtraction, alignment multiplication, and so on.

Ø  +,-,*,/

Signs of the four arithmetic operations

Ø  -a

Opposite number

Ø  ==,!=,<,>,<=,>=

Comparison operations

Ø  A.eq()

Judge if a given sequence can be generated by adjusting positions of the members of another sequence

Ø  \

Generate a new sequence by removing members (or the single value) of sequence B from sequence A

Ø  ^

Return a new sequence composed of common members of two sequences

Ø  a=x

Assign the result of an expression to a variable and return this result

Ø  a?=x

Compound assignment

Ø  k1+k2

Concatenate serial bytes

Ø  between()

Check if Parameter 1 is between Parameter 2 and Parameter 3

Ø  case()

Return the corresponding value of the expression that satisfies the specified conditionwhose value is equal to the result of a specific expression

Ø  cmp()

Compare the values of two expressions or two sequences

Ø  eval()

Dynamically parse and compute the expression

Ø  f@o(…)

The function syntax that a function is computed with different options

Ø  if()

Return different values according to different results of a boolean expression

Ø  ntile()

Get the bucket number of the subset where a certain member of the set settles

Ø  s1+s2

Concatenate two or more strings end-to-end

Ø  s1/s2

Concatenate a string with one or more pieces of non-string data

Ø  z()

Locate a member of set that is split into multiple subsets

Ø  |

Concatenate members (or single values) of two sequences so as to generate a new sequence

Ø  {Fi:…,…}

JSON-style record constant

Ø  [{Fi:…,…},…]

JSON-style table sequence constant