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***********************
