0 - 4 of 4 tags for algorithmic compression
Blob 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
 
 
 
 
 
 

By Khoms, 07 May 2016 | Tagged: alc blc algorithmic compression
issue in fast load with algorithmic compression

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,

By Santanu84, 10 Jan 2014 | Tagged: fast load alc algorithmic compression transunicodetoutf8 | 1 comment
Enabling ALC, Pros and cons

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

By harish.palakuri, 28 Feb 2013 | Tagged: algorithmic compression | 5 comments
Algorithmic Compression Test Package

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).

By devxadmin, 12 Nov 2010 | Tagged: compression utf-8 alc algorithmic compression test camset zlib