0 - 4 of 4 tags for algorithmic compression

Hi All,
What is the best options to compress BLOB data? BLC Vs ALC
We are loading large volume of Binary files in teradata. We are thinking to use ALC, is there UPDs to compress and uncompress BOLB data?
Thanks
Khom
 
 
 
 
 
 

Hi Guys,

 

I am doing fast load to an empty table which has one column with algorithmic compression (ALC) using TransUnicodeToUTF8. Below is my table structure.

 

CREATE MULTISET TABLE SCPLN_W.SAMPLE1, NO FALLBACK

(

C1 VARCHAR(1) NOT NULL,

Hi
I want to do compression on the VARCHAR column and it throws me an error
Error: algorithmic compression feature is not yet enabled
Can someone please tell me how i can enable the feature.
2) What are the pros and cons of enabling this feature?
Are there any known bugs with this feature.
 
 
Thanks

The ALC (ALgorithmic Compression) test package contains UDFs simulating TD13.10 built-in compression functions, test templates for Latin and Unicode character columns and step-by-step instructions. It is intended for TD users to run over specific data at column level to determine compression rates of TD 13.10 built-in compression algorithms. The test results provide information for selecting an appropriate algorithm for specific data. These tests use read-only operations and they can be executed on any release that supports UDFs (V2R6.2 & forward). It is recommended to run these tests off peak hours - they will use a significant amount of system resources (CPU bound).