问题描述
我正在使用talend 6.2.1版本.尝试在 tHiveRow 中运行多个配置单元查询，但是如果我用;"分隔查询，那就根本不允许我这样做.
I'm using talend 6.2.1 version. Trying to run multiple hive queries in tHiveRow, but it simply not allowing me to do so if I separate my queries with a ";".
我已经尝试过使用 tForEach ，但是由于它不能包含大于130个字符的值，因此存在局限性.
I have tried with tForEach, but there is a limitation to it as we cannot include a value greater than 130 characters.
因此，我转向了 tFixedFlowInput ，但是在这里似乎不可能对多个查询进行迭代运行.
So, I turned to tFixedFlowInput but iterative run for multiple queries seems not possible here.
我遵循了这个在Talend中使用tHiveRow组件运行多个配置单元查询
有人可以帮助我实现我的目标吗?
Can anybody help me achieve my objective.
推荐答案
这可以通过将配置单元脚本保存在文本文件中来实现.现在读取行分隔符为;"的文本文件.和feild分隔符，因为它们在整个脚本中没有使用(cedilla或$).该文件的架构将只有一列(例如查询)
This can be achieved by saving the hive script in a text file. Now read the textfile with row delimiter as ";" and feild delimiter as something that is not used in the entire script (cedilla or $). Schema of this file will have only one column(say query)
现在连接tfileinputDelimite--row1-> thiverow.在thiverow查询框中，写row1.query
Now connect tfileinputDelimite--row1-->thiverow. In thiverow query box write row1.query
就是这样，它让我.try醒了.
That's it, it has woked for me .try.
这篇关于如何在Talend最新版本的tHiveRow中运行多个配置单元查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！