ConvertToCategorical Example - Teradata Vantage

Input

The input table, categorize_input, contains information about houses. All columns have numeric data types. The first three columns represent numeric values, but the other columns represent codes or categories. The following two tables are the input table itself and its schema description, respectively.

To check the input data variable types, use this query: \d categorize_input

The query returns:

Table "public"."categorize_input"
Column    | Type    | Modifiers 
-------------------------------
sn        | integer | 
price     | real    | 
lotsize   | real    | 
driveway  | integer | 
recroom   | integer | 
fullbase  | integer | 
gashw     | integer | 
airco     | integer | 
prefarea  | integer | 
homestyle | integer |

Table Type:
fact

Distribution Key:
sn

Compression Level:
none

Storage Type:
row

Persistence:
permanent

SQL Call

CREATE MULTISET TABLE categorize_output AS (
  SELECT * FROM ConvertToCategorical (
    ON categorize_input PARTITION BY ANY
    USING
    Columns ('[4:9]')
  ) AS dt
) WITH DATA;

Output

This query returns the output table:

SELECT * FROM categorize_output ORDER BY 1;

The output table looks like the input table, but its schema is different. To check the output data variable types, use this query: \d categorize_output

The query returns:

Table "public"."categorize_output"
Column    | Type              | Modifiers 
-----------------------------------------
sn        | integer           | 
price     | real              | 
lotsize   | real              | 
driveway  | integer           | 
recroom   | character varying | 
fullbase  | character varying | 
gashw     | character varying | 
airco     | character varying | 
prefarea  | character varying | 
homestyle | character varying |

Table Type:
fact

Distribution Key:
sn

Compression Level:
none

Storage Type:
row

Persistence:
permanent