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

Connect to a CelerData cluster

You can connect your CelerData cluster via MySQL Client or JDBC URL.

Prerequisites

A client with MySQL 5.5 or higher installed is needed for MySQL client connections.
A database user identity for the cluster is needed for the cluster connection. Ask your cluster administrator to create a cluster user for you if you do not already have one.
Make sure your cluster is accessible by clients or applications.

NOTE
A default database user admin with the ADMIN privilege is created after a CelerData cluster is created. You can connect to a new cluster by using the username admin and the corresponding password assigned to the user admin during the cluster creation.

Procedure

Sign in to the CelerData Cloud BYOC console.
On the Clusters page, click the cluster that you want to connect to.
On the cluster details page, click Help me connect in the Connection properties section.
On the page that appears, choose the appropriate Network method and connection option.
- If you connect to the cluster from your MySQL client, choose MySQL Client in Select connection option to check the Client command, and click the copy button to copy the command.
- If you connect to the cluster from your application via JDBC, choose JDBC in Select connection option to check the JDBC URL, and click the copy button to copy the URL.
Connect to the cluster from your MySQL client or from your application via JDBC URL.
- If you connect the cluster from your MySQL client, make sure to replace the <cluster username> and <cluster password> with the username and password of your database user identity when you paste and run the command.
- If you connect the cluster from your application via JDBC, make sure to replace the <cluster username> and <cluster password> with the username and password of your database user identity when you enclose the JDBC URL in your application. You can use the MySQL JDBC driver in your application.

In this article

Connect to a CelerData cluster
- Prerequisites
- Procedure