SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

how to set Hive tblproperties using sas datestep

Accepted Solution Solved
Reply
Senior User
Posts: 1
Accepted Solution

how to set Hive tblproperties using sas datestep

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. 


Accepted Solutions
Solution
2 weeks ago
SAS Employee
Posts: 288

Re: how to set Hive tblproperties using sas datestep

Posted in reply to sarvesh09

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 

View solution in original post


All Replies
Solution
2 weeks ago
SAS Employee
Posts: 288

Re: how to set Hive tblproperties using sas datestep

Posted in reply to sarvesh09

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 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 101 views
  • 0 likes
  • 2 in conversation