DSS and Hadoop

• Setting up Hadoop integration
  • Prerequisites
    • Supported distributions
    • Non officially supported distributions
    • Software install
    • HDFS
    • Hive
  • Testing Hadoop connnectivity prior to installation
    • hive binary
  • Setting up DSS Hadoop integration
    • Test HDFS connection
    • Configure Hive connectivity
    • Configure Impala connectivity
  • Pig support
  • Secure Hadoop connectivity
• Connecting to secure clusters
  • Setup the DSS Kerberos account
  • Configure DSS for Hadoop security
    • Test HDFS connection
    • Configure Hive connectivity
    • Configure Impala connectivity
  • Modification of principal or keytab
  • Advanced settings (optional)
    • Configuring Kerberos credentials periodic renewal
• Hadoop filesystems connections (HDFS, S3, EMRFS, WASB, ADLS, GS)
  • HDFS connections in DSS
    • Managed datasets setup
  • Connecting to the “default” FS
  • Connecting to the HDFS of other clusters
  • Connecting to S3
    • Using S3A
    • Using EMRFS
  • Connecting to Azure Blob Storage
  • Connecting to Google Cloud Storage
  • Connecting to Azure Data Lake Store
  • Additional details
    • Cloud storage credentials
    • Checking access to a Hadoop filesystem
    • Relation to the Hive metastore
• DSS and Hive
  • Interaction with the Hive global metastore
  • Synchronisation to the Hive metastore
    • For external datasets
  • Importing from the Hive metastore
  • Hive execution engines
    • Notebooks and metrics
    • Recipes
      • Hiveserver 2
      • Hive CLI (global metastore)
      • Hive CLI (isolated metastore)
      • Choosing the mode
      • Configuring the mode
  • Support for Hive authentication modes
  • Support for Hive authorization modes
    • No Hive security (DSS regular security)
    • Sentry (DSS regular security)
      • With ACL synchronization (recommended)
      • With permissions inheritance
    • Sentry (DSS multi-user security)
    • Ranger (DSS regular security)
    • Ranger (DSS multi-user security)
    • Storage-based security (DSS regular security)
    • Cloudera-specific note
  • Supported file formats
    • Limitations
  • Internal details
• DSS and Impala
  • Impala connectivity
  • Metastore synchronization
  • Supported formats and limitations
  • Configuring connection to Impala servers
    • Kerberos authentication (secure clusters)
    • LDAP authentication
  • Using Impala to write outputs
    • No Hive authorization (DSS regular security)
    • Sentry (DSS regular security)
      • With ACL synchronization (recommended)
      • With permissions inheritance
    • Sentry (DSS multi-user-security)
    • Switching from write-through-DSS to write-through-Impala
• Hive datasets
  • Use cases
    • Hive views
    • No read access on source files
    • ACID tables (ORC)
    • DATE and DECIMAL data types
  • Creating a Hive dataset
    • New dataset
    • Import
  • Using a Hive dataset
    • Hive recipes
    • Visual recipes with Hive as execution engine
    • Spark recipes
    • Visual recipes with Spark as execution engine
    • Limitations
• Multiple Hadoop clusters
  • Concepts
    • Builtin cluster
    • Additional clusters
    • Managed dynamic clusters
    • Use an additional cluster
      • Per-scenario additional clusters
  • Restrictions
  • Define an additional static cluster
    • Hadoop
    • Hive
    • Impala
    • Spark
  • Add a dynamic additional cluster
  • Use a specific or dynamic cluster for scenarios
    • Use a specific static cluster
    • Use a dynamic cluster
  • Permissions
• Dynamic AWS EMR clusters
  • Prerequisites and limitations
  • Create your first cluster
    • Machine setup
    • AWS credentials
    • Install the plugin
    • Define EMRFS connections
    • Create the cluster and configure it
    • Use your cluster
    • Stop the cluster
  • Using dynamic EMR clusters for scenarios
  • Cluster actions
    • Manual run
    • As part of a scenario
  • Advanced settings
    • Security settings
    • Metastore
    • Tags
    • Misc
• Hadoop multi-user security
• Distribution-specific notes
  • Cloudera CDH
    • Security
      • DSS regular security and Sentry
    • Scala notebook
    • S3 datasets and Spark 2
    • Impala
  • Hortonworks HDP
    • HDP 3.0 support
    • Security
      • DSS regular security and Ranger
      • DSS multi-user-security and Ranger
  • MapR
    • Security
      • Connecting to secure MapR clusters
    • Others
  • Amazon Elastic MapReduce
    • Supported versions
    • Security
    • Deployment scenarios
      • Let DSS dynamically manage one or several EMR clusters
      • Connect DSS to an existing EMR cluster
        • DSS running on one of the cluster nodes
        • DSS outside of the cluster
      • Connect DSS to multiple existing EMR clusters
    • Using EMRFS
      • EMRFS credentials
  • Microsoft Azure HDInsight
    • Tested versions
    • Security
    • Connecting Dataiku DSS to Azure HDInsight
      • DSS running on an edge node managed by HDInsight
        • One-click deployment
        • Using an Azure Resource Management (ARM) template
        • Manual DSS installation
      • DSS running outside of HDInsight
    • Using Dataiku DSS on Azure HDInsight
      • Accessing Dataiku DSS on managed HDInsight edge nodes
      • Operating Dataiku DSS when using managed edge nodes
      • Interacting with cluster storage
  • Google Cloud Dataproc
    • Security
    • Known limitations
    • Connecting DSS to Cloud Dataproc
      • DSS running on one of the cluster nodes
      • DSS outside of the cluster
• Teradata Connector For Hadoop
  • Installation and configuration
  • Usage and Guidelines
  • Limitations