Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2598

Insert Select to/from Trafodion tables containing LOB columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • sql-exe
    • None

    Description

      Get insert-select from LOB columns to target tables containing LOB columns to work. Two cases need to be considered:
      1. LOB columns thatt contain the lob data in HDFS (regular LOB columns)
      2. LOB columns that contain external LOB data - the data is contained in external LOB files - the Trafodion tables won't contain the LOB data.

      Restrictions : If a table contains an external LOB column the target table must also contain an external LOB column to be able to do an insert-select. Cannot insert a regular LOB column into an external LOB column in target table and vice versa.

      Attachments

        Issue Links

          Activity

            People

              sandhya Sandhya Sundaresan
              sandhya Sandhya Sundaresan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: