Connector Guide - AWS EMR - Using Apache IceBerg¶
-
SSH to your EMR master node:
Bash -
If you are using JWT for authentication, then you will have to pass the JWT token to the EMR cluster. You can do this by either passing the JWT token directly as a command-line argument or using a file path containing the JWT token.
-
To pass the JWT token directly as a command-line argument, use the following configuration when connecting to the cluster:
Bash -
To use the file path containing the JWT token, use the following configuration:
Bash
-
-
Connecting to Apache Spark Cluster
If you are using JWT, then add the --conf
option from above with JWT while connecting to the cluster
-
For Hadoop catalog,
-
For Glue catalog,
-
If you are using FGAC or OLAC_FGAC, update the
spark.sql.extensions
property in above command as follows:Bash -
Create table and read
-
For Hadoop catalog,
-
For Glue catalog,
-
If you are using FGAC or OLAC_FGAC, update the
spark.sql.extensions
property in above command as follows:Bash -
Create table and read
When using Spark SQL, the query retrieves the metadata from AWS Glue catalog or Hive Metastore, which provides the location of the data in S3. The access to these files is controlled by Privacera.
For running SQL commands, the cluster should have access to the AWS Glue catalog or Hive Metastore.
-
For Hadoop catalog,
-
For Glue catalog,
-
If you are using FGAC or OLAC_FGAC, update the
spark.sql.extensions
property in above command as follows:Bash -
Run spark sql query
- Prev Connector Guide