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

Redshift - RS does not support ASCII function

    XMLWordPrintable

Details

    • Hide

      VDB:

      <vdb name="test" version="1">
          <model name="Source" type="PHYSICAL">
              <source name="rs" connection-jndi-name="java:/Redshift" translator-name="postgresql"/>
              <metadata type="DDL">
                  <![CDATA[create foreign table SmallA (
                      intkey integer OPTIONS(NAMEINSOURCE 'intkey', NATIVE_TYPE 'int4'),
                      timevalue timestamp OPTIONS(NAMEINSOURCE 'timevalue', NATIVE_TYPE 'timestamp')) OPTIONS(NAMEINSOURCE 'smalla');
                  ]]>
              </metadata>
          </model>
      </vdb>
      
      Show
      VDB: <vdb name= "test" version= "1" > <model name= "Source" type= "PHYSICAL" > <source name= "rs" connection-jndi-name= "java:/Redshift" translator-name= "postgresql" /> <metadata type= "DDL" > <![CDATA[create foreign table SmallA ( intkey integer OPTIONS(NAMEINSOURCE 'intkey' , NATIVE_TYPE 'int4' ), timevalue timestamp OPTIONS(NAMEINSOURCE 'timevalue' , NATIVE_TYPE 'timestamp' )) OPTIONS(NAMEINSOURCE 'smalla' ); ]]> </metadata> </model> </vdb>

    Description

      Redshift database does not support ASCII function

      E.g. SELECT INTKEY, ASCII(INTKEY) FROM BQT1.SmallA ORDER BY INTKEY is translated as SELECT g_0.intkey AS c_0, ascii(cast(g_0.intkey AS varchar(4000))) AS c_1 FROM smalla AS g_0 ORDER BY c_0

      Result:

      Unable to find source-code formatter for language: text. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj DurĂ¡ni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: