topic Re: Global Table cannot be replaced in SAS Viya

Global Table cannot be replaced

Zhteh — Tue, 13 Mar 2018 12:08:27 GMT

Hi,

I was trying to replace the csv file in the cas server using python-swat interface. However, I encounter error with "Global Table cannot be replaced" when I run it.

Below is the code I used to upload the data. Anyone know the reason behind it? Thank you

conn.upload('abc.csv',casout=dict(name='trialupload2',caslib='public',promote = 'true',replace = 'true'))

TRIALUPLOAD2 table is in my cas server, and when I try to replace it, it resulted in the above error.

Re: Global Table cannot be replaced

alexal — Tue, 13 Mar 2018 12:54:19 GMT

@Zhteh,

ERROR: Global tables cannot be replaced.

This is a valid error because "promote" and "replace" cannot be used together.

Re: Global Table cannot be replaced

Zhteh — Tue, 13 Mar 2018 13:10:14 GMT

Hi @alexal,

If that is the case, then may I know is there any workaround for this? because I wish to overwrite the existing data in the CAS server. And if I set the promote to false, the data uploaded won't be visible to me anymore.

Re: Global Table cannot be replaced

alexal — Tue, 13 Mar 2018 13:13:24 GMT

@Zhteh,

Upload the data to your session scope, then promote to the global scope (in a separate action).

Re: Global Table cannot be replaced

Zhteh — Tue, 13 Mar 2018 14:51:58 GMT

@alexal

May I know the proper way of promoting to global scope? Now that with

conn.read_csv('abc.csv',casout=dict(name='trialupload123',caslib='public',replace ='true'))

thiis command I am able to upload to the session scope.

But using when trying to promote to global scope using the below command it fails.
conn.read_csv('abc.csv',casout=dict(name='trialupload123',caslib='public',promote = 'true'))

Re: Global Table cannot be replaced

alexal — Tue, 13 Mar 2018 15:54:14 GMT

@Zhteh,

Something like that:

load_csv = conn.read_csv('https://raw.githubusercontent.com/sassoftware/sas-viya-programming/master/data/cars.csv',casout=dict(name='CARS',caslib='CASUSER',replace ='true'))
promote_csv = conn.promote(load_csv,target='NEW_NAME_FOR_CARS_TABLE')

Re: Global Table cannot be replaced

Zhteh — Tue, 13 Mar 2018 16:07:19 GMT

@alexal

Thanks for the code. However, there is still one problem here. The error exists because the target table of the promotion already exists. Means that I couldn't overwrite the table of the same name in the CAS server.

ERROR: The target table trialupload432 of the promotion already exists. Please specify a different name.

Re: Global Table cannot be replaced

alexal — Tue, 13 Mar 2018 16:55:32 GMT

@Zhteh,

That's correct. You have to choose a new name like I showed above.

Re: Global Table cannot be replaced

BrunoMueller — Wed, 14 Mar 2018 07:45:24 GMT

Try dropping the table first using the dropTable action

Re: Global Table cannot be replaced

Zhteh — Tue, 20 Mar 2018 05:09:28 GMT

thanks for the solution. However, the problem is that the table name in the global scope will be different everytime I upload the data. And in the SAS Studio I will have to access data from different tables every time.

Re: Global Table cannot be replaced

Zhteh — Tue, 20 Mar 2018 05:10:11 GMT

@BrunoMueller,

Thanks. That will do the trick