Netezza Cache Mapping

• IN predicate (with multiple values) with a subquery. It does not support multiple values on the right hand side. For example, Pushable (x,y) IN (select a,b from foo) : Not Pushable - will be processed within TDV - (k, j) IN ( (a, b), (c, d), (e, f) )

Data Type	Native Type
BIGINT	BIGINT, INT8 [not 5.0, 6.0]
BIT	BOOLEAN
BOOL	BOOLEAN
BOOLEAN	BOOLEAN
CHAR	CHAR(n), CHAR [not 5.0, 6.0]
DATE	DATE
DECIMAL	NUMERIC(p,s), DECIMAL [not 5.0, 6.0]
DOUBLE	DOUBLE PRECISION
FLOAT	FLOAT
INTEGER	INT, INT4, INTEGER
INTERVAL	VARCHAR
INTERVAL DAY	VARCHAR(30)
INTERVAL DAY TO HOUR	VARCHAR(30)
INTERVAL DAY TO MINUTE	VARCHAR(30)
INTERVAL DAY TO SECOND	VARCHAR(30)
INTERVAL HOUR	VARCHAR(30)
INTERVAL HOUR TO MINUTE	VARCHAR(30)
INTERVAL HOUR TO SECOND	VARCHAR(30)
INTERVAL MINUTE	VARCHAR(30)
INTERVAL MINUTE TO SECOND	VARCHAR(30)
INTERVAL MONTH	VARCHAR(9)
INTERVAL SECOND	VARCHAR(30)
INTERVAL YEAR	VARCHAR(9)
INTERVAL YEAR TO MONTH	VARCHAR(12)
NUMERIC	NUMERIC(p,s)
REAL	REAL
SMALLINT	SMALLINT, INT2
TIME	TIME, TIMEZ
TIMESTAMP	TIMESTAMP
TIMETZ(n)	TIMETZ [5.0, 6.0]
TINYINT	SMALLINT, INT1 [not 5.0, 6.0]
VARCHAR	VARCHAR(n)