New DB Table Selector using tez statement hadoop fails

KNIME Extensions Big Data
#1

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.

#2

I think you would have to use the

instead. And then use whatever node you need.

3 Likes
#3

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.

#4

Well actually they do. You have to use:

image

3 Likes