You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/04/25 22:32:04 UTC
[jira] [Commented] (TRAFODION-2598) Insert Select to/from Trafodion
tables containing LOB columns
[ https://issues.apache.org/jira/browse/TRAFODION-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15983761#comment-15983761 ]
ASF GitHub Bot commented on TRAFODION-2598:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1072
[TRAFODION-2598] Lob insert-select work from/to lob and external lob columns
Support for moving LOB data from source to target table containing LOB columns.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion lob_inssel_work
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1072.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1072
----
commit b8cfdc87ec95694765ad2cd3ca892f95d0a1b5b2
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-04-25T21:07:47Z
Support for insert-select for tables containing LOB columns.
commit 7e10b5a65e9dbafd469778108f1645374d2b1d54
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-04-25T21:14:47Z
Merge remote branch 'origin/master'
----
> 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)