Mathematical Statistical Function

Cloud Log Service

Release Notes and Announcements

Release Notes

Announcements

Upgrading Existing LogListener Instances

Product Introduction

Limits

Log Collection

Shipping and Consumption

Concepts

Purchase Guide

Pay-as-You-Go

Pay-As-You-Go Examples

Billing

Cleaning up CLS resources

Cost Optimization

FAQs

Getting Started

Getting Started Guide

Quickly Trying out CLS with Demo

Operation Guide

Resource Management

Logset

Log Topic

Metric topic

Topic Usage Monitoring

Machine Group Management

Permission Management

Sub-Account Authorization

Authorizable Resource Types

Access Policy Templates

Log Collection

Collection Overview

Collection by LogListener

LogListener Use Process

LogListener Installation and Deployment

LogListener Installation Guide(Linux)

Batch Deploying LogListener in CVM and Lighthouse

Installing LogListener in Self-built Kubernetes Cluster

LogListener Upgrade Guide

LogListener Service Logs

Importing LogListener Collection Configuration

LogListener Updates

Collecting Text Log

Full Text in a Single Line

Full Text in Multi Lines

Full Regular Expression (Single-Line)

Full Regular Expression (Multi-Line)

JSON Format

Separator Format

Combined Parsing Format

Configuring the Time Format

Collecting Logs in Self-Built Kubernetes Cluster

Configuring Log Collection in Self-Built Kubernetes Cluster in the Console

Configuring Log Collection in Self-Built Kubernetes Cluster via CRD

Collecting Syslog

Uploading Log over Kafka

Uploading Logs via Anonymous Write

Uploading Logs via Logback Appender

Uploading Logs via Log4j Appender

Uploading Log via SDK

Uploading Log via API

Importing Data

Importing COS Data

Tencent Cloud Service Log Access

Metric Collection

Metrics Reporting

Log Storage

Storage Class Overview

Data Encryption

Metric Storage

Metric Storage Overview

Compatible with Prometheus API

Metric Pre-aggregation

Search and Analysis (Log Topic)

Search and Analysis (Metric Topic)

Syntax Rules

Dashboard

Data Processing documents

Shipping and Consumption

Shipping Overview

CLS Service Role Authorization

Shipping to COS

JSON Shipping

Raw Log Shipping

Shipping Task Management

Shipping to CKafka

Creating Shipping Task

Shipping to ES

Dumping to ES Through SCF

Log Shipping

Consumption over Kafka

Customized Consumption

Metric Topic Shipping

Monitoring Alarm

Monitoring Alarm Overview

Managing Alarm Policies

Configuring Alarm Policies

Trigger Condition Expression

Channels to Receive Alarm Notifications

Receiving Alarm Notifications via SMS and Phone

Custom Callback APIs

Managing Notification Groups

Alarm Notification Variable

Viewing Alarm Records

Alarm Silence

Historical Documentation

Operation guide of earlier LogListener versions

Troubleshooting earlier LogListener versions

Practical Tutorial

Log Collection

Collecting Windows Logs to CLS

Collect/Query Host File Logs

Search and Analysis

CLB Access Log Analysis

NGINX Access Log Analysis

CDN Access Log Analysis

COS Access Log Analysis

CCN Flow Log Analysis

TKE Event Log Analysis

TKE Audit Log Analysis

Dashboard

Migrating the ES data source of Grafana to the CLS data source

Monitoring Alarm

Setting Alarm Trigger Conditions by Time Period

Setting Interval-Valued Comparison and Periodically-Valued Comparison as Alarm Trigger Conditions

Shipping and Consumption

Consumption of CLS Log with Flink

Using DLC (Hive) to Analyze CLS Log

Developer Guide

Embedding CLS Console

CLS Connection to Grafana

API Documentation

Making API Requests

Topic Management APIs

Log Set Management APIs

Index APIs

Topic Partition APIs

Machine Group APIs

DescribeMachineGroups

DescribeMachines

AddMachineGroupInfo

DeleteMachineGroupInfo

Collection Configuration APIs

ApplyConfigToMachineGroup

DeleteConfigFromMachineGroup

DescribeConfigMachineGroups

DescribeMachineGroupConfigs

Log APIs

Metric APIs

Alarm Policy APIs

DescribeAlertRecordHistory

Data Processing APIs

DescribeDataTransformInfo

ModifyDataTransform

Kafka Protocol Consumption APIs

CloseKafkaConsumer

ModifyKafkaConsumer

OpenKafkaConsumer

DescribeKafkaConsumer

CKafka Shipping Task APIs

Kafka Data Subscription APIs

DescribeKafkaRecharges

CheckRechargeKafkaServer

COS Shipping Task APIs

SCF Delivery Task APIs

CreateDeliverCloudFunction

Scheduled SQL Analysis APIs

DeleteScheduledSql

DescribeScheduledSqlInfo

CreateScheduledSql

ModifyScheduledSql

COS Data Import Task APIs

SearchCosRechargeInfo

FAQs

Health Check

Index Configuration

Log Upload

Collection

Machine Group Exception

LogListener FAQs

LogListener Installation Exception

Container Log Collection

Self-Built Kubernetes Log Collection Troubleshooting Guide

Log Search

Log Search Failure

Search Analysis Error

Others

CLS Service Level Agreement

CLS Policy

Data Processing And Security Agreement

Glossary

DocumentationCloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL FunctionsMathematical Statistical Function

Mathematical Statistical Function

Download PDF

Last updated: 2024-03-20 11:47:49

Mathematical Statistical Function

Last updated: 2024-03-20 11:47:49

Download PDF

This document introduces the basic syntax and examples of mathematical statistical functions.
Basic syntax
Function
Description
corr(key1, key2) 
Returns the correlation coefficient of two columns. The calculation result range is [0,1].
covar_pop(key1, key2) 
Returns the population covariance of two columns.
covar_samp(key1, key2) 
Returns the sample covariance of two columns.
regr_intercept(key1, key2)
Returns linear regression intercept of input values. key1 is the dependent value. key2 is the independent value.
regr_slope(key1, key2) 
Returns linear regression slope of input values. key1 is the dependent value. key2 is the independent value.
stddev(key)    
Returns the sample standard deviation of the key column. This function is equivalent to the stddev_samp function.
stddev_samp(key)
Returns the sample standard deviation of the key column.
stddev_pop(key) 
Returns the population standard deviation of the key column.
variance(key) 
Returns the sample variance of the key column. This function is equivalent to the var_samp function.
var_samp(key) 
Returns the sample variance of the key column.
var_pop(key)   
Returns the population variance of the key column.
Example
Returns the correlation between data in the timeCost (response time) and SamplingRate (sampling rate) columns:
* | select corr(timeCost,SamplingRate)
﻿

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Function	Description
corr(key1, key2)	Returns the correlation coefficient of two columns. The calculation result range is [0,1].
covar_pop(key1, key2)	Returns the population covariance of two columns.
covar_samp(key1, key2)	Returns the sample covariance of two columns.
regr_intercept(key1, key2)	Returns linear regression intercept of input values. `key1` is the dependent value. `key2` is the independent value.
regr_slope(key1, key2)	Returns linear regression slope of input values. `key1` is the dependent value. `key2` is the independent value.
stddev(key)	Returns the sample standard deviation of the `key` column. This function is equivalent to the `stddev_samp` function.
stddev_samp(key)	Returns the sample standard deviation of the `key` column.
stddev_pop(key)	Returns the population standard deviation of the `key` column.
variance(key)	Returns the sample variance of the `key` column. This function is equivalent to the `var_samp` function.
var_samp(key)	Returns the sample variance of the `key` column.
var_pop(key)	Returns the population variance of the `key` column.

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service Special Offers

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

Financial Services

Financial Services Solution

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Real Estate

Tencent Cloud LinkBase(Weiling)

E-commerce

E-commerce retail solutions

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

TencentDB for TcaplusDB

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha