Help Center/ SecMaster/ User Guide/ Threat Operations/ Query and Analysis Syntax - V2/ SecMaster SQL Syntax Reference/ Supported Data Types
Updated on 2024-12-30 GMT+08:00
View PDF
Share

Supported Data Types

SecMaster supports the following SQL syntax types:

STRING, BOOLEAN, BYTES, DECIMAL, TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL, ARRAY, MULTISET, MAP, ROW

  • Precautions
    1. SecMaster SQL statements are compatible with the SQL syntax of Flink 1.7.2.
    1. Flink SQL uses a lexical policy for identifier (table, attribute, function names) similar to Java:
      • The case of identifiers is preserved no matter whether they are quoted.
      • Identifiers are matched case-sensitively.
      • Unlike Java, back-ticks allow identifiers to contain non-alphanumeric characters (for example, SELECT a AS `my field` FROM t).

      String text must be enclosed in single quotes (for example, SELECT'Hello World'). Duplicate a single quote for escaping (for example, SELECT'It''s me.'). Unicode characters are supported in string literals. If explicit Unicode points are required, use the following syntax:

      • Use the backslash (\) as an escaping character (default): SELECT U&'\263A'
      • Use a custom escaping character: SELECT U&'#263A' UESCAPE '#'
    1. There are some restrictions when the regular expression function (REGEXP) is used:

      Regular expressions are time-consuming and require 100 times performance overhead as that for addition, subtraction, multiplication, and division. Beyond that, regular expressions may enter an infinite loop in some extreme cases, causing job blocking. So LIKE is recommended. Typical regular expression functions you may use include:

      REGEXP

      REGEXP_REPLACE