Given that CAS tables are in-memory that gets wiped out whenever the server needs to restart (like for maintenance) I'd go for a daily full-load. Depending on how your environment looks like a load from Hadoop executes potentially fully in parallel and can be very fast.   I'd certainly go for a SAS coding option that's scheduled. If you must load new data during business hours then I'd also first load into another CAS table and then "swap" the tables in CAS to keep the outage for report consumers to a minimum.   One of the reasons that I'd go for code: It allows you to explicitly defined how to map source to target columns because for example Hive String data types will per default result in a 1024 Varchar CAS column. As a rule of thumb: Don't use CAS Varchar for columns where the max string length is below 16 bytes (use CHAR instead) and also use CHAR where the string length is constant.   Also: If the data is used for reports that mostly show detail data aggregated by some categorical variable (example: transactional data summed by account) then it's also beneficial for report performance to load all the data that belongs to the same value of this categorical variable (example: the same account) onto the same cas node. This is something you can do with code - like the loadTable action ... View more

Thank you so much. ... View more

Thanks a lot ... View more

There is an option in the export wizard to "include dependent objects." Did you check that?  The recommendation is to get your CAS tables set up first in SAS Viya before importing. This way, you should be able to map the LASR tables to the CAS tables.    The promotion documentation for 9.4 starts here. I suggest you review it first, as there are some limitations and things you need to be aware of: https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/n1gs51ocqhoqnvn1a0ovhakhh4wf.htm    See this topic for SAS Viya on the latest release: https://go.documentation.sas.com/doc/en/sasadmincdc/v_053/calcontentmig9x/p13mnsgnyx0dx9n1shq2pezuhn52.htm  ... View more

I compared their permissions and they are the same ... View more

srinivas.007@yahoo.com   sgundala@svb.com   These are my e-mail ids to share the Workshop Materials.     Thanks in advance. ... View more

Thank you all for your help @SASKiwi @JosvanderVelden @Patrick , I will try this first "investigate to what SAS version, modules and clients you actually got access and go from there". ... View more

@BrianGaines  I want to know please if we can code Zero-Shot learning in SAS Guide? If not, can we do that in SAS Enterprise Miner or SAS Viya? ... View more

Please update your post as answered in that case. ... View more

@TSBruce @Madelyn_SAS Thank you so much for your help ... View more

If you run PROC SETINIT inside of Data Builder by opening the Code window for a new query, and clearing out all of the auto-generated code, like this:     Do you see SAS/ACCESS for Hadoop along with the Visual Analytics products?    If so, then I'd suggest opening a ticket with SAS Technical Support at https://service.sas.com/csm?id=sc_category&sys_id=1b8611d5c3921200b0449f2974d3ae12      ... View more

That's the version reported in the SAS Note I posted the link for. There's a hot fix for it. ... View more

thank you so much for your help ... View more