From fb7e79eb4c8d6e22b7324de4bb1ea9cd11b8da7c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Fri, 7 Apr 2023 14:35:04 +0200 Subject: Merging upstream version 11.5.2. Signed-off-by: Daniel Baumann --- sqlglot/dialects/hive.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'sqlglot/dialects/hive.py') diff --git a/sqlglot/dialects/hive.py b/sqlglot/dialects/hive.py index 68137ae..c39656e 100644 --- a/sqlglot/dialects/hive.py +++ b/sqlglot/dialects/hive.py @@ -261,6 +261,7 @@ class Hive(Dialect): "SIZE": exp.ArraySize.from_arg_list, "SPLIT": exp.RegexpSplit.from_arg_list, "TO_DATE": format_time_lambda(exp.TsOrDsToDate, "hive"), + "TO_JSON": exp.JSONFormat.from_arg_list, "UNIX_TIMESTAMP": format_time_lambda(exp.StrToUnix, "hive", True), "YEAR": lambda args: exp.Year(this=exp.TsOrDsToDate.from_arg_list(args)), } @@ -281,6 +282,7 @@ class Hive(Dialect): exp.DataType.Type.DATETIME: "TIMESTAMP", exp.DataType.Type.VARBINARY: "BINARY", exp.DataType.Type.TIMESTAMPTZ: "TIMESTAMP", + exp.DataType.Type.BIT: "BOOLEAN", } TRANSFORMS = { @@ -305,6 +307,7 @@ class Hive(Dialect): exp.Join: _unnest_to_explode_sql, exp.JSONExtract: rename_func("GET_JSON_OBJECT"), exp.JSONExtractScalar: rename_func("GET_JSON_OBJECT"), + exp.JSONFormat: rename_func("TO_JSON"), exp.Map: var_map_sql, exp.Max: max_or_greatest, exp.Min: min_or_least, @@ -343,6 +346,7 @@ class Hive(Dialect): exp.SerdeProperties: lambda self, e: self.properties(e, prefix="WITH SERDEPROPERTIES"), exp.NumberToStr: rename_func("FORMAT_NUMBER"), exp.LastDateOfMonth: rename_func("LAST_DAY"), + exp.National: lambda self, e: self.sql(e, "this"), } PROPERTIES_LOCATION = { -- cgit v1.2.3