Accessing a flat table that is created from a MongoDB collection might result in an error similar to the following when one of the documents contained a multi-dimension array:

When the flat table is created, a column is created for each element of the array that exists in the MongoDB document. Multi-dimension arrays appear in the flat table as the array base name plus the indices without any separation. So if the array, such as myarr, contains elements such as (11,0) and (1,10), both are given the same name - myarr110. The duplicate column name results in the error when the flat table is accessed. 

There is no workaround for this error.

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 Threaded Kernel Extension for MongoDB 9.42 is available at: