Scalar Functions and Operators

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Functions and operators compute one result for each set of input values. Use scalar functions and operators to transform values, compare data, perform calculations, and control how expressions are evaluated.

AI Functions

Use generative AI models to classify text, analyze sentiment, and generate text.

• AI Functions - Classify text, determine sentiment, or generate text from a prompt.

Collection and Structured Data Functions

Create, inspect, and transform arrays and JSON values.

• Array Functions - Access, search, build, transform, and compare arrays and vectors.
• JSON Functions - Construct JSON values from SQL values, arrays, and key-value pairs.

String Functions

Format, transform, search, and compare text values.

• String Functions and Operators - Concatenate, measure, extract, trim, encode, hash, and transform strings.
• String Pattern Matching - Match strings with LIKE, regular expressions, and related functions.

Formatting and Type Conversion

Convert values between data types or format values for display.

• Data Type Formatting Functions - Convert numbers, dates, timestamps, and other values to or from formatted strings.
• Type Conversions - Convert an expression from one data type to another.

Comparison and Logical Operations

Compare values and combine or negate conditions.

• Comparison Operators - Compare values for equality, ordering, ranges, nullness, and distinctness.
• Subquery Comparisons - Compare scalar values with rows returned by a subquery.
• Logical Operators - Combine or negate Boolean expressions with AND, OR, and NOT.

Conditional Expressions

Choose a result based on conditions or available values.

• Conditional Expressions - Select among values with CASE, COALESCE, NULLIF, GREATEST, and LEAST.

Mathematical Functions

Perform numeric calculations.

• Mathematical Functions and Operators - Perform arithmetic, rounding, logarithmic, trigonometric, bitwise, and other numeric operations.

Date and Time Functions

Create, inspect, compare, and modify temporal values.

• Date/Time Functions and Operators - Calculate with dates, times, timestamps, and intervals; extract fields; and truncate temporal values.