Hi, We use SAS EG to run queries for our work. We have recently been provided a Hadoop location to save our datasets. I am looking for a way to capture the space used in that server/library. I use to use the code PROC SQL ;
create table SIZE_AC as
SELECT LIBNAME,
MEMNAME,
FILESIZE FORMAT=SIZEKMG.,
FILESIZE FORMAT=SIZEK.
FROM DICTIONARY.TABLES
WHERE LIBNAME = 'AC'
AND MEMTYPE = 'DATA'
ORDER BY FILESIZE DESC
;QUIT ; to calculate the size before, but it does not work with Hadoop. Any suggestions? Edit: I had an idea of someone looping the Hadoop library and capturing the data size (unless there is a direct way to do it) 1. Copy a table from Hadoop to Work library 2. Capture the size of that table with name in another table 3. Delete the table from work and copy the second table 4. Do while This will give me size of all the tables. It is a very lengthy process specially since I have dozens of tables in Hadoop. Can someone assist me with that code? I do not know Do while loop in SAS EG.
... View more