GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/507
External lob support [TRAFODION-2008]
Changes to support new syntax to allow an external hdfs file to be
specified as a LOB without having to import the lob data into trafodion. Thisis
similar to Oracle's BFILE support.
The table column needs to be specified as external during table creation.
Once declared as external the column cannot later hold internal LOB data.
Similarly a column declared as a regular BLOB/CLOB column without specifying
the external attribute cannot later point to an external file.
Details in JIRA 2008.
Changes include support for insert/update, extract and select. Also
includes changes to showddl and "get lob stats" command to show that a column
contains external file data.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion external_lob
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/507.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 #507
----
commit 17c0530224a9be7b6aa4dcfba3b408423c3e9dd9
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-05-27T04:39:52Z
Support for external lobs. Data files are stored externally in HDFS and
only filehandles and file locations are stored in internal Trafodion tables.
commit 5a3f20249cabb16b3afe64ab0d21cdf2decafeea
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-05-27T04:41:13Z
Support for external lobs. Data files are stored externally in HDFS and
only filehandles and file locations are stored in internal Trafodion tables.
commit db3ebf5d70156aa2d987656dc7231b0ebf9904d3
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-05-27T06:45:37Z
Merge remote branch 'origin/master'
Conflicts:
core/sql/regress/executor/EXPECTED130
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
