Help Center/ DataArts Fabric/ Developer Guide/ SQL Syntax Reference/ Data Types/ Binary Type
Updated on 2025-08-25 GMT+08:00
View PDF
Share

Binary Type

For details about the binary types supported by DataArts Fabric SQL, see Table 1.

Table 1 Binary type

Type

Description

Storage Space

BYTEA

Variable-length binary string.

4 bytes plus the actual binary string. The maximum size is 1,073,733,621 bytes (1 GB – 8,023 bytes).

In addition to the size limit per column, the total size of each tuple must not exceed 1 GB – 8,203 bytes.

Example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
 
-- Create a table.
CREATE TABLE binary_type_t1
(
BT_COL1 INTEGER,
BT_COL2 BYTEA
) STORE AS orc;

-- Insert data.
INSERT INTO binary_type_t1 VALUES(10, E'\\xDEADBEEF');

-- Query data from the table.
SELECT * FROM binary_type_t1;
 bt_col1 |  bt_col2   
---------+------------
      10 | \xdeadbeef
(1 row)

-- Drop the table.
DROP TABLE binary_type_t1;
Parent topic: Data Types