Binary Type
For details about the binary types supported by DataArts Fabric SQL, see Table 1.
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; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot