If your result set isn't as expected and you are struggling to understand why, then it is really useful to be able to see the query that was executed to give you the result. This recipe shows how this can be done.
Open the job
jo_cook_ch07_0030_printInputQuery, which is a copy of the job from the previous recipe.
The steps to be performed are as follows:
tJavaand add the following line:
System.out.println("\nExecuted query: \n"+((String)globalMap.get("tMysqlInput_1_QUERY")));
As we have seen in other recipes, many of the Talend components will drop ...