Docs

ByteHouse Enterprise Edition

Document

What's new

Release Notes

Console release notes

Engine release notes

Product announcement

ByteHouse Enterprise Edition cluster specification adjustment announcement

Billing

Billing method

Pricing Rules

Change Specification Billing Description

Tag-based cost allocation

Quick start

User guide

Cluster Management

Create a cluster

Modify cluster

Cluster configuration change

Add extra bandwidth

cluster configuration

Modify configuration parameters

Resource group management

Resource Group Overview

Create New Resource Group

Manage Resource Groups

Data Backup

Connect cluster

Get cluster connection information

Use CLI tools

Use ecosystem tools

Use a driver

ClickHouse JDBC Driver

MySQL SQLAlchemy Conncetor

Data Manage

New database/table

Create databases or tables based on DDL templates

Edit table

Manage UDF

Manage abnormal table status

Table Advanced Settings

Skip index

Table Creation Mode

Hot and cold tiered storage

Unique key table cold storage deduplication

TTL

New materialized view

Sync materialized views

Materialized view best practices

Data import/export

Introduction

Batch import

Import from small files

Data search

SQL history

Operation and maintenance monitoring

View task status

Cluster health

Data redistribution

Advanced Diagnosis Mode

Alarm

Use SDK to search ByteHouse monitor data

Access control

Access control model

Role Management

IAM sub-user management

Intelligent Assistant

Intelligent assistant

SRE Agent

Basic concepts

Development references

SQL reference

Compatibility Note

Data type

Integer types: UInt8, UInt16, UInt32, UInt64, UInt128, UInt256, Int8, Int16, Int32, Int64, Int128, Int256

Floating-point numbers: Float32, Float64

Fixed-point types: Decimal(P,S), Decimal32(S), Decimal64(S), Decimal128(S)

Date

DateTime Options Type DateTime64

String type: String, FixedString

Geospatial (Geo) Data Type

Array(T)

UUID

Can be null: Nullable

Tuple Type

bool

Input/Output Formats

SQL syntax

DDL

Create statements (CREATE)

Alter statements (ALTER)

Rename statement (RENAME)

Drop statement

SHOW statement (SHOW)

The DESCRIBE statement (DESCRIBE)

The ATTACH statement (ATTACH)

Detach statement (DETACH)

Use statement (USE)

The EXISTS statement (EXISTS)

DML

Insert statement (INSERT)

Update statement (UPDATE)

Delete statements (DELETE)

DQL

SELECT statements (SELECT)

Function

Recommend functions

Bit & Bitmap Functions

Comparison function

Condition function

Time and Date Functions

Map function (self-developed)

Hash function

Higher-order function

IP & URL Function

JSON Functions

Logical function

Machine learning function

Mathematical functions

Random function

Integer Function

Character function

Type conversion function

Aggregate function

initializeAggregation

simplelinearregression

stochasticlinearregression

stochasticlogisticregression

Table function

Operator

Behavior analysis-specific function

Overview

Retention Analysis Function

Funnel analysis function

Path analysis function

table engine

MergeTree

appearance

Iceberg External Table

Advanced features

GIS Spatiotemporal Analysis

Vector Search

Pass SQL use vector <Search

Activate Vector Search Service

Use vector search via the Python API

Full-text search

Activate Service

Instructions

API Reference

Role Management

ShowPrivilegesForRole - Get Role privileges

Update Grants For Role - Update Role privilege

Delete Role - Delete role

ListGrantUsersForRole - Get the user list associated with the role

AssignRole - Assign Roles

UnassignRole - Revoke Role

ListRoles - List of roles

Create Role - Create Gamerole

User Management

ShowRolesForUser - Get List of User Roles

UpdateGrantsForUser - Update User Authorize

GetUserDetail - Search User details

GetUserInitialPassword - Get User Initial Password

RevokePrivilegesForUserByID - Revoke user privileges by User ID

GrantPrivilegesToUserByID - Grant User privileges by User ID

ShowPrivilegesForUserByID - Get privilege by User ID

RevokePrivilegesFromUserByName - Revoke User Privileges by Username

GrantPrivilegesToUserByName - Grant user privileges by Username

Delete User - Delete user

UpdateUser - Update User

ShowPrivilegesForUserByName - Get privilege by username

ListUsers - User list

ResetUserPassword - Reset User Password

Manage clusters

ListClusters - Cluster List

Table management

CreateTable - Create Table

System tables

projection_parts_columns

Best practices

Distributed Table Practice Guide

Optimizer

Best Practice: Avoid Read-Write Inconsistencies

Best Practice: Kafka Deduplication Import into ByteHouse

ByteHouse High-Performance Vector Retrieval Technology Guide

Best practice: Workarounds for table state exceptions

Best Practice: ByteHouse Column Default Values

Select the use of columns with low cardinality as partition keys

Performance Analysis: Memory Usage

Disk Space Analysis in Performance Diagnosis

Performance Diagnosis: Query Log Analysis

Vector search best practices

ByteHouse + MCP + LLM build data analysis agent

Best practices for high-concurrency point query optimization in ByteHouse

ByteHouse capacity planning

FAQs

Product overview

Architecture overview

Documentation

ByteHouse Enterprise Edition

Development references

SQL reference

Function

Recommend functions

IN Operator function

Copy page

Download PDF

Recommend functions

IN Operator function

Copy page

Download PDF

IN Operator function

in,notIn,globalIn,globalNotIn

See the IN Operator Part.

Last updated: 2026.03.31 11:49:59

Public security network record in Beijing: No. 11010802032137

ByteHouse Enterprise Edition

in,notIn,globalIn,globalNotIn #

in,notIn,globalIn,globalNotIn