Logic Functions

Release Notes

Releases Notes and Announcements

Overview

Strengths

Use Cases

Product Introduction

Billing Overview

Billing Mode

Refund

Configuration Adjustments

Purchase Guide

Preparations

Creating a Private Cluster

 Creating a SQL Job

Creating a JAR Job

Creating an ETL Job

Creating a Python Job

Getting Started

Job Overview

Job Types

Job Information

Job Operations

Managing Jobs

Developing Jobs in Batches

Advanced Job Parameters

Setting the Maximum Parallelism of a Job

Configuring Job Resources

Managing Versions

Developing Jobs

Viewing Monitoring Information

Configuring Monitoring Alarms (Numerical Metrics)

Configuring Event Alarms (Events)

Monitoring Metric List

Connecting to Prometheus

Viewing the Flink UI of a Job

Monitoring Jobs

Configuring Running Log Collection for a Job

Job Logs

Diagnosis with Logs

Viewing Critical Events

Events

Events and Diagnosis

Databases and Tables

Variables

Hive Catalogs

Managing Metadata

Managing Checkpoints

Automated Tuning

Tuning Jobs

Managing Dependencies

Viewing the Information of a Cluster

Scaling Out a Cluster

Terminating a Cluster

Scaling In a Cluster

Migrating a Cluster

Customizing DNS Service

Testing Network Connectivity

Managing Clusters

Configuring Basic Permissions

Space Role Permissions

Managing Permissions

Operation Guide

Glossary

Data Type

Glossary and Data Types

CREATE TABLE

CREATE VIEW

CREATE FUNCTION

DDL Statements

SELECT

INSERT

DML Statements

Merging MySQL CDC Sources

Kafka

Upsert Kafka

Tencent Cloud Message Queue

TDMQ for RabbitMQ

MySQL CDC

Pulsar

TDSQL for MySQL

Redis

MongoDB CDC

MongoDB

PostgreSQL CDC

HBase

Hive

ClickHouse

Data Lake Compute

Kudu

JDBC Connector for Tencent Cloud TCHouse-P

JDBC

FileSystem

Testing Connectors

Custom Connectors

Hudi

Iceberg 

SQLServer CDC

StarRocks

Connectors

Flink Configuration Items

SET Statement

Comparison with Flink Built-in Functions

Comparison Functions

Arithmetic Functions

Condition Functions

String Functions

Type Conversion Functions

Date and Time Functions

Aggregate Functions

Time Window Functions

Other Functions

Operators and Built-in Functions

Naming Rules

Reserved Words

Identifiers and Reserved Words

SQL Developer Guide

Python Developer Guide

MySQL Sources

MySQL Sinks

PostgreSQL Sinks

ClickHouse Sinks

Elasticsearch Sinks

ETL Developer Guide

Contact Us

Stream Compute Service

Logical functions are used to perform logical operations, and the result is a Boolean value.

Three logical statuses are available: TRUE, FALSE, and UNKNOWN (represented by NULL). Therefore, NOT TRUE is not necessarily FALSE; it can also be UNKNOWN.

Function	Description
boolean1 OR boolean2	Returns TRUE if `boolean1` or `boolean2` is TRUE.
boolean1 AND boolean2	Returns TRUE if `boolean1` and `boolean2` are both TRUE.
NOT boolean	Returns TRUE if `boolean` is FALSE; returns FALSE if `boolean` is TRUE; returns UNKNOWN if `boolean` is UNKNOWN.
boolean IS FALSE	Returns TRUE if `boolean` is FALSE; returns FALSE if `boolean` is UNKNOWN.
boolean IS NOT FALSE	Returns TRUE if `boolean` is not FALSE; returns TRUE if `boolean` is UNKNOWN.
boolean IS UNKNOWN	Returns TRUE if `boolean` is UNKNOWN; otherwise FALSE.
boolean IS NOT UNKNOWN	Returns TRUE if `boolean` is not UNKNOWN; otherwise FALSE.

tencent cloud