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 REPOSITORIES

Description

This statement is used to view the currently created repositories.

Syntax:

SHOW REPOSITORIES;

Note：
1.The meanings of each column are as follows:：
RepoId：     unique repositories ID
RepoName：   repositories name
CreateTime： the time when the repository was first created
IsReadOnly： is it a read-only repository
Location：   the root directory in the repository used to back up data
Broker：     the dependent Broker
ErrMsg：     CelerData will regularly check the connectivity of the repository. If there is a problem, an error message will be displayed here

Examples

View created repositories：
```
SHOW REPOSITORIES;
```

In this article

SHOW REPOSITORIES
- Description
- Examples