Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5117

Osisoft Translator - Casting to bigdecimal results in NULL value

    XMLWordPrintable

Details

    Description

      Casting any value obtained from an Osisoft PI datasource results in NULL, regardless of the original value.
      E.g. a query such as

      select cast(stringnum as bigdecimal), cast(intnum as bigdecimal), cast(shortvalue as bigdecimal) from Source.smalla
      

      returns result set full of NULLs.

      The SOURCE SRC COMMAND in teiid-command.log for this query is however

      SELECT g_0.StringNum, g_0.IntNum, g_0.ShortValue FROM dvqe..SmallA AS g_0
      

      i.e. the cast is not pushed down (as Osisoft doesn't support bigdecimal datatype).

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: