In reply to Steven Sober.

Hi ljc,
I was able to validate using PROC SQL and or PROC FEDSQL one can append Hive tables:

/* Full pushdown */
proc FedSQL iptrace libs=hivelib;
insert into hivelib.trash2
select * from hivelib.trash;
quit;

/* Full pushdown */
proc sql;
insert into hivelib.trash2
select * from hivelib.trash;
quit;

148 /* Full pushdown */
149 proc FedSQL iptrace libs=hivelib;
NOTE: FEDSQL: Using libname HIVELIB (engine HADOOP).
NOTE: FEDSQL: Ignoring libname SASHELP (engine V9); not in LIBS= option.
NOTE: FEDSQL: Ignoring libname MAPS (engine V9); not in LIBS= option.
NOTE: FEDSQL: Ignoring libname MAPSSAS (engine V9); not in LIBS= option.
NOTE: FEDSQL: Ignoring libname MAPSGFK (engine V9); not in LIBS= option.
NOTE: FEDSQL: Ignoring libname SASUSER (engine V9); not in LIBS= option.
NOTE: FEDSQL: Using libname WORK (engine V9).
NOTE: Connection string:
NOTE: DRIVER=FEDSQL;CONOPTS= (
(DRIVER=HIVE;SERVER=controller.gtpdm.sashq-d.openstack.sas.com;BULK_LOAD=YES;DBMAX_TEXT=256;PORT=10000;SCHEMA=default;CATALOG=
HIVELIB); (DRIVER=BASE;CATALOG=WORK;SCHEMA=
(NAME=WORK;PRIMARYPATH={/opt/sas/viya/config/var/tmp/compsrv/default/c282f4fd-510a-4f8d-8c35-4e12ac4de221/SAS_work39C700000778
_gtpviya.gtpdm.sashq-d.openstack.sas.com})))
150 insert into hivelib.trash2
151 select * from hivelib.trash;
IPTRACE: Query:
insert into hivelib.trash2 select * from hivelib.trash
IPTRACE: FULL (DDL) pushdown to HIVE SUCCESS!
IPTRACE: Retextualized child query:
insert into table `default`.`TRASH2`select `TRASH`.`make`, `TRASH`.`model`, `TRASH`.`type`, `TRASH`.`origin`, `TRASH`.`drivetrain`,
`TRASH`.`msrp`, `TRASH`.`invoice`, `TRASH`.`enginesize`, `TRASH`.`cylinders`, `TRASH`.`horsepower`, `TRASH`.`mpg_city`,
`TRASH`.`mpg_highway`, `TRASH`.`weight`, `TRASH`.`wheelbase`, `TRASH`.`length` from `default`.`TRASH`
IPTRACE: END
NOTE: Execution succeeded. No rows affected.
152 quit;
NOTE: PROCEDURE FEDSQL used (Total process time):
real time 25.54 seconds
cpu time 0.14 seconds

153
154 /* Full pushdown */
155 proc sql;
156 insert into hivelib.trash2
157 select * from hivelib.trash;
60 1591806039 no_name 0 SQL
HADOOP_16: Prepared: on connection 0 61 1591806039 no_name 0 SQL
DESCRIBE FORMATTED `default`.`TRASH2` 62 1591806039 no_name 0 SQL
63 1591806039 no_name 0 SQL
64 1591806039 no_name 0 SQL
HADOOP_17: Prepared: on connection 0 65 1591806039 no_name 0 SQL
DESCRIBE FORMATTED `default`.`TRASH` 66 1591806039 no_name 0 SQL
67 1591806039 no_name 0 SQL
68 1591806039 no_name 0 SQL
HADOOP_18: Executed: on connection 1 69 1591806039 no_name 0 SQL
insert into table `default`.`TRASH2` (`make`, `model`, `type`, `origin`, `drivetrain`, `msrp`, `invoice`, `enginesize`,
`cylinders`, `horsepower`, `mpg_city`, `mpg_highway`, `weight`, `wheelbase`, `length`) select TXT_2.`make`, TXT_2.`model`,
TXT_2.`type`, TXT_2.`origin`, TXT_2.`drivetrain`, TXT_2.`msrp`, TXT_2.`invoice`, TXT_2.`enginesize`, TXT_2.`cylinders`,
TXT_2.`horsepower`, TXT_2.`mpg_city`, TXT_2.`mpg_highway`, TXT_2.`weight`, TXT_2.`wheelbase`, TXT_2.`length` from `default`.`TRASH`
TXT_2 70 1591806039 no_name 0 SQL
71 1591806039 no_name 0 SQL
158 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 25.02 seconds
cpu time 0.27 seconds

Best regards,
Steve