Services

API

Инструкции на Русском

All
  • All
  • AC
  • AOM
  • AOS
  • APIG
  • APISIGN
  • APM
  • AS
  • BMS
  • CBH
  • CBR
  • CCE
  • CCM
  • CES
  • CGS
  • CLOUDCLI
  • CPTS
  • CSS
  • CTS
  • DAS
  • DAYU
  • DBSS
  • DC
  • DCS
  • DDM
  • DDS
  • DLI
  • DNS
  • DRS
  • DWS
  • ECS
  • EIP
  • ELB
  • EM
  • EVS
  • FUNCTIONGRAPH
  • GES
  • HRM
  • HSS
  • IAAS
  • IAM
  • IMS
  • KAFKA
  • KMS
  • LTS
  • MRS
  • NAT
  • OBS
  • RABBITMQ
  • RDS
  • SERVICESTAGE
  • SFS
  • SMN
  • SMS
  • SWR
  • TMS
  • VPC
  • VPCEP
  • VPN
  • WAF
  1. Help Center
  2. Data Lake Insight
  3. SQL Syntax Reference
  4. Spark SQL Syntax Reference
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Common Configuration Items of Batch SQL Jobs
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a DLI Table
  5. Creating a DLI Table Using the DataSource Syntax
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing All Tables
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Modifying a Table
  5. Adding a Column
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Filtering
  5. WHERE Filtering Clause
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Adding Partition Data (Only OBS Tables Supported)
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Sorting
  5. ORDER BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  5. Column-Based GROUP BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. INNER JOIN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Subquery
  5. Subquery Nested by WHERE
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Alias
  5. AS for Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Set Operations
  5. UNION
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. CASE...WHEN
  5. Basic CASE Statement
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. SQL Syntax Constraints and Definitions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. CloudTable HBase Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. CloudTable HBase Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Dimension Table
  5. Creating a Redis Table
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Custom Stream Ecosystem
  5. Custom Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Mathematical Operation Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. StreamingML
  5. Anomaly Detection
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. aggregate_func
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an HBase Table
  5. Creating a DLI Table and Associating It with HBase
  1. Help Center
  2. Data Lake Insight
  3. Operators
  4. Relational Operators
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Databases
  5. Creating a Database
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an OpenTSDB Table
  5. Creating a DLI Table and Associating It with OpenTSDB
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DWS table
  5. Creating a DLI Table and Associating It with DWS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an RDS Table
  5. Creating a DLI Table and Associating It with RDS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a CSS Table
  5. Creating a DLI Table and Associating It with CSS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DCS Table
  5. Creating a DLI Table and Associating It with DCS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DDS Table
  5. Creating a DLI Table and Associating It with DDS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Views
  5. Creating a View
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Data Permissions List
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Types
  5. Overview
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. User-Defined Functions
  5. Creating a Function
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating an OBS Table
  5. Creating an OBS Table Using the DataSource Syntax
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. Overview
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. SQL Syntax Overview of Batch Jobs
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a DLI Table
  5. Creating a DLI Table Using the Hive Syntax
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. ascii
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing Table Creation Statements
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. abs
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. avg
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. cume_dist
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. decode1
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Filtering
  5. HAVING Filtering Clause
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Renaming a Partition (Only OBS Tables Supported)
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Sorting
  5. SORT BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  5. Expression-Based GROUP BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. LEFT OUTER JOIN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Subquery
  5. Subquery Nested by FROM
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Alias
  5. AS for Column
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Set Operations
  5. INTERSECT
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. CASE...WHEN
  5. CASE Query Statement
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. SQL Syntax Overview of Stream Jobs
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. DIS Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. CloudTable OpenTSDB Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Dimension Table
  5. Creating an RDS Table
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Custom Stream Ecosystem
  5. Custom Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. String Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. StreamingML
  5. Time Series Forecasting
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. alias
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an HBase Table
  5. Inserting Data to an HBase Table
  1. Help Center
  2. Data Lake Insight
  3. Operators
  4. Arithmetic Operators
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Databases
  5. Deleting a Database
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an OpenTSDB Table
  5. Inserting Data to the OpenTSDB Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DWS table
  5. Inserting Data to the DWS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an RDS Table
  5. Inserting Data to the RDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a CSS Table
  5. Inserting Data to the CSS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DCS Table
  5. Inserting Data to a DCS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DDS Table
  5. Inserting Data to the DDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Views
  5. Deleting a View
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Creating a Role
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Types
  5. Primitive Data Types
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. User-Defined Functions
  5. Deleting a Function
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating an OBS Table
  5. Creating an OBS Table Using the Hive Syntax
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. add_months
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Databases
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. concat
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing Table Properties
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. acos
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. corr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. first_value
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. javahash
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Deleting a Partition
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Sorting
  5. CLUSTER BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  5. GROUP BY Using HAVING
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. RIGHT OUTER JOIN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Subquery
  5. Subquery Nested by HAVING
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Set Operations
  5. EXCEPT
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. DMS Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. MRS OpenTSDB Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Temporal Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. StreamingML
  5. Real-Time Clustering
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. attr_expr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an HBase Table
  5. Querying an HBase Table
  1. Help Center
  2. Data Lake Insight
  3. Operators
  4. Logical Operators
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Databases
  5. Viewing a Specified Database
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an OpenTSDB Table
  5. Querying an OpenTSDB Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DWS table
  5. Querying the DWS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an RDS Table
  5. Querying the RDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a CSS Table
  5. Querying the CSS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DCS Table
  5. Querying the DCS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DDS Table
  5. Querying the DDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Deleting a Role
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Types
  5. Complex Data Types
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. User-Defined Functions
  5. Displaying Function Details
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. current_date
  1. Help Center
  2. Data Lake Insight
  3. Operators
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating an OBS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. concat_ws
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing All Columns in a Specified Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. asin
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. count
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. last_value
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. max_pt
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Deleting Partitions by Specifying Filter Criteria (Only OBS Tables Supported)
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Sorting
  5. DISTRIBUTE BY
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  5. ROLLUP
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. FULL OUTER JOIN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Subquery
  5. Multi-Layer Nested Subquery
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. MRS Kafka Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. CSS Elasticsearch Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Type Conversion Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. StreamingML
  5. Deep Learning Model Prediction
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. attr_expr_list
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Databases
  5. Viewing All Databases
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Binding a Role
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. User-Defined Functions
  5. Displaying All Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. current_timestamp
  1. Help Center
  2. Data Lake Insight
  3. Change History
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a DLI Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. char_matchcount
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing All Partitions in a Specified Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. atan
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. covar_pop
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. lag
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. ordinal
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Altering the Partition Location of a Table (Only OBS Tables Supported)
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  5. GROUPING SETS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. IMPLICIT JOIN
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Temporary Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. Open-Source Kafka Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DCS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Aggregate Functions
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. attrs_value_set_expr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Unbinding a Role
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. date_add
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Deleting a Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. encode
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  5. Viewing Table Statistics
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. bin
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. covar_samp
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. lead
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. trans_array
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Updating Partitioned Table Data (Only OBS Tables Supported)
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. Cartesian JOIN
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Dimension Table
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Source Stream
  5. OBS Source Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DDS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Table-Valued Functions
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. boolean_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Displaying a Role
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. dateadd
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing Tables
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. find_in_set
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. bround
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. max
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. percent_rank
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. trunc_numeric
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  5. Updating Table Metadata with REFRESH TABLE
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. LEFT SEMI JOIN
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Custom Stream Ecosystem
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DIS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  5. Other Functions
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. col
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Granting a Permission
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. date_sub
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Modifying a Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. get_json_object
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. cbrt
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. min
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. rank
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. url_decode
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  5. NON-EQUIJOIN
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Data Type
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DMS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. col_comment
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Revoking a Permission
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. date_format
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Syntax for Partitioning a Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. instr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. ceil
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. percentile
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Window Functions
  6. row_number
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Other Functions
  6. url_encode
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Built-In Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DWS Sink Stream (JDBC Mode)
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. col_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Showing Granted Permissions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. datediff
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Importing Data to the Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. instr1
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. conv
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. percentile_approx

percentile_approx

This function is used to approximate the pth percentile (including floating-point numbers) of a numeric column within a group.

Syntax

percentile_approx(DOUBLE col, p [, B])

Parameters

Table 1 Parameters

Parameter

Mandatory

Description

col

Yes

Columns with a data type of numeric. If the values are of any other type, NULL is returned.

p

Yes

The value should be between 0 and 1. Otherwise, NULL is returned.

B

Yes

The parameter B controls the accuracy of the approximation, with a higher value of B resulting in a higher level of approximation. The default value is 10000. If the number of non-repeating values in the column is less than B, an exact percentile is returned.

Return Values

The return value is of the DOUBLE type.

Example Code

  • Calculates the 0.5 percentile of all offering inventories (items), with an accuracy of 100. An example command is as follows:
    select stddev_samp(items,0.5, 100) from warehouse;

    The command output is as follows:

    _c0        
    500        
  • When used with group by, it groups all offerings by warehouse (warehourseId) and returns the 0.5 percentile of the offering inventory (items) in the same group, with an accuracy of 100. An example command is as follows:
    select warehourseId, stddev_samp(items, 0.5, 100) from warehourse group by warehourseId; 

    The command output is as follows:

    warehouseId _c1        
    city1     499        
    city2     354        
    city3     565        
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. User-Defined Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. DWS Sink Stream (OBS-based Dumping)
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. col_name_list
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  5. Displaying the Binding Relationship Between All Roles and Users
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. datediff1
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Inserting Data
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. initcap
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. cos
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. stddev_pop
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Geographical Functions
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. MRS HBase Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. condition
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. datepart
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Clearing Data
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. keyvalue
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. cot
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. stddev_samp
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. SELECT
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. MRS Kafka Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. condition_list
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. datetrunc
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Exporting Search Results
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. length
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. degress
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. sum
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Condition Expression
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. Open-Source Kafka Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. cte_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. day/dayofmonth
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an HBase Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. lengthb
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. e
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. variance/var_pop
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Window
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. File System Sink Stream (Recommended)
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. data_type
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. from_unixtime
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an OpenTSDB Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. levenshtein
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. exp
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Aggregate Functions
  6. war_samp
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. JOIN Between Stream Data and Table Data
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. OBS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. db_comment
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. from_utc_timestamp
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DWS table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. locate
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. factorial
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Configuring Time Models
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. RDS Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. db_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. getdate
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with an RDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. lower/lcase
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. floor
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Pattern Matching
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Creating a Sink Stream
  5. SMN Sink Stream
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. else_result_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. hour
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a CSS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. lpad
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. greatest
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. StreamingML
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. file_format
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. isdate
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DCS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. ltrim
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. hex
  1. Help Center
  2. Data Lake Insight
  3. Flink SQL Syntax
  4. Reserved Keywords
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. file_path
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. last_day
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Creating a Datasource Connection with a DDS Table
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. parse_url
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. least
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. function_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. lastday
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Views
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. printf
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. ln
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. groupby_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. minute
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Viewing the Execution Plan
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_count
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. log
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. having_condition
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. month
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Permissions Management
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_extract
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. log10
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. input_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. months_between
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Data Types
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. replace
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. log2
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. join_condition
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. next_day
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. User-Defined Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_replace
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. median
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. non_equi_join_condition
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. quarter
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_replace1
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. negative
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. number
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. second
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Basic SELECT Statements
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_instr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. percentlie
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. partition_col_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. to_char
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Filtering
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. regexp_substr
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. percentlie_approx
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. partition_col_value
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. to_date
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Sorting
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. repeat
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. pi
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. partition_specs
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. to_date1
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Grouping
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. reverse
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. pmod
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. property_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. to_utc_timestamp
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. JOIN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. rpad
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. positive
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. property_value
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. trunc
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Subquery
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. rtrim
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. pow
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. regex_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. unix_timestamp
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Alias
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. soundex
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. radians
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. result_expression
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. weekday
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Set Operations
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. space
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. rand
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. select_statement
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. weekofyear
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. WITH...AS
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. substr/substring
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. round
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. separator
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Date Functions
  6. year
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. CASE...WHEN
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. substring_index
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. shiftleft
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. sql_containing_cte_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. OVER Clause
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. split_part
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. shiftright
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. sub_query
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. translate
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. shiftrightunsigned
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. table_comment
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. trim
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. sign
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. table_name
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. String Functions
  6. upper/ucase
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. sin
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. table_properties
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. sqrt
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. table_reference
  1. Help Center
  2. Data Lake Insight
  3. Spark SQL Syntax Reference
  4. Built-in Functions
  5. Mathematical Functions
  6. tan
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. when_expression
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. where_condition
  1. Help Center
  2. Data Lake Insight
  3. Identifiers
  4. window_function