11 Replies Latest reply on Mar 8, 2018 2:25 PM by Thiru A

    How to create pushdown function for DIGSTRING using ("teiid_rel:native-query" '$1') in VDB ddl xml file?

    Thiru A Newbie

      How to create pushdown function for DIGSTRING using ("teiid_rel:native-query" '$1') in VDB ddl xml file?

       

      Its working fine in PI OLEDB Tester,

      SELECT Tag, Time, DIGSTRING(CAST(value AS Int32)) State

      FROM piarchive..picomp2

      WHERE

      tag = 'BA:ACTIVE.1'  AND

      time BETWEEN '2018-02-25'  AND '2018-03-01'

       

       

      But not working in Squirrel using Teiid JDBC,

      SELECT PI.Tag, PI."Time", DIGSTRING(Convert(PI.Value,integer)),PI.Value

      FROM "piarchive"."picomp2" PI

      WHERE

      PI.tag = 'BA:ACTIVE.1'  AND

      PI.time BETWEEN '2018-02-25' AND '2018-03-01'

       

       

      Error: TEIID30258 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30258 Expression(s) DIGSTRING(Convert(PI."value", integer)) cannot be pushed to source.

      SQLState:  50000

      ErrorCode: 30258

       

      Thanks

      Thiru