Hi, in my work I need to upload temporary table from SAS server to EAP server. Now we are using TRINO/Voyager and under SAS we can do it running the below codes, but it is very sloooooow. Uploading 428 records from SAS (sashelp.cars) to EAP takes 13/24 minutes. I have experience with hadoop and under hadoop it takes 2-3 minutes. Do you know how can I speed up this step ? I tried to add “BULKLOAD=YES” option but no change. Best Regards 28 29 libname libtest jdbc classpath='/opt/sas/JDBC3/' 30 class='io.trino.jdbc.TrinoDriver' 31 URL='jdbc:trino://ccc.aaa.bbb.net:8980/eap/aml?SSL=true&SSLVerification=CA&SSLTrustStorePath=/opt/sas/JDBC3/cacerts.jks&SSLTrustStorePassword=changeit' 32 user=&sysuserid. 33 password="&pass." 34 schema=my_schema 35 36 ; NOTE: Libref LIBTEST was successfully assigned as follows: Engine: JDBC 37 38 data libtest.sas_test_upl_presto2; 39 set sashelp.cars; 40 run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. NOTE: There were 428 observations read from the data set SASHELP.CARS. NOTE: The data set LIBTEST.SAS_TEST_UPL_PRESTO2 has 428 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 13:08.07 cpu time 0.35 seconds
... View more