Verify SAS/ACCESS Interface to Impala

To verify the connection to Impala after the deployment has completed:

1. From SAS Studio, edit and run the following SAS code to verify the LIBNAME statement:
   libname imp impala server="Impala-host-name" database="Impala-database-or-schema-name" user="user-ID" password="user-password";

   libname imp impala server="Impala-host-name" 
   database="Impala-database-or-schema-name" 
   user="user-ID" password="user-password";

   If the connection to Impala was successful, the execution of the LIBNAME statement return results without error.

2. From SAS Studio, edit and run the following SAS code to verify the caslib statement:
   caslib implib datasource=(srctype="impala", username="user-ID", password="user-password", server="Impala-host-name", database="Impala-database-or-schema-name"); proc casutil; list files incaslib="implib"; run;

   caslib implib datasource=(srctype="impala", username="user-ID", 
   password="user-password", server="Impala-host-name", 
   database="Impala-database-or-schema-name");
   
   proc casutil;
   list files incaslib="implib";
   run;
   

   If the connection was successful, the results are the names of the tables in Impala.

If either statement returns an error or if no results are returned, review the SAS/ACCESS README file located at $deploy/sas-bases/examples/data-access/README.md (for Markdown) or $deploy/sas-bases/docs/configuring_sasaccess_and_data_connectors_for_sas_viya_4.htm (for HTML) to determine whether additional configuration steps are required for SAS/ACCESS Interface to Impala.