In reply to ljc.

Hi ljc,
Researching this I found this link which explains your options using HIVEQL to append 2 Hive tables using the INSERT INTO statement https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Syntax.1

To test if PROC SQL INSERT INTO will push down submit these OPTION statements prior to your PROC SQL code:

/*-------------------------------------------------------------------------------
**1.0 SAS system option to push PROC SQL, FREQ, MEANS, RANK, REPORT, SUMMARY and
** TABULATE down in their SQL
*/
options SQLGENERATION=(NONE DBMS='TERADATA DB2 ORACLE NETEZZA ASTER GREENPLM HADOOP SAPHANA IMPALA HAWQ POSTGRES REDSHIFT SQLSVR VERTICA');
/*------------------------------------------------------
**2.0 SAS system option to prove where SQL was processed
*/
OPTIONS sastrace=',,,ds' sastraceloc=saslog nostsuffix;
OPTIONS MSGLEVEL=I;

Best regards,
Steve