PROC METALIB might return the following error and warning messages when you attempt to register or update metadata for a Hadoop table:

These messages occur when the connection to the Hive server depends on a URI option. The URI option is specified for the Hadoop Library using the Advanced Options dialog box in SAS^® Management Console. From the library Properties window, you select Options ► Advanced Options to open the Advanced Options dialog box. The URI option is specified, as shown in the following display, in the Option(s) to be appended field on the Other Options tab:

In the process to query a table's keys and indexes, PROC METALIB creates a connection to the database similar to how an SQL CONNECT TO statement connects. The URI option is omitted from that connection. As a result, the connection to the database server fails.

The problem does not occur when you initially register the table using the Register Tables wizard in SAS Management Console or in SAS^® Data Integration Studio.

The problem also does not occur when you access the table using a LIBNAME statement with the META engine. The problem does not occur in this scenario because accessing the table with the LIBNAME statement successfully includes the URI option in its assignment.

There is no circumvention for this problem.

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 Base SAS 9.4_M3 is available at:

A fix for this issue for Base SAS 9.4_M2 is available at: