Release Notes

Product Introduction

Overview

Strengths

Use Cases

Purchase Guide

Billing Overview

Refund

Payment Overdue

Configuration Adjustment Fees

Getting Started

Complete Process for New User Activation

DLC Data Import Guide

Quick Start with Data Analytics in Data Lake Compute

Quick Start with Permission Management in Data Lake Compute

Quick Start with Partition Table

Enabling Data Optimization

Cross-Source Analysis of EMR Hive Data

Standard Engine Configuration Guide

Configuring Data Access Policy

Operation Guide

Console Operation Introduction

Development Guide

Runtime Environment

SparkJar Job Development Guide

PySpark Job Development Guide

Query Performance Optimization Guide

UDF Function Development Guide

System Restraints

Client Access

JDBC Access

TDLC Command Line Interface Tool Access

Third-party Software Linkage

Python Access

Practical Tutorial

Accessing DLC Data with Power BI

Table Creation Practice

Using Apache Airflow to Schedule DLC Engine to Submit Tasks

Direct Query of DLC Internal Storage with StarRocks

Spark cost optimization practice

DATA + AI

Using DLC to Analyze CLS Logs

Using Role SSO to Access DLC

Resource-Level Authentication Guide

Implementing Tencent Cloud TCHouse-D Read and Write Operations in DLC

DLC Native Table

SQL Statement

SuperSQL Statement

Overview of Standard Spark Statement

Overview of Standard Presto Statement

Reserved Words

API Documentation

History

Introduction

API Category

Making API Requests

Data Table APIs

Task APIs

Metadata APIs

Service Configuration APIs

Permission Management APIs

Database APIs

Data Source Connection APIs

Data Optimization APIs

Data Engine APIs

Resource Group for the Standard Engine APIs

Data Types

Error Codes

General Reference

Error Codes

Quotas and limits

Operation Guide on Connecting Third-Party Software to DLC

FAQs

FAQs on Permissions

FAQs on Engines

FAQs on Features

FAQs on Spark Jobs

DLC Policy

Data Privacy And Security Agreement

Service Level Agreement

Common Data Types

PDF

Focus Mode

Font Size

Last updated: 2024-08-07 17:09:43

Data Type Category
Data Type
Description
Number
ByteType:BYTE, TINYINT
1-byte signed integer. Range of the number: -128 to 127.
﻿
ShortType:SHORT, SMALLINT
2-byte signed integer. Range of the number: -32768 to 3276.
﻿
IntegerType:INT, INTEGER
4-byte signed integer. Range of the number: -2147483648 to 214748364.
﻿
LongType:LONG, BIGINT
8-byte signed integer. Range: -9223372036854775808 to 922337203685477580.
﻿
FloatType:FLOAT, REAL
4-byte single-precision floating-point number
﻿
DoubleType:DOUBLE
8-byte double-precision floating-point number
﻿
DecimalType:DECIMAL, DEC, NUMERIC
Signed decimal number with random precision
String
StringType:STRING
String value. Example: 'abc'
Byte
BinaryType:BINARY
Byte sequence value.
Boolean
BooleanType:BOOLEAN
Boolean value. Example: true/false
Time
DateType:DATE
Value consisting of the year, month, and day fields, without the time zone.
Example: '2023-10-01'
﻿
TimestampType:TIMESTAMP
Value consisting of the year, month, day, hour, minute, and second fields.
Example: '2023-10-01 23:59:59'
Complex type
ArrayType:ARRAY<element_type>
Sequence value consisting of elements of the specified type.
Example: array<int>
﻿
MapType:MAP<key_type, value_type>
Value consisting of a group of key-value pairs. key_type indicates the type of keys, and value_type indicates the type of values.
Example: map<string, int>
﻿
StructType:STRUCT<field1_name: field1_type, field2_name: field2_type, …>
Struct value consisting of fields
Example: struct<id:int, grade:string>
﻿
﻿

Help and Support

Was this page helpful?

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

Help us improve! Rate your documentation experience in 5 mins.

Feedback

Data Type Category	Data Type	Description
Number	ByteType:BYTE, TINYINT	1-byte signed integer. Range of the number: -128 to 127.
		ShortType:SHORT, SMALLINT	2-byte signed integer. Range of the number: -32768 to 3276.
		IntegerType:INT, INTEGER	4-byte signed integer. Range of the number: -2147483648 to 214748364.
		LongType:LONG, BIGINT	8-byte signed integer. Range: -9223372036854775808 to 922337203685477580.
		FloatType:FLOAT, REAL	4-byte single-precision floating-point number
		DoubleType:DOUBLE	8-byte double-precision floating-point number
		DecimalType:DECIMAL, DEC, NUMERIC	Signed decimal number with random precision
String	StringType:STRING	String value. Example: 'abc'
Byte	BinaryType:BINARY	Byte sequence value.
Boolean	BooleanType:BOOLEAN	Boolean value. Example: true/false
Time	DateType:DATE	Value consisting of the year, month, and day fields, without the time zone. Example: '2023-10-01'
Time		TimestampType:TIMESTAMP	Value consisting of the year, month, day, hour, minute, and second fields. Example: '2023-10-01 23:59:59'
Complex type	ArrayType:ARRAY<element_type>	Sequence value consisting of elements of the specified type. Example: array<int>
		MapType:MAP<key_type, value_type>	Value consisting of a group of key-value pairs. key_type indicates the type of keys, and value_type indicates the type of values. Example: map<string, int>
		StructType:STRUCT<field1_name: field1_type, field2_name: field2_type, …>	Struct value consisting of fields Example: struct<id:int, grade:string>

tencent cloud

Data Lake Compute

Common Data Types

Help and Support