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

HBase translator - INSERT could rewrite the data

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.12
    • 8.7.1.6_2
    • None
    • None

    Description

      The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data.

      Additional note: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619

      [1]
      INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55)
      http://phoenix.apache.org/language/index.html#upsert_values

      [2]
      INSERT INTO smalla (intkey, name) VALUES (1, 'name1')
      INSERT INTO smalla (intkey, name) VALUES (1, 'name2')

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: