Materialized view not generating columns with type Integer

[ShivaniSK]

Hi @alex-karpovich ,
We are trying to create view from the Timebase web client.
Below is the schema of the table

DURABLE STREAM "order_book_depth" (
    CLASS "com.db.jupiter.models.OrderBookDepth" 'Order Book Depth' (
        "trade_type" 'Trade Type' VARCHAR,
        "venue" 'Venue' VARCHAR,
        "bid_price" 'Bid Price' FLOAT DECIMAL,
        "bid_size" 'Bid Size' INTEGER,
        "bid_count" 'Bid Count' INTEGER SIGNED (16),
        "ask_price" 'Ask Price' FLOAT DECIMAL,
        "ask_size" 'Ask Size' INTEGER,
        "ask_count" 'Ask Count' INTEGER SIGNED (16),
        "level" 'Level' VARCHAR,
        "run_date" 'Run Date' VARCHAR,
        "batch_number" 'Batch Number' VARCHAR
    );
)
OPTIONS (FIXEDTYPE; PERIODICITY = 'IRREGULAR'; HIGHAVAILABILITY = FALSE; UNIQUE = FALSE; STORAGEVERSION = '5')
COMMENT 'order_book_depth_stream'

We are giving below query for generating the view

select last{}  (bid_size) as bidSize, 
last{}  (ask_size) as askSize, 
last{}  (bid_price) as bidPrice,  last{}  (ask_price) as askPrice,
last{}  (bid_count) as bidCount,  last{}  (ask_count) as askCount, 
last{}  (venue) as venue, level, 
last{}  (timestamp) as timestampOg 
from order_book_depth RESET over TIME (1m) 
where timestamp BETWEEN 1709596800000
AND 1709683199999
GROUP BY SYMBOL, trade_type, level

Exepcted behavior
View generated with above columns mentioned in the query

Actual behaviour
View is generated only with below columns
bidPrice, askPrice, venue, level, timestampOg

Cannot find below columns in the view
bidSize, askSize, bidCount, askCount.

[ShivaniSK]

Hi @alex-karpovich , issue was with the query as we weren't casting the bid_size and ask_size to DECIMAL.
Its working fine now. Closing the ticket.