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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.