New DB Table Selector using tez statement hadoop fails

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.

I think you would have to use the

instead. And then use whatever node you need.

3 Likes

Thanks mlauber71.

It seems none of the new DB nodes are allowing the SET tez statement. I’m stuck using the legacy nodes for now.

Well actually they do. You have to use:

image

3 Likes