/******************************************************************************
 * Programme : SAS Performance Tuning: Supercharge Your Hadoop Uploads with BULKLOAD=YES
 * Reference : EXPLOR27C5
 * Source    : https://www.wearecas.eu/de/sampleCode/EXPLOR27C5
 ******************************************************************************/

/* --- BLOC 1 --- */
libname mycdh hadoop server="quickstart.cloudera" user=cloudera password=cloudera;
options sastrace=',,,d' sastraceloc=saslog nostsuffix;

/* --- BLOC 2 --- */
proc append base=mycdh.cars (bulkload=yes)
            data=sashelp.cars;
run;

proc sql;
   drop table mycdh.cars;
quit;

/* --- BLOC 3 --- */
proc append base=mycdh.cars
            data=sashelp.cars;
run;

proc sql;
   drop table mycdh.cars;
quit;

/* --- BLOC 4 --- */
proc append base=mycdh.cars (dbcreate_table_opts='stored as parquetfile')
            data=sashelp.cars;
run;

proc sql;
   drop table mycdh.cars;
quit;