sqlglot.dialects.presto

18class Presto(Dialect):
19    INDEX_OFFSET = 1
20    NULL_ORDERING = "nulls_are_last"
21    TIME_FORMAT = MySQL.TIME_FORMAT
22    STRICT_STRING_CONCAT = True
23    TYPED_DIVISION = True
24    TABLESAMPLE_SIZE_IS_PERCENT = True
25    LOG_BASE_FIRST: bool | None = None
26    SUPPORTS_VALUES_DEFAULT = False
27    LEAST_GREATEST_IGNORES_NULLS = False
28    UUID_IS_STRING_TYPE = False
29
30    TIME_MAPPING = MySQL.TIME_MAPPING
31
32    # https://github.com/trinodb/trino/issues/17
33    # https://github.com/trinodb/trino/issues/12289
34    # https://github.com/prestodb/presto/issues/2863
35    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_INSENSITIVE
36
37    EXPRESSION_METADATA = EXPRESSION_METADATA.copy()
38
39    SUPPORTED_SETTINGS = {
40        *Dialect.SUPPORTED_SETTINGS,
41        "variant_extract_is_json_extract",
42    }
43
44    class Tokenizer(tokens.Tokenizer):
45        HEX_STRINGS = [("x'", "'"), ("X'", "'")]
46        UNICODE_STRINGS = [
47            (prefix + q, q)
48            for q in t.cast(list[str], tokens.Tokenizer.QUOTES)
49            for prefix in ("U&", "u&")
50        ]
51
52        NESTED_COMMENTS = False
53
54        KEYWORDS = {
55            **tokens.Tokenizer.KEYWORDS,
56            "DEALLOCATE PREPARE": TokenType.COMMAND,
57            "DESCRIBE INPUT": TokenType.COMMAND,
58            "DESCRIBE OUTPUT": TokenType.COMMAND,
59            "RESET SESSION": TokenType.COMMAND,
60            "START": TokenType.BEGIN,
61            "MATCH_RECOGNIZE": TokenType.MATCH_RECOGNIZE,
62            "ROW": TokenType.STRUCT,
63            "IPADDRESS": TokenType.IPADDRESS,
64            "IPPREFIX": TokenType.IPPREFIX,
65            "TDIGEST": TokenType.TDIGEST,
66            "HYPERLOGLOG": TokenType.HLLSKETCH,
67        }
68        KEYWORDS.pop("/*+")
69        KEYWORDS.pop("QUALIFY")
70
71    Parser = PrestoParser
72
73    Generator = PrestoGenerator

44    class Tokenizer(tokens.Tokenizer):
45        HEX_STRINGS = [("x'", "'"), ("X'", "'")]
46        UNICODE_STRINGS = [
47            (prefix + q, q)
48            for q in t.cast(list[str], tokens.Tokenizer.QUOTES)
49            for prefix in ("U&", "u&")
50        ]
51
52        NESTED_COMMENTS = False
53
54        KEYWORDS = {
55            **tokens.Tokenizer.KEYWORDS,
56            "DEALLOCATE PREPARE": TokenType.COMMAND,
57            "DESCRIBE INPUT": TokenType.COMMAND,
58            "DESCRIBE OUTPUT": TokenType.COMMAND,
59            "RESET SESSION": TokenType.COMMAND,
60            "START": TokenType.BEGIN,
61            "MATCH_RECOGNIZE": TokenType.MATCH_RECOGNIZE,
62            "ROW": TokenType.STRUCT,
63            "IPADDRESS": TokenType.IPADDRESS,
64            "IPPREFIX": TokenType.IPPREFIX,
65            "TDIGEST": TokenType.TDIGEST,
66            "HYPERLOGLOG": TokenType.HLLSKETCH,
67        }
68        KEYWORDS.pop("/*+")
69        KEYWORDS.pop("QUALIFY")