Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
SQL Implicit Conversion
Last updated: 2025-03-07 15:52:30
To facilitate SQL writing and quickly switch from Hive/Spark syntax to DLC unified SQL, we offer SQL implicit conversion capabilities. The conversion list is as follows:#LF#I: implicit cast, E: explicit cast, --: not allowed.
From-To | null | boolean | tinyint | smallint | int | bigint | decimal | float/real | double | interval | date | time | timestamp | [var]char | [var]binary |
null | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι |
boolean | -- | Ι | E | E | E | E | E | E | E | -- | -- | -- | -- | Ι | -- |
tinyint | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | E | -- | -- | E | Ι | -- |
smallint | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | E | -- | -- | E | Ι | -- |
int | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | E | -- | -- | E | Ι | -- |
bigint | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | E | -- | -- | E | Ι | -- |
decimal | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | E | -- | -- | E | Ι | -- |
float/real | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | -- | -- | -- | E | Ι | -- |
double | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | -- | -- | -- | E | Ι | -- |
interval | -- | -- | E | E | E | E | E | -- | -- | Ι | -- | -- | -- | E | -- |
date | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | Ι | -- | Ι | Ι | -- |
time | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | Ι | E | Ι | -- |
timestamp | -- | -- | E | E | E | E | E | E | E | -- | Ι | E | Ι | Ι | -- |
[var]char | -- | E | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι | Ι |
[var]binary | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | E | E | E | Ι | Ι |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No