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.
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).
The not visible datasets, what is the length of dataset name? Is it over 32 chars?
Yes. it is about 39 chars.
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).
Thank you Reeza and KurtBremser.
Yes, those datasets that are not visible have more than 32 chars for the lenght of dataset name.
Here is SAS documentation for the naming conventions for Impala:
...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."
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.