SQL INSERT INTO returns the error "The specified DBCREATE table location /data/tktstst1/data/test_tab1/tabtest1 is a non-empty HDFS directory..."


An issue occurs in SAS/ACCESS® Interface to Hadoop on SAS® 9.4M8 (TS1M8). When you use SQL INSERT INTO to insert data into an external table while using the DBTABLE_CREATE_LOCATION= option, the following error message occurs:

ERROR: The specified DBCREATE table location /data/tktstst1/data/test_tab1/tabtest1 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 this issue occurs in only SAS 9.4M8 since the DBTABLE_CREATE_LOCATION= option is new to this release.