sqlglot.dialects.redshift

12class Redshift(Postgres):
13    # https://docs.aws.amazon.com/redshift/latest/dg/r_names.html
14    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_INSENSITIVE
15
16    EXPRESSION_METADATA = EXPRESSION_METADATA.copy()
17    SUPPORTS_USER_DEFINED_TYPES = False
18    INDEX_OFFSET = 0
19    COPY_PARAMS_ARE_CSV = False
20    HEX_LOWERCASE = True
21    HAS_DISTINCT_ARRAY_CONSTRUCTORS = True
22    COALESCE_COMPARISON_NON_STANDARD = True
23    REGEXP_EXTRACT_POSITION_OVERFLOW_RETURNS_NULL = False
24    ARRAY_FUNCS_PROPAGATES_NULLS = True
25
26    # ref: https://docs.aws.amazon.com/redshift/latest/dg/r_FORMAT_strings.html
27    TIME_FORMAT = "'YYYY-MM-DD HH24:MI:SS'"
28    TIME_MAPPING = {**Postgres.TIME_MAPPING, "MON": "%b", "HH24": "%H", "HH": "%I"}
29
30    Parser = RedshiftParser
31
32    class Tokenizer(Postgres.Tokenizer):
33        BIT_STRINGS = []
34        HEX_STRINGS = []
35        STRING_ESCAPES = ["\\", "'"]
36
37        KEYWORDS = {
38            **Postgres.Tokenizer.KEYWORDS,
39            "(+)": TokenType.JOIN_MARKER,
40            "HLLSKETCH": TokenType.HLLSKETCH,
41            "MINUS": TokenType.EXCEPT,
42            "SUPER": TokenType.SUPER,
43            "TOP": TokenType.TOP,
44            "UNLOAD": TokenType.COMMAND,
45            "VARBYTE": TokenType.VARBINARY,
46            "BINARY VARYING": TokenType.VARBINARY,
47        }
48        KEYWORDS.pop("VALUES")
49
50        # Redshift allows # to appear as a table identifier prefix
51        SINGLE_TOKENS = Postgres.Tokenizer.SINGLE_TOKENS.copy()
52        SINGLE_TOKENS.pop("#")
53
54    Generator = RedshiftGenerator

32    class Tokenizer(Postgres.Tokenizer):
33        BIT_STRINGS = []
34        HEX_STRINGS = []
35        STRING_ESCAPES = ["\\", "'"]
36
37        KEYWORDS = {
38            **Postgres.Tokenizer.KEYWORDS,
39            "(+)": TokenType.JOIN_MARKER,
40            "HLLSKETCH": TokenType.HLLSKETCH,
41            "MINUS": TokenType.EXCEPT,
42            "SUPER": TokenType.SUPER,
43            "TOP": TokenType.TOP,
44            "UNLOAD": TokenType.COMMAND,
45            "VARBYTE": TokenType.VARBINARY,
46            "BINARY VARYING": TokenType.VARBINARY,
47        }
48        KEYWORDS.pop("VALUES")
49
50        # Redshift allows # to appear as a table identifier prefix
51        SINGLE_TOKENS = Postgres.Tokenizer.SINGLE_TOKENS.copy()
52        SINGLE_TOKENS.pop("#")