DataArts Fabric
DataArts Fabric
All results for "
" in this service
All results for "
" in this service
Service Overview
What Is DataArts Fabric?
Advantages
Scenario
Features
DataArtsFabric SQL Features
Product Specifications
Permissions Management
Constraints
Ray and XDS Restrictions
DataArtsFabric SQL Restrictions
Billing
Overview
Ray and XDS Billing Overview
DataArtsFabric SQL Billing Overview
Billing Items
Ray and XDS Billing Items
DataArtsFabric SQL Billing Items
Billing Mode
Modifying Configurations
Bills
Stopping Billing
Expiration and Renewal
User Guide
Preparations
Creating an IAM User and Assigning Permissions to Use DataArtsFabric
Configuring DataArtsFabric Service Agency Permissions
Creating an Access Client
Creating a Workspace
Ray Scenario
Ray Resource Management
Purchasing a Ray Resource
Unsubscribing from Ray Resources
Image Management
Ray Cluster Management
Creating a Ray Cluster
Viewing the Ray Cluster Overview
Creating a Ray Job
Running a Ray Job
Managing Ray Jobs
Viewing the Ray Dashboard
Deleting a Ray Cluster
Viewing Metrics
Managing Ray Services
Creating a Ray Service
Upgrading a Ray Service
Running an Inference Service
Deleting a Ray Service
DataArtsFabric SQL
DataArtsFabric SQL Usage Process
Managing SQL Endpoints
Creating a SQL Endpoint
Modifying a SQL Endpoint
Deleting a SQL Endpoint
Querying Details About a SQL Endpoint
Querying the SQL Job History
Using SQL Editor
Practices for Beginners
Using DataArtsFabric SQL to Import and Query Data
Interconnection with Ecosystem Components
Accessing DataArtsFabric SQL Using DBeaver
Accessing DataArtsFabric SQL Using Tableau
Obtaining JDBC
Large Model Inference Scenarios
Introduction to Large Model Inference Scenarios
Large Model Inference Process
Using a Public Inference Service for Inference
Viewing a Public Inference Service
Enabling an Inference Service
Performing Inference in the Playground
Creating My Inference Service for Inference
Creating a Model
Managing a Model
Creating an Inference Endpoint
Creating an Inference Service
Using an Inference Service for Inference
Deleting an Inference Service
Deleting an Inference Endpoint
Viewing All Metrics on AOM
O&M Management
Configuring Message Notifications
Deleting a Notification
Best Practices
Using Ray for Small Model Inference
Example of Configuring Permissions for Using the Inference Service
Using DataArts Fabric SQL to Query Data
Developer Guide
Before You Start
Designing Database Objects
Understanding DataArts Fabric SQL Database Objects
Creating and Managing Schemas
Creating and Managing Tables
Defining Table Partitions
Querying Data
Querying a Single Table
Querying Joined Tables
WITH Expression
SQL on Iceberg
Introduction to Iceberg
Catalog Introduction
Preparations Before Using Iceberg
Creating, Clearing, and Deleting an Iceberg Table
Modifying an Iceberg Table
Querying and Writing an Iceberg Table
Accessing Iceberg Tables Created by Third-Party Engines
Iceberg Table Services
How to Handle Iceberg Table Concurrency Conflicts
Concurrent Data Modification Conflicts
Optimistic Lock Concurrent Commit Conflicts
JDBC Secondary Development
Development Specifications
Obtaining the JDBC Driver
JDBC-based Development
JDBC Package and Driver Class
Development Process
Loading the Driver
Connecting to the Database
Executing SQL Statements
Processing Result Sets
Closing the Connection
Example: Common Operations
JDBC Interfaces
java.sql.Connection
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
Java SDK
Important Notes
Preparations
Initializing the Client
SDK Methods
Performance Tuning
Overview
System Optimization
Tuning Database Parameters
SMP Parallel Execution
SQL Tuning
SQL Query Execution Process
SQL Execution Plan
Execution Plan Operator
SQL Execution Monitoring
SQL Tuning Process
Updating Statistics
Advanced SQL Tuning
Optimizing Subqueries
Optimizing Operators
SQL Statement Rewriting Rules
Configuring Optimizer Parameters
Hint-based Tuning
Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Sublink Name Hints
Hint That Disables Subquery Pull-up
Configuration Parameter Hints
Hint Errors, Conflicts, and Other Warnings
Python UDF Performance Tuning
SQL Tuning Examples
Case: Adjusting the GUC Parameter best_agg_plan
Python UDF Performance Tuning
System Catalogs
PG_AGGREGATE
PG_ATTRIBUTE
PG_AUTHID
PG_CLASS
PG_COLLATION
PG_DATABASE
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_NAMESPACE
PG_OPCLASS
PG_OPERATOR
PG_PROC
PG_TYPE
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
GUC Parameter
Viewing and Setting GUC Parameters
Connection and Authentication
Security and Authentication
Query Planning
Optimizer Method Configuration
Other Optimizer Options
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Lock Management
SQL Syntax Reference
Keywords
Data Types
Mapping Between DataArts Fabric SQL and LakeFormation Data Types
Numeric Types
Boolean Type
Character Types
Binary Type
Date/Time Type
Object Identifier Type
Implicit Conversion Support Range
Complex Type
Functions and Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Numeric Operation Functions and Operators
Numeric Operators
Numeric Operation Functions
Time and Date Processing Functions and Operators
Time and Date Operators
Time and Date Functions
EXTRACT
date_part
date_format
time_format
SEQUENCE Functions
Array Functions and Operators
Array Operators
Array Functions
Logical Operators
Comparison Operators
Pattern Matching Operators
Aggregate Functions
Window Functions
Type Conversion Functions
JSON/JSONB Functions and Operators
JSON/JSONB Operators
JSON/JSONB Functions
Conditional Expression Functions
Range Functions and Operators
Range Operators
Range Functions
UUID Functions
Text Search Functions and Operators
Text Search Operators
Text Search Functions
Text Search Debugging Functions
HLL Functions and Operators
HLL Operators
Hash Functions
Precision Functions
Aggregate Functions
Functional Functions
Built-in Functions
Set Returning Functions
Series Generating Functions
Subscript Generating Functions
Geometric Functions and Operators
Geometric Operators
Geometric Functions
Geometric Type Conversion Functions
Network Address Functions and Operators
cidr and inet Operators
Network Address Functions
System Information Functions
Session Information Functions
System Catalog Information Functions
System Function Information Functions
Status Information Functions
System Management Functions
Configuration Setting Functions
Server Signaling Functions
Memory Management Functions
Database Object Functions
Collation Version Function
Database Object Size Functions
Statistics Functions
XML Functions
Generating XML Content
XML Predicates
Processing XML
Mapping a Table to XML
Funnel and Retention Functions
ICEBERG Table Service Functions
UDF Configuration
Expression
Simple Expressions
Conditional Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
DDL Syntax
SHOW
SHOW Conf
SHOW Schemas/Tables/Views/Partitions/Functions
CREATE SCHEMA
DROP SCHEMA
CREATE TABLE
CREATE VIEW
CREATE FUNCTION
DROP TABLE
DROP VIEW
DROP FUNCTION
ALTER TABLE
DESCRIBE
MSCK REPAIR TABLE
TRUNCATE
DML Syntax
Overview
EXPLAIN
INSERT
VALUES
DELETE
DCL Syntax
ANALYZE | ANALYSE
DQL Syntax
Overview
SELECT
Data-AI Convergence
DataArts Fabric DataFrame
Overview
Preparations
Getting Started
Registering a Scalar UDF Using the DataFrame API
Scalar UDF Types
Overview
Explicitly Registering a Scalar UDF
Implicitly Registering a Scalar UDF
Scenario Practices
Examples of DataFrames Without UDFs
Examples of DataFrames with UDFs
Example of Directly Using DataFrame with Scalar UDFs
DataArts Fabric DataFrame API Reference
DataArts Fabric DataFrame Connection Parameters
DataArts Fabric DataFrame Parameter Configuration
Scalar UDF Explicit Registration Syntax
Scalar UDF Implicit Registration Syntax
Scalar Python UDF Registration Parameters
Scalar Builtin UDF Registration Parameters
Type Inference of the signature Parameter
Scalar UDF Direct Operation Syntax
DataFrame create_table Function Usage
Function Reference
UDFs
DataArts Fabric SQL UDF Overview
UDF Development (Python)
Constraints
Data Type Mapping
Organization Structure of the Code Archive Package
Development Notes
Scalar UDF
WITH ARGUMENTS Syntax
Adaptive Parallelism
Performance White Paper
Inference Performance White Paper
API Reference
Before You Start
API Overview
Calling APIs
Making an API Request
Authentication
Responses
APIs
Service Health Check
Performing a Health Check
User Agreement Management
Querying a System Agreement
Registering a Tenant Agreement
Querying Whether a User Has Registered with an Agreement
Deleting a User Registration Agreement
Agency Management
Creating a Service Agency
Querying a Service Agency
Deleting a Service Agency
Workspace Management
Querying the Workspace List
Updating a Workspace
Creating a Workspace
Deleting a Workspace
Service Specifications
Querying the Resource Specification List
Endpoint Management
Querying the Endpoint List
Creating an Endpoint
Querying Details About an Endpoint
Modifying an Endpoint
Deleting an Endpoint
Subscribing to an Endpoint
Model Definition
Creating a Model
Querying the Model List
Listing Base Models
Deleting a Specified Version of a Model
Updating Model Information
Checking the Model Version List
Deleting Unused Model Definitions
TMS Management
Querying Project Tags
Querying Resource Tags
Querying the Resource Instance List
Querying the Number of Resource Instances
Batch Tagging Resources
Batch Deleting Resource Tags
Message Management
Creating a Notification Policy
Querying the Notification Policy List
Deleting a Notification Policy
Monitoring Management
Updating the Configuration for AOM to Collect Monitoring Metrics
Access Client
Creating a VPC Endpoint Client
Querying the VPC Endpoint Client List
Querying Details About a VPC Endpoint Client
Deleting a VPC Endpoint Client
Updating a VPC Endpoint Client
Service Instance Management
Listing Deployed Service Instances
Checking Details About a Deployed Service Instance
Deploying a Service
Updating a Deployed Service Instance
Deleting a Service Instance
Inference Service APIs
Initiating an Invocation Request
Ray session API.
Obtaining Session Information
SQL APIs
Creating a SQL Session
Querying the SQL Session List
Querying Session Information
Closing a Session
Executing a SQL Statement
Obtaining Statement Execution Results and Status
Canceling Statement Execution
Querying SQL Execution Records
Querying SQL Execution Records in a Specified Session
Examples
Creating an Inference Service
Permissions and Supported Actions
Introduction
Actions Supported by Policies
Appendix
Status Codes
Error Codes
Obtaining a Project ID
Obtaining an Account ID
Obtaining a Workspace ID
Obtaining an Endpoint ID
Obtaining a Model ID
Obtaining an Inference Service Instance ID
Obtaining an Enterprise Project ID
SDK Reference
SDK Overview
FAQs
What Are Regions and AZs?
What Is a Project?
What Is Ray?
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions