[
https://issues.apache.org/jira/browse/OOZIE-1150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13620442#comment-13620442
]
Ryota Egashira commented on OOZIE-1150:
---------------------------------------
sorry for late response.
>found the following that would work:
>http://apache-database.10148.n7.nabble.com/Characters-replacement-function-td7785.html
thanks for information, I tried the same thing, created replace function in
OozieDBCli, and added following SQL
----------
CREATE FUNCTION REPLACE(STR VARCHAR(50), OLD CHAR(1), NEW CHAR(2)) RETURNS
VARCHAR(50) PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME
'org.apache.oozie.tools.OozieDBCLI.replaceForDerby'
UPDATE COORD_ACTIONS SET MISSING_DEPENDENCIES =
REPLACE(MISSING_DEPENDENCIES,';','!!')
----------
but it seems that we cannot do this operation for CLOB column like
MISSING_DEPENDENCIES
I hit following.
----------
"java.sql.SQLException: BLOB/CLOB values are not allowed as method parameters
or receiver.
----------
just for test, I applied the same replace function on other VARCHAR column and
it worked.
tried couple of minor things (like, changing VARCHAR->CLOB in argument), but no
luck so far.
so I might need to read record by record from COORD_ACTIONS, update CLOB, which
seems the only way now.
>the seems to be for Oracle only. I wonder if we should remove all the sql
>scripts
yes, discussed with other folks on this, too and I will remove sql scripts.
> DB upgrade scripts for hcat changes
> -----------------------------------
>
> Key: OOZIE-1150
> URL: https://issues.apache.org/jira/browse/OOZIE-1150
> Project: Oozie
> Issue Type: Sub-task
> Reporter: Rohini Palaniswamy
> Assignee: Ryota Egashira
> Fix For: trunk
>
> Attachments: OOZIE-1150-1.patch, OOZIE-1150-branch3.3.patch,
> OOZIE-1150.patch, OOZIE-1150-v3.patch, OOZIE-1150-v5.patch,
> OOZIE-1150-v6.patch
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
