how to set Hive tblproperties using sas datestep

[sarvesh09]

Hi,

I need to set some property on hive table under tblproperties. Could anyone please suggest the syntax.

eg:

data datasetname(dbcreate_table_opts="partition by(a text) tblproperties('transactional'='true') );

set dsname;

run. 

[JBailey · Accepted solution]

Hi @sarvesh09

I am not sure that I would trust the author but this paper may help you solve your problem: http://support.sas.com/resources/papers/proceedings17/SAS0409-2017.pdf

Best wishes,

Jeff