if function | Databricks on AWS

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

会开车的山楂 · Linux Error Number ...· 2 周前 ·

爱热闹的葫芦 · Column.IsIdentity ...· 2 周前 ·

兴奋的玉米 · Mapping Attributes✨ | ...· 2 周前 ·

快乐的板凳 · CREATE TABLE - Amazon ...· 2 周前 ·

纯真的炒饭 · Cannot read ...· 1 周前 ·

酷酷的匕首 · 经营学院｜教育教学｜龙谷大学You, ...· 5 月前 ·

迷茫的烈马 · 真题解析| ...· 6 月前 ·

闷骚的口罩 · 浙江省新昌中学· 1 年前 ·

老实的鸡蛋面 · 道中华| 榫卯，古人玩的技术梗-中国民族网· 1 年前 ·

读研的键盘 · 工作機械 | ブラザー· 1 年前 ·

Account and workspace administration

Security and compliance

Data governance (Unity Catalog)

Lakehouse architecture

Reference & resources

Reference

REST API reference
MLFlow API
Feature Store Python API
Apache Spark APIs
Delta Lake API
Delta Live Tables API
SQL language reference
- "Applies to" label
- How to read a syntax diagram
- How to add comments to SQL statements
- Configuration parameters
- Data types and literals
- Functions
  - Built-in functions
    - Alphabetical list of built-in functions
    - User-defined aggregate functions (UDAFs)
    - Integration with Hive UDFs, UDAFs, and UDTFs
    - External user-defined scalar functions (UDFs)
    - Function invocation
    - SQL data type rules
    - Datetime patterns
    - H3 geospatial functions
    - Lambda functions
    - Window functions
    - Identifiers
    - Names
    - IDENTIFIER clause
    - NULL semantics
    - Expressions
    - Parameter markers
    - Variables
    - Name resolution
    - JSON path expressions
    - Partitions
    - ANSI compliance in Databricks Runtime
    - Apache Hive compatibility
    - Principals
    - Privileges and securable objects in Unity Catalog
    - Privileges and securable objects in the Hive metastore
    - Refresh Unity Catalog metadata
    - External locations
    - External tables
    - Storage credentials
    - Volumes
    - Delta Sharing
    - Federated queries (Lakehouse Federation)
    - Information schema
    - Reserved words
    - ALTER CATALOG
    - ALTER CONNECTION
    - ALTER CREDENTIAL
    - ALTER DATABASE
    - ALTER LOCATION
    - ALTER PROVIDER
    - ALTER RECIPIENT
    - ALTER STREAMING TABLE
    - ADD CONSTRAINT clause
    - DROP CONSTRAINT clause
    - ALTER TABLE … COLUMN clause
    - ALTER TABLE … PARTITION
    - CLUSTER BY clause (TABLE)
    - Column mask clause
    - ROW FILTER clause
    - ALTER TABLE
    - ALTER SCHEMA
    - ALTER SHARE
    - ALTER VIEW
    - ALTER VOLUME
    - COMMENT ON
    - CREATE BLOOMFILTER INDEX
    - CREATE CATALOG
    - CREATE CONNECTION
    - CREATE DATABASE
    - CREATE FUNCTION (SQL)
    - CREATE FUNCTION (External)
    - CREATE LOCATION
    - CREATE MATERIALIZED VIEW
    - CREATE RECIPIENT
    - CREATE SCHEMA
    - CREATE SERVER
    - CREATE SHARE
    - CREATE STREAMING TABLE
    - CREATE TABLE [USING]
    - CREATE TABLE LIKE
    - CONSTRAINT clause
    - CREATE TABLE CLONE
    - Table properties and table options
    - CREATE TABLE with Hive format
    - CREATE TABLE
    - CREATE VIEW
    - CREATE VOLUME
    - DECLARE VARIABLE
    - DROP BLOOMFILTER INDEX
    - DROP CATALOG
    - DROP CONNECTION
    - DROP DATABASE
    - DROP CREDENTIAL
    - DROP FUNCTION
    - DROP LOCATION
    - DROP PROVIDER
    - DROP RECIPIENT
    - DROP SCHEMA
    - DROP SHARE
    - DROP TABLE
    - DROP VARIABLE
    - DROP VIEW
    - DROP VOLUME
    - MSCK REPAIR TABLE
    - REFRESH FOREIGN (CATALOG, SCHEMA, or TABLE)
    - REFRESH (MATERIALIZED VIEW or STREAMING TABLE)
    - TRUNCATE TABLE
    - UNDROP TABLE
    - COPY INTO
    - DELETE FROM
    - INSERT INTO
    - INSERT OVERWRITE DIRECTORY
    - INSERT OVERWRITE DIRECTORY with Hive format
    - LOAD DATA
    - MERGE INTO
    - UPDATE
    - Query
    - SELECT
    - VALUES
    - EXPLAIN
    - CACHE SELECT
    - CONVERT TO DELTA
    - DESCRIBE HISTORY
    - FSCK REPAIR TABLE
    - GENERATE
    - OPTIMIZE
    - REORG TABLE
    - RESTORE
    - VACUUM
    - ANALYZE TABLE
    - CACHE TABLE
    - CLEAR CACHE
    - REFRESH CACHE
    - REFRESH FUNCTION
    - REFRESH TABLE
    - UNCACHE TABLE
    - DESCRIBE CATALOG
    - DESCRIBE CONNECTION
    - DESCRIBE CREDENTIAL
    - DESCRIBE DATABASE
    - DESCRIBE FUNCTION
    - DESCRIBE LOCATION
    - DESCRIBE PROVIDER
    - DESCRIBE QUERY
    - DESCRIBE RECIPIENT
    - DESCRIBE SCHEMA
    - DESCRIBE SHARE
    - DESCRIBE TABLE
    - DESCRIBE VOLUME
    - SHOW ALL IN SHARE
    - SHOW CATALOGS
    - SHOW COLUMNS
    - SHOW CONNECTIONS
    - SHOW CREATE TABLE
    - SHOW CREDENTIALS
    - SHOW DATABASES
    - SHOW FUNCTIONS
    - SHOW GROUPS
    - SHOW LOCATIONS
    - SHOW PARTITIONS
    - SHOW PROVIDERS
    - SHOW RECIPIENTS
    - SHOW SCHEMAS
    - SHOW SHARES
    - SHOW SHARES IN PROVIDER
    - SHOW TABLE
    - SHOW TABLES
    - SHOW TABLES DROPPED
    - SHOW TBLPROPERTIES
    - SHOW USERS
    - SHOW VIEWS
    - SHOW VOLUMES
    - EXECUTE IMMEDIATE
    - RESET
    - SET TIMEZONE
    - SET VARIABLE
    - USE CATALOG
    - USE DATABASE
    - USE SCHEMA
    - ADD ARCHIVE
    - ADD FILE
    - ADD JAR
    - LIST ARCHIVE
    - LIST FILE
    - LIST JAR
    - ALTER GROUP
    - CREATE GROUP
    - DROP GROUP
    - GRANT
    - GRANT SHARE
    - REPAIR PRIVILEGES
    - REVOKE
    - REVOKE SHARE
    - SHOW GRANTS
    - SHOW GRANTS ON SHARE
    - SHOW GRANTS TO RECIPIENT
    - Error messages
    - Resources
    - What’s coming?
    - Documentation archive

`if` function

Syntax