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

Translator infinispan-hotrod incorrect data type import

    XMLWordPrintable

Details

    Description

      I have a vdb:

      jdg71_crud-vdb.xml
      <vdb name="jdg71_crud" version="1">
          <model name="Source" type="PHYSICAL" visible="true">
              <source name="jdg7-source" translator-name="infinispan-hotrod" connection-jndi-name="java:/jdg71HotrodDS" />
              <metadata type="DDL"><![CDATA[
                   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}');
                  ]]>
              </metadata>
              <metadata type = "NATIVE"/>
          </model>
      </vdb>
      

      But the resulting metadata are:

      column_name column_type
      IntKey integer
      IntNum integer
      DoubleNum double
      ObjectValue string
      BigDecimalValue varbinary
      BigIntegerValue varbinary
      CharValue string
      StringNum string
      StringKey string
      FloatNum float
      LongNum long
      TimeValue varbinary
      ShortValue integer
      ByteNum integer
      TimeStampValue varbinary
      BooleanValue boolean
      DateValue varbinary

      All the columns should be replaced by appropriate data type as defined in the vdb.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: