Hi All,
Has anyone tried reading / importing hive tables in SAS ? The idea is to keep the schema of the tables intact while using them in SAS.
Can anyone help me on this ?
Regards,
Ashib
Do you have sas/access to Hadoop?
Hi Chris,
Thanks for your reply, is it possible to achieve this without SAS/Access ? If we try to read the hive tables by making a connection between SAS and hadoop using proc SQL, will the schema of tables remain intact ?
Meanwhile I will check about the SAS / Access option.
Regards,
Ashib
1. You could use ODBC.
2. I am unsure I understand your concern.
- You won't change anything in Hadoop by just by reading data
- SAS will see the structure that Hadoop presents.
I will try to make it more clear, suppose there is a hive table with datatypes such as bigint etc. and if I make a connection between SAS and hadoop and read this table, will I be able to read the table correctly ?
Regards,
Ashib
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.