In SAS/ACCESS Interface to Hadoop, the following error occurs when you PROC SQL: INSERT INTO table with the DBCREATE_TABLE_EXTERNAL=YES and DBTABLE_CREATE_LOCATION= options:

ERROR: The specified DBCREATE table location /app/hive/warehouse/TEST/xxx_log is a non-empty HDFS directory. Performing a load would destroy its contents. Change the location to a non-existent or an empty HDFS directory

Note that in SAS 9.4M7 (TS1M7), you can successfully use INSERT INTO with the DBCREATE_TABLE_EXTERNAL=YES and HDFS_DATADIR= options.