diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-09-12 08:28:54 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-09-12 08:28:54 +0000 |
| commit | 7db33518a4264e422294a1e20fbd1c1505d9a62d (patch) | |
| tree | aeb9ae54563b1f8f9c26fd54d0c207b082b89cd4 /sqlglot/dialects/teradata.py | |
| parent | Releasing debian version 18.2.0-1. (diff) | |
| download | sqlglot-7db33518a4264e422294a1e20fbd1c1505d9a62d.tar.xz sqlglot-7db33518a4264e422294a1e20fbd1c1505d9a62d.zip | |
Merging upstream version 18.3.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/teradata.py')
| -rw-r--r-- | sqlglot/dialects/teradata.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sqlglot/dialects/teradata.py b/sqlglot/dialects/teradata.py index 163cc13..d9de968 100644 --- a/sqlglot/dialects/teradata.py +++ b/sqlglot/dialects/teradata.py @@ -45,6 +45,7 @@ class Teradata(Dialect): "MOD": TokenType.MOD, "NE": TokenType.NEQ, "NOT=": TokenType.NEQ, + "SAMPLE": TokenType.TABLE_SAMPLE, "SEL": TokenType.SELECT, "ST_GEOMETRY": TokenType.GEOMETRY, "TOP": TokenType.TOP, @@ -55,6 +56,8 @@ class Teradata(Dialect): SINGLE_TOKENS.pop("%") class Parser(parser.Parser): + TABLESAMPLE_CSV = True + CHARSET_TRANSLATORS = { "GRAPHIC_TO_KANJISJIS", "GRAPHIC_TO_LATIN", @@ -171,6 +174,11 @@ class Teradata(Dialect): exp.Use: lambda self, e: f"DATABASE {self.sql(e, 'this')}", } + def tablesample_sql( + self, expression: exp.TableSample, seed_prefix: str = "SEED", sep=" AS " + ) -> str: + return f"{self.sql(expression, 'this')} SAMPLE {self.expressions(expression)}" + def partitionedbyproperty_sql(self, expression: exp.PartitionedByProperty) -> str: return f"PARTITION BY {self.sql(expression, 'this')}" |