4 Replies Latest reply on Sep 6, 2016 7:55 AM by Steven Hawkins

    Materialized view - Expected long, but was bigdecimal

    Mark Tawk Novice

      I'm using Teiid 9.0.0 Final

      i'm materializing a view on Oracle that contains a column using TIMESTAMPDIFF and the corresponding column in the materialized view is of type NUMBER(10)

      The materialization is done successfully and records are written to the view table.

      But whenever I fetch the view, i'm getting the error : Error The definition for DbDbTRX2011rfJ190516 has the wrong type for column 3.  Expected long, but was bigdecimal.

      I'm only getting this issue with Oracle; when using TIMESTAMPDIFF in views materialized  on Mysql or SQL Server, the fetching is successful.