General
When setting parameters for Spark SQL target connectors in NVP link pairings, make sure the setting of the Conf File Paths property has the correct pathname. QueryGrid heavily depends on this setting when processing data transfers. See Spark SQL Connector and Link Properties.
Kerberos
You can set up QueryGrid to use Kerberos authentication with a Spark SQL target connector. There are two forms of authentication available with Kerberos:
- Username/Password
- The Spark SQL target connector authenticates the username and password against Kerberos before sending the query to the data source.
- Kerberos Keytab
- Spark SQL can be configured to enable Kerberos Keytab authentication.
Perform the following if using a Spark SQL target connector in an NVP link pairing to access a Kerberized Hadoop cluster:
- Select Kerberos for the Authentication Mechanism property.
- Verify the QueryGrid user has permission to run kinit. See Verifying Permission to Run kinit (Spark SQL).