CREATE FOREIGN TABLE SmallA (
               IntKey integer,
               IntNum integer,
               DoubleNum double,
               ObjectValue object,
               BigDecimalValue bigdecimal,
               BigIntegerValue biginteger,
               CharValue char,
               StringNum string,
               StringKey string PRIMARY KEY,
               FloatNum float,
               LongNum long,
               TimeValue time,
               ShortValue short,
               ByteNum byte,
               TimeStampValue timestamp,
               BooleanValue boolean,
               DateValue date
             ) OPTIONS(UPDATABLE true, "teiid_ispn:cache" '${jdg.cache.name}');

CREATE VIEW SmallA(
               IntKey integer,
               IntNum integer,
               DoubleNum double,
               ObjectValue object,
               BigDecimalValue bigdecimal,
               BigIntegerValue biginteger,
               CharValue char,
               StringNum string,
               StringKey string PRIMARY KEY,
               FloatNum float,
               LongNum long,
               TimeValue time,
               ShortValue short,
               ByteNum byte,
               TimestampValue timestamp,
               BooleanValue boolean,
               DateValue date
            ) OPTIONS (UPDATABLE true) AS
            SELECT
               source.IntKey AS IntKey,
               source.IntNum as IntNum,
               source.DoubleNum AS DoubleNum,
               source.ObjectValue AS ObjectValue,
               source.BigDecimalValue AS BigDecimalValue,
               source.BigIntegerValue AS BigIntegerValue,
               source.CharValue AS CharValue,
               source.StringNum AS StringNum,
               source.StringKey AS StringKey,
               source.FloatNum AS FloatNum,
               source.LongNum AS LongNum,
               source.TimeValue AS TimeValue,
               source.ShortValue AS ShortValue,
               source.ByteNum AS ByteNum,
               source.TimeStampValue AS TimestampValue,
               source.BooleanValue AS BooleanValue,
               source.DateValue AS DateValue
            FROM Source.SmallA as source;

SELECT BigIntegerValue FROM SmallA WHERE BigIntegerValue<4