I have been using the old DB Table Selector for hive extraction. It worked great. Now I have updated to to the new node but am running into an issue. I need to have beginning statement “SET hive.tez.container.size=4096;” at the start of the query to increase available memory for the query. In certain circumstances the job fails if I do not add this. However the new node is throwing an error if I add this as follows.
“ERROR DB Table Selector 14:860:552:344 Execute failed: Error while compiling statement: FAILED: ParseException line 1:19 cannot recognize input near ‘SET’ ‘hive’ ‘.’ in from source”
Any help on this appreciated.