section> Computing
  • Auto Scaling
  • Bare Metal Server
  • Dedicated Host
  • Elastic Cloud Server
  • FunctionGraph
  • Image Management Service
Network
  • Direct Connect
  • Domain Name Service
  • Elastic IP
  • Elastic Load Balancing
  • Enterprise Router
  • NAT Gateway
  • Private Link Access Service
  • Secure Mail Gateway
  • Virtual Private Cloud
  • Virtual Private Network
  • VPC Endpoint
Storage
  • Cloud Backup and Recovery
  • Cloud Server Backup Service
  • Elastic Volume Service
  • Object Storage Service
  • Scalable File Service
  • Storage Disaster Recovery Service
  • Volume Backup Service
Application
  • API Gateway (APIG)
  • Application Operations Management
  • Application Performance Management
  • Distributed Message Service (for Kafka)
  • Simple Message Notification
Data Analysis
  • Cloud Search Service
  • Data Lake Insight
  • Data Warehouse Service
  • DataArts Studio
  • MapReduce Service
  • ModelArts
  • Optical Character Recognition
Container
  • Application Service Mesh
  • Cloud Container Engine
  • Cloud Container Instance
  • Software Repository for Containers
Databases
  • Data Replication Service
  • Distributed Cache Service
  • Distributed Database Middleware
  • Document Database Service
  • GeminiDB
  • Relational Database Service
  • TaurusDB
Management & Deployment
  • Cloud Create
  • Cloud Eye
  • Cloud Trace Service
  • Config
  • Log Tank Service
  • Resource Formation Service
  • Tag Management Service
Security Services
  • Anti-DDoS
  • Cloud Firewall
  • Database Security Service
  • Dedicated Web Application Firewall
  • Host Security Service
  • Identity and Access Management
  • Key Management Service
  • Web Application Firewall
Other
  • Enterprise Dashboard
  • Marketplace
  • Price Calculator
  • Status Dashboard
APIs
  • REST API
  • API Usage Guidelines
  • Endpoints
Development and Automation
  • SDKs
  • Drivers and Tools
  • Terraform
  • Ansible
  • Cloud Create
Architecture Center
  • Best Practices
  • Blueprints
IaaSComputingAuto ScalingBare Metal ServerDedicated HostElastic Cloud ServerFunctionGraphImage Management ServiceNetworkDirect ConnectDomain Name ServiceElastic IPElastic Load BalancingEnterprise RouterNAT GatewayPrivate Link Access ServiceSecure Mail GatewayVirtual Private CloudVirtual Private NetworkVPC EndpointStorageCloud Backup and RecoveryCloud Server Backup ServiceElastic Volume ServiceObject Storage ServiceScalable File ServiceStorage Disaster Recovery ServiceVolume Backup ServicePaaSApplicationAPI Gateway (APIG)Application Operations ManagementApplication Performance ManagementDistributed Message Service (for Kafka)Simple Message NotificationData AnalysisCloud Search ServiceData Lake InsightData Warehouse ServiceDataArts StudioMapReduce ServiceModelArtsOptical Character RecognitionContainerApplication Service MeshCloud Container EngineCloud Container InstanceSoftware Repository for ContainersDatabasesData Replication ServiceDistributed Cache ServiceDistributed Database MiddlewareDocument Database ServiceGeminiDBRelational Database ServiceTaurusDBManagementManagement & DeploymentCloud CreateCloud EyeCloud Trace ServiceConfigLog Tank ServiceResource Formation ServiceTag Management ServiceSecuritySecurity ServicesAnti-DDoSCloud FirewallDatabase Security ServiceDedicated Web Application FirewallHost Security ServiceIdentity and Access ManagementKey Management ServiceWeb Application FirewallOtherOtherEnterprise DashboardMarketplacePrice CalculatorStatus Dashboard

Data Lake Insight

  • Service Overview
  • Getting Started
  • DLI Job Development Process
  • Preparations
  • Creating an Elastic Resource Pool and Queues Within It
  • Creating Databases and Tables
  • Data Migration and Transmission
  • Configuring an Agency to Allow DLI to Access Other Cloud Services
  • Submitting a SQL Job Using DLI
  • Submitting a Flink Job Using DLI
  • Submitting a Spark Job Using DLI
  • Using Cloud Eye to Monitor DLI
  • Using AOM to Monitor DLI
  • Using CTS to Audit DLI
  • Permissions Management
  • Common DLI Management Operations
  • FAQ
    • DLI Basics
    • DLI Elastic Resource Pools and Queues
    • DLI Databases and Tables
      • Why Am I Unable to Query a Table on the DLI Console?
      • How Do I Do If the Compression Rate of an OBS Table Is High?
      • How Do I Do If Inconsistent Character Encoding Leads to Garbled Characters?
      • Do I Need to to Regrant Permissions to Users and Projects After Deleting and Recreating a Table With the Same Name?
      • How Do I Do If Files Imported Into a DLI Partitioned Table Lack Data for the Partition Columns, Causing Query Failures After the Import Is Completed?
      • How Do I Fix Incorrect Data in an OBS Foreign Table Caused by Newline Characters in OBS File Fields?
      • How Do I Prevent a Cartesian Product Query and Resource Overload Due to Missing "ON" Conditions in Table Joins?
      • How Do I Do If I Can't Query Data After Manually Adding It to the Partition Directory of an OBS Table?
      • Why Does the "insert overwrite" Operation Affect All Data in a Partitioned Table Instead of Just the Targeted Partition?
      • Why Does the "create_date" Field in an RDS Table (Datetime Data Type) Appear as a Timestamp in DLI Queries?
      • How Do I Do If Renaming a Table After a SQL Job Causes Incorrect Data Size?
      • How Can I Resolve Data Inconsistencies When Importing Data from DLI to OBS?
    • Enhanced Datasource Connections
    • SQL Jobs
    • Flink Jobs
    • Spark Jobs
    • DLI Resource Quotas
    • DLI Permissions Management
    • DLI APIs
  • Change History
  • User Guide
  • FAQ
  • DLI Databases and Tables

DLI Databases and Tables¶

  • Why Am I Unable to Query a Table on the DLI Console?

  • How Do I Do If the Compression Rate of an OBS Table Is High?

  • How Do I Do If Inconsistent Character Encoding Leads to Garbled Characters?

  • Do I Need to to Regrant Permissions to Users and Projects After Deleting and Recreating a Table With the Same Name?

  • How Do I Do If Files Imported Into a DLI Partitioned Table Lack Data for the Partition Columns, Causing Query Failures After the Import Is Completed?

  • How Do I Fix Incorrect Data in an OBS Foreign Table Caused by Newline Characters in OBS File Fields?

  • How Do I Prevent a Cartesian Product Query and Resource Overload Due to Missing "ON" Conditions in Table Joins?

  • How Do I Do If I Can't Query Data After Manually Adding It to the Partition Directory of an OBS Table?

  • Why Does the "insert overwrite" Operation Affect All Data in a Partitioned Table Instead of Just the Targeted Partition?

  • Why Does the "create_date" Field in an RDS Table (Datetime Data Type) Appear as a Timestamp in DLI Queries?

  • How Do I Do If Renaming a Table After a SQL Job Causes Incorrect Data Size?

  • How Can I Resolve Data Inconsistencies When Importing Data from DLI to OBS?

  • Prev
  • Next
last updated: 2025-06-16 14:07 UTC - commit: 2d6c283406071bb470705521bc41e86fa3400203
Edit pageReport Documentation Bug
Page Contents
  • DLI Databases and Tables
© T-Systems International GmbH
  • Contact
  • Data privacy
  • Disclaimer of Liabilities
  • Imprint