ODBC Hive connection, change container size in the script?

aliegner1 — Sat, 10 Jun 2023 20:45:34 GMT

Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings".

I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call.

How would I do this through JMP? I already have the Cloudera ODBC setup.

//**Globals*******************************
Clear Globals();
Clear Log();
Names Default to Here(1);
//**Globals*******************************


//**HIVE QUERY*************************
myquerystring = "
select *
from table
";

Caption( "Trying to extract the data from HIVE" );
Wait( 1 );
Try(
	hive_table = Open Database( "DSN=server", myquerystring );
,
	Show( exception_msg );
	Throw();
);
Caption( remove );
//**HIVE  QUERY***********************

topic ODBC Hive connection, change container size in the script? in Discussions

ODBC Hive connection, change container size in the script?