First time posting. Kind of a general question. Not specific to any code yet. I'm working in the cloudera data science workbench. I need to loop through all of the tables in a hive database and perform a couple simple functions on each table and output a result. The results will be stored in another database. So I'm looking for a way to get a list of the tables available in the database, and then loop through that list. I have version R version 3.5.1 in RStudio, and being in the workbench don't think i can easily upgrade it. I don't seem to be able to install the RJDBC package. That's one solution I've tried.
Any help is much appreciated. Let me know if you need any more info to answer my question.