Release Notes
Get Started
Clusters
Cloud Settings
- AWS
- Azure
Table Type
Query Data Lakes
- Catalog
- File external table
Integration
- Authenticate to AWS resources
- Authenticate to Azure cloud storage
- BI tools
- IDE tools
  - DataGrip
  - DBeaver
- Monitor with DataDog
Query Acceleration
- CBO
- Synchronous materialized view
- Asynchronous materialized view
- Colocate join
- Indexing
  - Bitmap indexing
  - Bloomfilter indexing
- Data Deduplication
  - Use Bitmap for exact count distinct
  - Use HLL for approximate count distinct
- Lateral join
Data Loading
- Concepts
  - Strict mode
- Batch load data from Amazon S3
- Batch load data from Azure cloud storage
- Load data from a local file system
- Load data from Confluent Cloud
  - Load data from Confluent Cloud through Routine Load
  - Load data from Confluent Cloud through Kafka connector
- Load data from Amazon MSK
- Load data from Amazon Kinesis
Data Unloading
- Unload data into AWS S3
Data Backup
- Back up and restore data with AWS S3
Security
- Console Access Control
- Data Access Control
- Application keys
- Service accounts
- Use SSL connection
Alarm
Usage and Billing
- Understand your usage
- Understand your billing
Organizations and Accounts
Reference
- Amazon Web Services (AWS)
- Microsoft Azure
- SQL Reference
- SQL Functions
  - Function list
  - Java UDFs
  - Window functions
  - Lambda expression
  - Date Functions
    - add_months
    - adddate
    - convert_tz
    - current_date
    - current_time
    - current_timestamp
    - date
    - date_add
    - date_diff
    - date_format
    - date_slice
    - date_sub, subdate
    - date_trunc
    - datediff
    - day
    - dayofweek_iso
    - dayname
    - dayofmonth
    - dayofweek
    - dayofyear
    - days_add
    - days_diff
    - days_sub
    - from_days
    - from_unixtime
    - hour
    - hours_add
    - hours_diff
    - hours_sub
    - jodatime_format
    - last_day
    - makedate
    - microseconds_add
    - microseconds_sub
    - minute
    - minutes_add
    - minutes_diff
    - minutes_sub
    - month
    - monthname
    - months_add
    - months_diff
    - months_sub
    - next_day
    - now
    - previous_day
    - quarter
    - second
    - seconds_add
    - seconds_diff
    - seconds_sub
    - str_to_date
    - str_to_jodatime
    - str2date
    - time_slice
    - time_to_sec
    - timediff
    - timestamp
    - timestampadd
    - timestampdiff
    - to_date
    - to_days
    - to_iso8601
    - to_tera_date
    - to_tera_timestamp
    - unix_timestamp
    - utc_timestamp
    - week
    - week_iso
    - weekofyear
    - weeks_add
    - weeks_diff
    - weeks_sub
    - year
    - years_add
    - years_diff
    - years_sub
  - Aggregate Functions
    - any_value
    - approx_count_distinct
    - array_agg
    - avg
    - bitmap
    - bitmap_agg
    - count
    - count_if
    - corr
    - covar_pop
    - covar_samp
    - group_concat
    - grouping
    - grouping_id
    - hll_empty
    - hll_hash
    - hll_raw_agg
    - hll_union
    - hll_union_agg
    - max
    - max_by
    - min
    - min_by
    - multi_distinct_sum
    - multi_distinct_count
    - percentile_approx
    - percentile_cont
    - percentile_disc
    - retention
    - stddev
    - stddev_samp
    - sum
    - variance, variance_pop, var_pop
    - var_samp
    - window_funnel
  - Geographic Functions
    - st_astext
    - st_circle
    - st_contains
    - st_distance_sphere
    - st_geometryfromtext
    - st_linefromtext
    - st_point
    - st_polygon
    - st_x
    - st_y
  - String Functions
    - append_trailing_char_if_absent
    - ascii
    - char
    - char_length
    - character_length
    - concat
    - concat_ws
    - ends_with
    - find_in_set
    - group_concat
    - hex
    - hex_decode_binary
    - hex_decode_string
    - instr
    - lcase
    - left
    - length
    - locate
    - lower
    - lpad
    - ltrim
    - money_format
    - null_or_empty
    - parse_url
    - repeat
    - replace
    - reverse
    - right
    - rpad
    - rtrim
    - space
    - split
    - split_part
    - substring_index
    - starts_with
    - strleft
    - strright
    - str_to_map
    - substring
    - trim
    - ucase
    - unhex
    - upper
    - url_decode
    - url_encode
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Bit Functions
    - bitand
    - bitnot
    - bitor
    - bitxor
    - bit_shift_left
    - bit_shift_right
    - bit_shift_right_logical
  - Bitmap Functions
    - bitmap_and
    - bitmap_or
    - bitmap_andnot
    - bitmap_xor
    - bitmap_contains
    - bitmap_empty
    - bitmap_has_any
    - bitmap_hash
    - bitmap_intersect
    - bitmap_max
    - bitmap_min
    - bitmap_union
    - bitmap_union_count
    - bitmap_remove
    - bitmap_to_array
    - bitmap_from_string
    - bitmap_to_string
    - to_bitmap
    - base64_to_bitmap
  - Array Functions
    - all_match
    - any_match
    - array_agg
    - array_append
    - array_avg
    - array_concat
    - array_contains
    - array_contains_all
    - array_cum_sum
    - array_difference
    - array_distinct
    - array_filter
    - array_generate
    - array_intersect
    - array_join
    - array_length
    - array_map
    - array_max
    - array_min
    - array_position
    - array_remove
    - array_slice
    - array_sort
    - array_sortby
    - array_sum
    - arrays_overlap
    - array_to_bitmap
    - cardinality
    - element_at
    - reverse
    - unnest
  - Map Functions
    - cardinality
    - distinct_map_keys
    - element_at
    - map_apply
    - map_concat
    - map_filter
    - map_from_arrays
    - map_keys
    - map_size
    - map_values
    - transform_keys
    - transform_values
  - Binary Functions
    - to_binary
    - from_binary
  - cast function
  - hash function
  - Cryptographic Functions
    - aes_encrypt
    - aes_decrypt
    - base64_decode_binary
    - base64_decode_string
    - from_base64
    - md5
    - md5sum
    - md5sum_numeric
    - sha2
    - sm3
    - to_base64
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cosine_similarity
    - cosine_similarity_norm
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sinh
    - sqrt
    - square
    - tan
    - tanh
    - truncate
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - Percentile Functions
    - percentile_approx_raw
    - percentile_empty
    - percentile_hash
    - percentile_union
  - Scalar Functions
    - hll_cardinality
  - Struct Functions
    - named_struct
    - row
  - Table Functions
    - files
    - generate_series
    - json_each
    - unnest
  - Utility Functions
    - catalog
    - current_role
    - current_version
    - database
    - host_name
    - isnull
    - isnotnull
    - last_query_id
    - sleep
    - uuid
    - uuid_numeric
    - version
- AUTO_INCREMENT
- Generated columns
- System variables
- System limits
- Information Schema
- System Metadatabase
API
- Overview
- Actions
  - Clusters
    - Create and Manage Clusters
    - Query Clusters
      - List clusters
      - Query status of a cluster
  - Identity and Access Management
    - Tokens
      - Create access token
    - Members and roles
  - Organization and Account
    - Get account list
  - Usage and Billing
Terraform Provider
- Introduction
- Deployment on AWS
- Deployment on Azure
Run scripts

SHOW BACKENDS

Description

This statement is used to view BE node om tje cluster syntax: Syntax:

SHOW BACKENDS;

Note:

LastStartTime indicates the latest BE start-up time.
LastHeartbeat indicates the latest heartbeat.
Alive indicates whether the node survives.
SystemDecommissioned being true means the node is safely offline.
ClusterDecommissioned being true means the node is rushing offline in the current cluster.
TabletNum represents the number of shardings in the node.
DataUsedCapacity represents the space occupied by the actual user data.
AvailCapacity means the available space in the disk.
TotalCapacity means the total space in the disk. TotalCapacity = AvailCapacity + DataUsedCapacity + other space occupied by non-userdata files
UsedPct represents the percentage of space used in the disk.
ErrMsg is used to display errors when a heartbeat fails.
Status is used to display BE status in JSON format. It currently displays when it is that BE reports its tablet last time.

In this article

SHOW BACKENDS
- Description