topic how to set Hive tblproperties using sas datestep in SAS Data Management

how to set Hive tblproperties using sas datestep

sarvesh09 — Mon, 25 Jun 2018 14:43:34 GMT

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 — Thu, 05 Jul 2018 22:48:53 GMT

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