We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
请教个问题,我们的需求是Oracle数据传输到 Doris,有个值需通过Oracle中sys_context方法获取请求会话的上下文信息,该怎么操作呢?
The text was updated successfully, but these errors were encountered:
在同步过程中,需要配合sys_context中查询到的数据进行加工处理,那么建议使用“增强js”节点中的查询能力和全局缓存能力完成
该节点可以填入javascript代码,更灵活的对每条源表数据进行加工
具体操作如下: 在源节点和目标节点中间,增加一个“增强js”节点,里面填写的代码可以参照下面的示范,根据实际情况进行编写
sys_context_result = source.executeQuery({sql: 'SELECT SYS_CONTEXT(...) FROM DUAL'})
sys_context_result = context.global.sys_context_result if(!context.global.sys_context_result) { // 没有缓存值,进行查询,并缓存 context.global.sys_context_result = source.executeQuery({sql: 'SELECT SYS_CONTEXT(...) FROM DUAL'}) } // 后续业务逻辑代码 ...
如果使用的是Tapdata命令行,上面的操作会比较困难,建议前往Tapdata云版 云版连接
Sorry, something went wrong.
Appears to be resolved
ply0011
No branches or pull requests
Comment
请教个问题,我们的需求是Oracle数据传输到 Doris,有个值需通过Oracle中sys_context方法获取请求会话的上下文信息,该怎么操作呢?
The text was updated successfully, but these errors were encountered: