If you read or write to a Hive table in SAS/ACCESS Interface to Hadoop, a "Read access denied" error might occur.

The problem occurs because SAS/ACCESS Interface to Hadoop artificially restricts access to Hive tables that are partitioned by unusual partition column types.

Read access is restricted for the following partition column types:

• TIMESTAMP
• TINYINT
• SMALLINT
• DECIMAL
• BOOLEAN
• FLOAT
• DOUBLE
• BINARY
• ARRAY
• MAP
• STRUCT
• UNION

Write access is restricted for these partition column types:

• TIMESTAMP
• TINYINT
• SMALLINT
• DECIMAL

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Hadoop 9.43 is available at: