Problem Note 68136: The SUBSTR() function is not passed to Hadoop and the SAS® log contains the message "Streaming read CTAS error: Error while compiling statement..."
 |  |  |  |  |
When you attempt to use the SUBSTR() function and the third argument is not an integer, the query is not passed to Hadoop. In this scenario, an error similar to the following is printed in the SAS® log:
HADOOP: Streaming read CTAS error: Error while compiling statement: FAILED:
ParseException line 1:352 mismatched input 'instr' expecting Number near '('
in primitive type specification
HADOOP: Reverting to non-CTAS HiveQL
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.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 |
| 64-bit Enabled AIX | 9.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 9.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 | ||
| HP-UX IPF | 9.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 | ||
| Linux for x64 | 9.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 | ||
| Solaris for x64 | 9.47 | 9.47 | 9.4 TS1M7 | 9.4 TS1M7 | ||
A fix for this issue for SAS/ACCESS Interface to Hadoop 9.47 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J8A.html#68136| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-07-15 08:35:53 |
| Date Created: | 2021-07-13 09:31:55 |