Some of SAS EG datasets are not visible

[Riana]

Hi,

I'm using Impala connector in SAS EG to connect to the data sources and after running the libname it shows a list of databases under "Libraries" folder.

But when I check source databases in Hue/Impala and compare them with databases in SAS EG, it seems that some of them are visible in SAS EG and not visible in Hue/Impala and vice versa. Why this happens?

Thanks.

[Reeza]

The not visible datasets, what is the length of dataset name? Is it over 32 chars?

[Riana]

Yes. it is about 39 chars.

[Kurt_Bremser · Accepted solution]

So at least part of your problem is that there are table names in the Impala database that exceed the maximum length of SAS dataset names (32).

[Riana]

Thank you Reeza and KurtBremser. 

Yes, those datasets that are not visible have more than 32 chars for the lenght of dataset name.

[CaseySmith]

Here is SAS documentation for the naming conventions for Impala:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#n0zbh5w5ucvt2gn1t1...

...confirming "DBMS table names must be 32 characters or less. SAS does not truncate a name longer than 32 characters. If you have a table name that is greater than 32 characters, it is recommended that you create a table view."