[jira] [Created] (TRAFODION-2598) Insert Select to/from Trafodion tables containing LOB columns

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-2598:
---------------------------------------------

             Summary: Insert Select to/from Trafodion tables containing LOB columns
                 Key: TRAFODION-2598
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2598
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Sandhya Sundaresan
            Assignee: Sandhya Sundaresan
             Fix For: 2.2-incubating


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. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)