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

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