Compare Hive Data and SAS dataset

Reply
Occasional Contributor
Posts: 11

Compare Hive Data and SAS dataset

Hi,

 

I would like to compare the Hive table and SAS dataset

 

Is it possible to do comparison between Hive table and sas dataset?

 

 

Contributor
Posts: 64

Re: Compare Hive Data and SAS dataset

Don't think so, not across systems anyways.

I would bring the hive table into a SAS dataset and compare the two datasets.
Contributor
Posts: 64

Re: Compare Hive Data and SAS dataset

[ Edited ]

Actually, it might be possible .. check out this link. There's syntax that might allow you to setup a sas library which points to the raw text file beneath the hive table. Then you can probably reference it in your proc compare. However since the text file doesn't necessarily have a schema , I"m not quite sure how it would work.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-persist-native-SAS-data-sets-to-Hadoop...

Ask a Question
Discussion stats
  • 2 replies
  • 217 views
  • 0 likes
  • 2 in conversation