Problem Note 62637: The TEMPORARY keyword is missing for a staging table when you use SAS® High Performance procedures with the LIBNAME option DBCREATE_TABLE_OPTS=
 |  |  |  |  |
When you use SAS High Performance procedures with the LIBNAME option DBCREATE_TABLE_OPTS=, a temporary table is created in Apache Hive.
However, the TEMPORARY keyword is missing before the word TABLE in the CREATE TABLE statement, as shown in the following SAS log with the SASTRACE= system option enabled:
options sastrace=',,,d' sastraceloc=saslog nostsuffix;
...
HADOOP_19: Executed: on connection 3
CREATE TABLE `default`.`sastmp_02_12_10_31_16_073_00003` (`y` DOUBLE,`id`
DOUBLE,`_PartInd_` DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
LINES TERMINATED BY '\012' STORED AS TEXTFILE LOCATION
'/tmp/sim_2018-02-12-10-30-28-004-05'
CREATE TABLE `default`.`sastmp_02_12_10_31_16_073_00003` (`y` DOUBLE,`id`
DOUBLE,`_PartInd_` DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
LINES TERMINATED BY '\012' STORED AS TEXTFILE LOCATION
'/tmp/sim_2018-02-12-10-30-28-004-05'
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Hadoop | Microsoft® Windows® for x64 | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.44 | 9.45 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS/ACCESS Interface to Hadoop 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D7H.html#62637A fix for this issue for SAS/ACCESS Interface to Hadoop 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A7J.html#62637| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-07-23 10:33:35 |
| Date Created: | 2018-07-19 04:48:22 |