| # Licensed to the Apache Software Foundation (ASF) under one |
| # or more contributor license agreements. See the NOTICE file |
| # distributed with this work for additional information |
| # regarding copyright ownership. The ASF licenses this file |
| # to you under the Apache License, Version 2.0 (the |
| # "License"); you may not use this file except in compliance |
| # with the License. You may obtain a copy of the License at |
| # |
| # http://www.apache.org/licenses/LICENSE-2.0 |
| # |
| # Unless required by applicable law or agreed to in writing, |
| # software distributed under the License is distributed on an |
| # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| # KIND, either express or implied. See the License for the |
| # specific language governing permissions and limitations |
| # under the License. |
| from __future__ import annotations |
| |
| from superset.constants import TimeGrain |
| from superset.db_engine_specs.hive import HiveEngineSpec |
| |
| time_grain_expressions: dict[str | None, str] = { |
| None: "{col}", |
| TimeGrain.SECOND: "date_trunc('second', {col})", |
| TimeGrain.MINUTE: "date_trunc('minute', {col})", |
| TimeGrain.HOUR: "date_trunc('hour', {col})", |
| TimeGrain.DAY: "date_trunc('day', {col})", |
| TimeGrain.WEEK: "date_trunc('week', {col})", |
| TimeGrain.MONTH: "date_trunc('month', {col})", |
| TimeGrain.QUARTER: "date_trunc('quarter', {col})", |
| TimeGrain.YEAR: "date_trunc('year', {col})", |
| TimeGrain.WEEK_ENDING_SATURDAY: ( |
| "date_trunc('week', {col} + interval '1 day') + interval '5 days'" |
| ), |
| TimeGrain.WEEK_STARTING_SUNDAY: ( |
| "date_trunc('week', {col} + interval '1 day') - interval '1 day'" |
| ), |
| } |
| |
| |
| class SparkEngineSpec(HiveEngineSpec): |
| _time_grain_expressions = time_grain_expressions |
| engine_name = "Apache Spark SQL" |