How to connect to CDP Impala from R in CDSW
Dear community,
I am writing to you because I have the following problem: How can I connect to impala tables from Cloudera AI Workbench, if I am setting up a session where R 3.x or R 4.x is used. I managed to make the connection using python, but I need to do it using R as well.
I have the connection host, the port, the authentication mechanism. For example, the following python code manages to connect:
"from impala.dbapi
import connect
conn = connect(host='host_name', port=21050, auth_mechanism='GSSAPI', use_ssl=True, kerberos_service_name='impala')
cursor = conn.cursor()"
But I need to achieve the connection now using R in Cloudera Data Science Workbench.
Does anyone know how to translate the above code to R 3.x or R 4.x? I already tried using the 'RImpala' library, but it was removed from the CRAN repository according to https://cran.r-project.org/web/packages/RImpala/index.html.
If anyone has an idea how to help me I would be very grateful.

