Homepage/Cloudera on cloud Runtime7.2.2

(Public Cloud)

Search Documentation

▶︎Cloudera
1. Reference Architectures
▼Cloudera Public Cloud
▶︎Cloudera Private Cloud
▶︎Cloudera Manager
1. Cloudera Manager
▶︎Applications
▶︎Legacy
▶︎

Getting Started
Patterns
Preview Features
Data Catalog
Data Engineering
DataFlow
Data Hub
Data Warehouse
Data Warehouse Runtime
Cloudera AI
Management Console
Operational Database
Replication Manager
Cloudera Manager
CDF for Data Hub
Runtime

«

Filter topics

Cloudera Runtime
▶︎Cloudera Runtime Release Notes
Cloudera Manager Release Notes
▶︎Concepts
▶︎Planning
1. ▶︎Deployment Planning for Cloudera Search
2. ▶︎Planning for Apache Impala
  1. Guidelines for Schema Design
  2. User Account Requirements
▶︎How To
▶︎Troubleshooting
▼Reference

.NET client
A List of S3A Configuration Properties
About Atlas High Availability
About HBase snapshots
About the Off-heap BucketCache
Access HDFS from the NFS Gateway
Access the YARN Web User Interface
Accessing Apache HBase
Accessing Atlas logs
Accessing Avro data files from Spark SQL applications
Accessing AWS
Accessing Cloud Data
Accessing compressed files in Spark
Accessing data stored in Amazon S3 through Spark
Accessing external storage from Spark
Accessing HDFS Files from Spark
Accessing Hive from an external node
Accessing Hive from Spark
Accessing ORC Data in Hive Tables
Accessing ORC files from Spark
Accessing Parquet files from Spark SQL applications
Accessing Spark SQL through the Spark shell
Accessing the Oozie server with a browser
Accessing the Oozie server with the Oozie Client
Accessing the Ranger console
Accessing the Spark History Server
Accessing the tracing web interface
ACID operations
ACL examples
ACLS on HDFS features
Activate read replicas on a table
Activating Hive query editor on Hue UI
Active Directory Settings
Add a custom coprocessor
Add a group
Add a user
Add a ZooKeeper service
Add or edit permissions
Add queues using YARN Queue Manager UI
Add storage directories using Cloudera Manager
Add the HttpFS role
Add the user or group to a pre-defined access policy
Adding a custom banner
Adding a load balancer
Adding a new schema
Adding a Ranger security zone
Adding a tag-based PII policy
Adding a tag-based service
Adding and Configuring Record Reader and Writer Controller Services
Adding and Removing Range Partitions
Adding attributes to Business Metadata
Adding attributes to classifications
Adding schema to Oozie using Cloudera Manager
Adding tag-based policies
Adding the Lily HBase Indexer Service
Adding the Oozie service using Cloudera Manager
Additional Configuration Options for GCS
Additional considerations when configuring TLS/SSL for Oozie HA
Additional HDFS haadmin commands to administer the cluster
Adjust the Solr replication factor for index files stored in HDFS
Admin ACLs
Administering Apache Kudu
Administering Hue
Administering Ranger Reports
Administering Ranger Users, Groups, Roles, and Permissions
Administrative commands
Admission Control and Query Queuing
Admission Control Sample Scenario
Advanced Committer Configuration
Advanced configuration for write-heavy workloads
Advanced erasure coding configuration
Advanced ORC properties
Advanced partitioning
Advantages of Defining a Schema for Production Use
Aggregate and group data
Aggregate functions
Alert Policies Overview
Aliases
Allocating DataNode memory as storage
Already present: FS layout already exists
ALTER DATABASE statement
ALTER MATERIALIZED VIEW REBUILD
ALTER MATERIALIZED VIEW REWRITE
ALTER TABLE statement
ALTER VIEW statement
Altering a table
Altering table properties
Amazon S3 metadata collection
Analytic functions
Apache Atlas Advanced Search language reference
Apache Atlas dashboard tour
Apache Atlas metadata attributes
Apache Atlas metadata collection overview
Apache Atlas Reference
Apache Atlas Statistics reference
Apache Atlas technical metadata migration reference
Apache Hadoop YARN Overview
Apache Hadoop YARN Reference
Apache HBase Overview
Apache Hive 3 architectural overview
Apache Hive 3 tables
Apache Hive content roadmap
Apache Hive key features
Apache Hive Materialized View Commands
Apache Hive Metastore Overview
Apache Hive Overview
Apache Hive Performance Tuning
Apache Hive query basics
Apache Hive-Kafka integration
Apache Impala Overview
Apache Impala Reference
Apache Impala SQL Overview
Apache Impala SQL Reference
Apache Kafka Overview
Apache Knox Authentication
Apache Knox Gateway Overview
Apache Knox Install Role Parameters
Apache Knox Overview
Apache Kudu administration
Apache Kudu architecture in a CDP public cloud deployment
Apache Kudu background maintenance tasks
Apache Kudu concepts
Apache Kudu Design
Apache Kudu Overview
Apache Kudu overview
Apache Kudu schema design
Apache Kudu transaction semantics
Apache Kudu usage limitations
Apache Oozie Reference
Apache Phoenix Frequently Asked Questions
Apache Phoenix Overview
Apache Phoenix Performance Tuning
Apache Phoenix-Hive Usage Examples
Apache Ranger
Apache Ranger Auditing
Apache Ranger Authorization
Apache Spark access to Apache Hive
Apache Spark Overview
Apache Spark Overview
Apache Zeppelin Overview
API operations
APIs for accessing HDFS
Application ACL evaluation
Application ACLs
Application logs' ACLs
Application not running message
Application reservations
Applications and permissions reference
APPX_MEDIAN function
ARRAY complex type
ASCII codec error
Assigning superuser status to an LDAP user
Assigning terms to categories
Associate a table in a non-customized environment without Kerberos
Associate node labels with queues
Associate table in a customized Kerberos environment
Associating Business Metadata attributes with entities
Associating classifications with entities
Associating Tables of a Schema to a Namespace
Associating terms with entities
Atlas
Atlas
Atlas
Atlas classifications drive Ranger policies
Atlas metadata model overview
Audit Overview
Auditing purged entities
Authentication
Authentication tokens
Authentication using Kerberos
Authentication using LDAP
Authentication using SAML
Authorization
Authorization Exception error
Authorization tokens
Authorizing Apache Hive Access
Auto-TLS Agent File Locations
Auto-TLS Requirements and Limitations
Automate partition discovery and repair
Automatic Invalidation of Metadata Cache
Automatic Invalidation/Refresh of Metadata
Automating mode selection
Automating Spark Jobs with Oozie Spark Action
AVG
AVG function
AWS configuration
AWS object lifecycle
AWS objects and inferred hierarchy
AWS S3 Base
AWS S3 Bucket
AWS S3 Contained
AWS S3 Container
AWS S3 Directory
AWS S3 entity metadata migration
AWS S3 Object
Back up a Solr collection
Back up HDFS metadata
Back up HDFS metadata using Cloudera Manager
Backing up and restoring Search
Backing up HDFS metadata
Backing up NameNode metadata
Backing up tables
Backup and restore
Backup directory structure
Backup tools
Balancer commands
Balancing data across an HDFS cluster
Balancing data across disks of a DataNode
Basic partitioning
Basics
Batch Indexing
Batch Indexing into Offline Solr Shards
Batch Indexing into Online Solr Servers Using GoLive
Batch indexing to Solr using SparkApp framework in spark-submit
Before you create an operational database cluster
Behavioral Changes In Cloudera Runtime 7.2.2
Benefits of centralized cache management in HDFS
Best practices for building Apache Spark applications
Best practices for performance tuning
Best practices for rack and node setup for EC
Best practices when adding new tablet servers
Best practices when using RegionServer grouping
BIGINT data type
Bit functions
Block cache size
Block move execution
Block move scheduling
BOOLEAN data type
Bringing a tablet that has lost a majority of replicas back online
Broker garbage log collection and log rotation
Broker log management
Broker migration
Broker Tuning
Brokers
Browse HBase tables
BucketCache IO engine
Build the project and upload the JAR
Building and deploying UDFs
Building and running a Spark Streaming application
Building Cloudera Manager charts with Kafka metrics
Building reusable modules in Apache Spark applications
Building Spark Applications
Building the Java client
Built-in functions
Bulk Write Access
Business Metadata overview
Bypass the BlockCache
Cache eviction priorities
Caching terminology
Call the UDF in a query
Calling Hive user-defined functions (UDFs)
Canary test for pyspark command
Cancelling a Query
Cannot alter compressed tables in Hue
Cannot see databases, or the query editor is missing
Cannot see the DAG ID and the Application ID
Cannot view queries of other users
Catalog operations
Catalog table
CDP Security Overview
Centralized cache management architecture
Change resource allocation mode
Changing a nameservice name for Highly Available HDFS using Cloudera Manager
Changing directory configuration
Changing master hostnames
Changing Ranger audit storage location and migrating data
Changing the page logo
CHAR data type
CHAR data type support
Check Job History
Check Job Status
Choose the right import method
Choosing a DynamoDB Table and IO Capacity
Choosing Data Formats
Choosing the number of partitions for a topic
Choosing Transformations to Minimize Shuffles
ClassNotFoundException: com.cloudera.kudu.hive.KuduStorageHandler
Cleaning up after failed jobs
Cleaning up old data to improve performance
CLI commands to perform snapshot operations
Client and broker compatibility across Kafka versions
Client authentication to secure Kudu clusters
Client authentication using delegation tokens
Client connections to HiveServer
Client examples
Client examples
Close HiveWarehouseSession operations
Cloud storage connectors overview
Cloudera Runtime
Cloudera Runtime Component Versions
Cloudera Runtime Release Notes
Cloudera Runtime Security and Governance
Cloudera Search and CDP
Cloudera Search Architecture
Cloudera Search configuration and log files
Cloudera Search configuration files
Cloudera Search configuration files
Cloudera Search ETL
Cloudera Search log files
Cloudera Search Overview
Cloudera Search security aspects
Cloudera Search solrctl Reference
Cloudera Search Tasks and Processes
Cluster balancing algorithm
Cluster management limitations
Cluster sizing
Coarse-grained authorization
Collecting metrics via HTTP
Column compression
Column design
Column encoding
Columnar datastore
Command Line Tools
Commands for configuring storage policies
Commands for using cache pools and directives
COMMENT statement
Comments
Commit transaction in Spark Direct Reader mode
Common Kudu workflows
Common replication topologies
Common web interface pages
Compacting on-disk data
Compaction of Data in FULL ACID Transactional Table
Compaction prerequisites
Compactor properties
Compare queries
Compare tables using ANY/SOME/ALL
Comparing replication and erasure coding
Comparison of Fair Scheduler with Capacity Scheduler
Compatibility Policies
Completed Hue query shows executing on CM
Complex types
Component Types and Metrics for Alert Policies
Components
Compose queries
Compound operators
Compute
COMPUTE STATS statement
Concepts Used in FULL ACID v2 Tables
Conditional functions
Config templates
Configuration properties
Configurations and CLI options for the HDFS Balancer
Configure a resource-based policy: ADLS
Configure a resource-based policy: Atlas
Configure a resource-based policy: HBase
Configure a resource-based policy: HDFS
Configure a resource-based policy: Hive
Configure a resource-based policy: Kafka
Configure a resource-based policy: Knox
Configure a resource-based policy: NiFi
Configure a resource-based policy: NiFi Registry
Configure a resource-based policy: Solr
Configure a resource-based policy: YARN
Configure a resource-based service: ADLS
Configure a resource-based service: Atlas
Configure a resource-based service: HBase
Configure a resource-based service: HDFS
Configure a resource-based service: Hive
Configure a resource-based service: Kafka
Configure a resource-based service: Knox
Configure a resource-based service: NiFi
Configure a resource-based service: NiFi Registry
Configure a resource-based service: Solr
Configure a resource-based service: YARN
Configure a Spark job for dynamic resource allocation
Configure Access to GCS from Your Cluster
Configure archival storage
Configure Atlas authentication for AD
Configure Atlas authentication for LDAP
Configure Atlas file-based authentication
Configure Atlas PAM authentication
Configure BucketCache IO engine
Configure bulk load replication
Configure clients on a producer or consumer level
Configure clients on an application level
Configure cluster capacity with queues
Configure columns to store MOBs
Configure CPU scheduling and isolation
Configure credentials for Atlas extraction
Configure Cross-Origin Support for YARN UIs and REST APIs
Configure data locality
Configure DataNode memory as storage
Configure Debug Delay
Configure dynamic queue properties
Configure encryption in HBase
Configure four-letter-word commands in ZooKeeper
Configure FPGA scheduling and isolation
Configure HBase for use with Phoenix
Configure HBase garbage collection
Configure HBase in Cloudera Manager to store snapshots in Amazon S3
Configure HBase servers to authenticate with a secure HDFS cluster
Configure HiveServer for ETL using YARN queues
Configure HMS properties for authorization
Configure JMX ephemeral ports
Configure Kafka brokers
Configure Kafka brokers
Configure Kafka clients
Configure Kafka clients
Configure Kerberos authentication for Apache Atlas
Configure Lily HBase Indexer Service to Use Kerberos Authentication
Configure Lily HBase Indexer to use TLS/SSL
Configure Log Aggregation
Configure memory settings
Configure metastore database properties
Configure metastore location and HTTP mode
Configure node labels
Configure NodeManager heartbeat
Configure Oozie client when TLS/SSL is enabled
Configure partitions for transactions
Configure Per Queue Properties
Configure Phoenix-Hive Connector using Cloudera Manager
Configure Phoenix-Spark Connector using Cloudera Manager
Configure placement rules
Configure preemption
Configure queue mapping to use the user name from the application tag using Cloudera Manager
Configure queue ordering policies
Configure Ranger authentication for AD
Configure Ranger authentication for LDAP
Configure Ranger authentication for PAM
Configure Ranger authentication for UNIX
Configure read replicas using Cloudera Manager
Configure RegionServer grouping
Configure Scheduler Properties at the Global Level
Configure secure HBase replication
Configure secure HBase replication
Configure secure replication
Configure snapshots
Configure storage-based authorization
Configure temporary table storage
Configure the blocksize for a column family
Configure the compaction speed using Cloudera Manager
Configure the dynamic resource pool used for exporting and importing snapshots in Amazon S3
Configure the G1GC garbage collector
Configure the graceful shutdown timeout property
Configure the HBase Canary
Configure the HBase client TGT renewal period
Configure the MOB cache using Cloudera Manager
Configure the NFS Gateway
Configure the off-heap BucketCache using Cloudera Manager
Configure the off-heap BucketCache using the command line
Configure the resource-based Ranger service used for authorization
Configure the scanner heartbeat using Cloudera Manager
Configure the storage policy for WALs using Cloudera Manager
Configure the storage policy for WALs using the Command Line
Configure TLS encryption manually for Phoenix Query Server
Configure TLS/SSL for Core Hadoop Services
Configure TLS/SSL for HBase REST Server
Configure TLS/SSL for HBase Thrift Server
Configure TLS/SSL for HBase Web UIs
Configure TLS/SSL for HDFS
Configure TLS/SSL for Oozie
Configure TLS/SSL for YARN
Configure ulimit for HBase using Cloudera Manager
Configure ulimit for HBase using the Command Line
Configure ulimit using Pluggable Authentication Modules using the Command Line
Configure User Impersonation for Access to Hive
Configure User Impersonation for Access to Phoenix
Configure work preserving recovery on NodeManager
Configure work preserving recovery on ResourceManager
Configure YARN ResourceManager high availability
Configure YARN Security for Long-Running Applications
Configure YARN Services API to Manage Long-running Applications
Configure YARN Services using Cloudera Manager
Configure ZooKeeper client shell for Kerberos authentication
Configure ZooKeeper server for Kerberos authentication
Configure Zookeeper TLS/SSL support for Kafka
Configure ZooKeeper TLS/SSL using Cloudera Manager
Configuring a secure Kudu cluster using Cloudera Manager
Configuring a secure Kudu cluster using the command line
Configuring Access to Google Cloud Storage
Configuring Access to S3
Configuring Access to S3 on CDP Private Cloud Base
Configuring Access to S3 on CDP Public Cloud
Configuring ACLs on HDFS
Configuring an external database for Oozie
Configuring and Monitoring Atlas
Configuring and running the HDFS balancer using Cloudera Manager
Configuring and tuning S3A block upload
Configuring and Using Zeppelin Interpreters
Configuring Apache Hadoop YARN High Availability
Configuring Apache Hadoop YARN Log Aggregation
Configuring Apache Hadoop YARN Security
Configuring Apache HBase
Configuring Apache HBase for Apache Phoenix
Configuring Apache HBase High Availability
Configuring Apache Hive
Configuring Apache Kafka
Configuring Apache Spark
Configuring Apache Zeppelin
Configuring Apache ZooKeeper
Configuring Atlas Authentication
Configuring Atlas Authorization
Configuring Atlas Authorization using Ranger
Configuring Atlas using Cloudera Manager
Configuring authentication for long-running Spark Streaming jobs
Configuring authentication with LDAP and Direct Bind
Configuring authentication with LDAP and Search Bind
Configuring Authorization
Configuring block size
Configuring Client Access to Impala
Configuring coarse-grained authorization with ACLs
Configuring concurrent moves
Configuring Data Protection
Configuring Dedicated Coordinators and Executors
Configuring Delegation for Clients
Configuring Directories for Intermediate Data
Configuring dynamic resource allocation
Configuring Dynamic Resource Pool
Configuring Encryption for Specific Buckets
Configuring Event Based Automatic Metadata Sync
Configuring external file authorization
Configuring Fault Tolerance
Configuring for HDFS high availability
Configuring for Kudu Tables
Configuring group permissions
Configuring HBase BlockCache
Configuring HBase MultiWAL
Configuring HBase Snapshots
Configuring HBase to use HDFS HA
Configuring HDFS ACLs
Configuring HDFS High Availability
Configuring HDFS trash
Configuring heterogeneous storage in HDFS
Configuring high availability for Hue
Configuring Hive and Impala for high availability with Hue
Configuring HiveServer high availability
Configuring HMS for high availability
Configuring HSTS for HDFS Web UIs
Configuring HTTPS encryption for the Kudu master and tablet server web UIs
Configuring Hue as a TLS/SSL client
Configuring Hue as a TLS/SSL server
Configuring Impala
Configuring Impala TLS/SSL
Configuring Impala to work with HDFS HA
Configuring Impala Web UI
Configuring JDBC execution mode
Configuring JDBC for Impala
Configuring Kafka ZooKeeper chroot
Configuring Kerberos Authentication
Configuring Kudu's integration with Apache Ranger
Configuring LDAP Authentication
Configuring LDAP on unmanaged clusters
Configuring legacy CREATE TABLE behavior
Configuring Lily HBase Indexer Security
Configuring Livy
Configuring Load Balancer for Impala
Configuring log levels for command line tools
Configuring MariaDB for Oozie
Configuring MultiWAL support using Cloudera Manager
Configuring MySQL for Oozie
Configuring ODBC for Impala
Configuring Oozie
Configuring Oozie data purge settings using Cloudera Manager
Configuring Oozie Sqoop1 Action workflow JDBC drivers
Configuring Oozie to enable MapReduce jobs to read or write from Amazon S3
Configuring oozie to use HDFS HA
Configuring Oozie to use HDFS HA
Configuring Oracle for Oozie
Configuring other CDP components to use HDFS HA
Configuring Per-Bucket Settings
Configuring Per-Bucket Settings to Access Data Around the World
Configuring PostgreSQL for Oozie
Configuring Proxy Users to Access HDFS
Configuring quotas
Configuring Ranger Authentication with UNIX, LDAP, AD, or PAM
Configuring Ranger Authentication with UNIX, LDAP, or AD
Configuring Ranger authorization
Configuring Ranger Authorization for Atlas
Configuring resource-based policies
Configuring resource-based services
Configuring S3Guard
Configuring S3Guard in Cloudera Manager
Configuring SAML authentication on managed clusters
Configuring secure access between Solr and Hue
Configuring Simple Authorization in Atlas
Configuring Spark application logging properties
Configuring Spark application properties in spark-defaults.conf
Configuring Spark Applications
Configuring Spark Direct Reader mode
Configuring Spark on YARN Applications
Configuring the balancer threshold
Configuring the Hive Metastore to use HDFS HA
Configuring the Livy Thrift Server
Configuring the Storage Policy for the Write-Ahead Log (WAL)
Configuring TLS/SSL for Apache Atlas
Configuring TLS/SSL for HBase
Configuring TLS/SSL for Hue
Confirm the election status of a ZooKeeper service
Connect an external database
Connect to Phoenix Query Server
Connect to Phoenix Query Server through Apache Knox
Connecting Hive to BI tools using a JDBC/ODBC driver
Connecting Kafka clients to Data Hub provisioned clusters
Connecting to an Apache Hive endpoint through Apache Knox
Connecting to Apache Phoenix Query Server using the JDBC client
Connecting to Impala Daemon in Impala Shell
Connecting to the Apache Livy Thrift Server
Considerations for backfill inserts
Considerations for Oozie to work with AWS
Considerations for working with HDFS snapshots
Contents of the BlockCache
Control access to queues using ACLs
Controlling Data Access with Tags
Conversion functions
Convert a managed table to external
Convert an HDFS file to ORC
Convert instance directories to configs
Converting from an NFS-mounted shared edits directory to Quorum-Based Storage
Converting Hive CLI scripts to Beeline
Copy Sample Tweets to HDFS
Corruption: checksum error on CFile block
COUNT
COUNT function
Create a Collection for Tweets
Create a Collection in Cloudera Search
Create a Collection in Cloudera Search
Create a CRUD transactional table
Create a Custom Access Policy
Create a Custom Role
Create a custom YARN service
Create a default directory for managed tables
Create a GCP Service Account
Create a Hadoop archive
Create a read-only Admin user (Auditor)
Create a replica of an existing shard
Create a snapshot policy
Create a Solr collection
Create a Sqoop import command
Create a standard YARN service
Create a table for a Kafka stream
Create a temporary table
Create a Test Collection
Create a time-bound policy
Create a topology map
Create a topology script
Create a user-defined function
Create an insert-only transactional table
Create an S3-based external table
Create and Run a Note
Create and use a materialized view
Create and use a partitioned materialized view
CREATE DATABASE statement
Create empty table on the destination cluster
CREATE FUNCTION statement
Create indexer Maven project
CREATE MATERIALIZED VIEW
Create new YARN services using UI
Create partitions dynamically
Create placement rules
CREATE ROLE statement
Create snapshots on a directory
Create snapshots using Cloudera Manager
CREATE TABLE AS SELECT
CREATE TABLE statement
Create the S3Guard Table in DynamoDB
Create the UDF class
CREATE VIEW statement
Creating a group in Hue
Creating a Hue user
Creating a Kafka Topic
Creating a Lily HBase Indexer Configuration File
Creating a Lily HBase Indexer Configuration File
Creating a Morphline Configuration File
Creating a Morphline Configuration File
Creating a new Kudu table from Impala
Creating a Notifier
Creating a table from an Amazon S3 file
Creating a truststore file in PEM format
Creating an Alert Policy
Creating an operational database cluster
Creating Business Metadata
Creating categories
Creating classifications
Creating DynamoDB Access Policy
Creating glossaries
Creating labels
Creating Static Pools
Creating tables
Creating terms
CUME_DIST
Customize dynamic resource allocation settings
Customize interpreter settings in a note
Customize the HDFS home directory
Customizing HDFS
Customizing Per-Bucket Secrets Held in Credential Files
Customizing the Hue web UI
Customizing time zones
DAS
DAS
DAS
DAS architecture
Data Access
Data Access
Data Access
Data Analytics Studio Overview
Data Analytics Studio overview
Data compaction
Data Engineering
Data Engineering
Data migration to Apache Hive
Data protection
Data Stewardship with Apache Atlas
Data storage metrics
Data types
Databases
DataNodes
DataNodes
Date and time functions
DATE data type
DDL statements
Debug Web UI for Catalog Server
Debug Web UI for Impala Daemon
Debug Web UI for StateStore
Decide to use the BucketCache
DECIMAL data type
Decimal type
Decommissioning or permanently removing a tablet server from a cluster
Dedicated Coordinator
Default EXPIRES ON tag policy
Default operational database cluster definition
Defining Apache Atlas enumerations
Defining related terms
Defining what assets to extract metadata for
Delegation token based authentication
Delete a collection
Delete a group
Delete a user
Delete all documents in a collection
Delete data from a table
Delete HBase snapshots from Amazon S3
Delete placement rules
Delete queues
Delete snapshots using Cloudera Manager
DELETE statement
Deleting a Kafka Topic
Deleting a Notifier
Deleting a row
Deleting a schema
Deleting an Alert Policy
Deleting in bulk
Deleting tables
Deletion
DENSE_RANK
Deploy and manage services on YARN
Deploy HBase replication
Deploying and configuring Oozie Sqoop1 Action JDBC drivers
Deployment Planning for Cloudera Search
Deprecation Notices In Cloudera Runtime 7.2.2
Describe a materialized view
DESCRIBE EXTENDED and DESCRIBE FORMATTED
DESCRIBE statement
Detecting slow DataNodes
Determine the table type
Developing and running an Apache Spark WordCount application
Developing Apache Kafka Applications
Developing Apache Spark Applications
Developing Applications with Apache Kudu
Developing applications with Apache Kudu
Diagnostics logging
Dimensioning Guidelines for Deploying Cloudera Search
Disable automatic compaction
Disable loading of coprocessors
Disable RegionServer grouping
Disable replication at the peer level
Disable the BoundedByteBufferPool
Disabling an Alert Policy
Disabling and redeploying HDFS HA
Disabling S3Guard and destroying a table
Disk Balancer commands
Disk management
Disk Removal
Disk Replacement
Disk space usage
Disk space versus namespace
DistCp additional considerations
DistCp and security settings
DistCp between HA clusters
DISTINCT operator
DML statements
DOUBLE data type
Downloading and exporting data from Hue
Drop a materialized view
Drop an external table along with data
DROP DATABASE statement
DROP FUNCTION statement
DROP MATERIALIZED VIEW
DROP ROLE statement
DROP STATS statement
DROP TABLE statement
DROP VIEW statement
Dropping a Kudu table using Impala
Dumping the Oozie database
Dynamic allocation
Dynamic queues
Dynamic resource allocation properties
Dynamic Resource Pool Settings
Dynamic resource-based column masking in Hive with Ranger policies
Dynamic tag-based column masking in Hive with Ranger policies
Dynamically loading a custom filter
Edit a group
Edit a user
Edit or delete a snapshot policy
Edit placement rules
Editing tables
Effects of WAL rolling on replication
Enable Access Control for Data
Enable Access Control for Interpreter, Configuration, and Credential Settings
Enable Access Control for Notebooks
Enable ACL for RegionServer grouping
Enable and disable snapshot creation using Cloudera Manager
Enable asynchronous scheduler
Enable authorization for additional HDFS web UIs
Enable authorization for HDFS web UIs
Enable authorization in Kafka with Ranger
Enable automatic compaction
Enable bulk load replication using Cloudera Manager
Enable Cgroups
Enable Cluster-wide HBase Replication
Enable detection of slow DataNodes
Enable document-level authorization
Enable Garbage Collector Logging
Enable GZipCodec as the default compression codec
Enable HBase high availability using Cloudera Manager
Enable HBase indexing
Enable hedged reads for HBase
Enable Intra-Queue preemption
Enable Intra-Queue Preemption for a specific queue
Enable multi-threaded faceting
Enable namespace mapping
Enable or disable authentication with delegation tokens
Enable override of default queue mappings at individual queue level
Enable Phoenix ACLs
Enable preemption for a specific queue
Enable RegionServer grouping using Cloudera Manager
Enable replication on a specific table
Enable Replication on HBase Column Families
Enable SASL in HiveServer
Enable scheduled queries
Enable server-server mutual authentication
Enable snapshot creation on a directory
Enable the AdminServer
Enable TLS/SSL for HiveServer
Enabling a multi-threaded environment for Hue
Enabling ABFS file browser for Hue configured with IDBroker
Enabling ABFS file browser for Hue configured without IDBroker
Enabling Access Control for Zeppelin Elements
Enabling access to HBase browser from Hue
Enabling Admission Control
Enabling an Alert Policy
Enabling and disabling trash
Enabling core dump for the Kudu service
Enabling fault-tolerant processing in Spark Streaming
Enabling HDFS HA
Enabling High Availability and automatic failover
Enabling Hue applications with Cloudera Manager
Enabling Hue as a TLS/SSL client
Enabling Hue as a TLS/SSL server using Cloudera Manager
Enabling Interceptors
Enabling Kerberos authentication and RPC encryption
Enabling LDAP Authentication for impala-shell
Enabling LDAP authentication with HiveServer2 and Impala
Enabling LDAP in Hue
Enabling Native Acceleration For MLlib
Enabling Oozie SLA with Cloudera Manager
Enabling or disabling anonymous usage date collection
Enabling or disabling impersonation (doas)
Enabling Ranger authorization
Enabling S3 browser for Hue configured with IDBroker
Enabling S3 browser for Hue configured without IDBroker
Enabling Spark authentication
Enabling Spark Encryption
Enabling Speculative Execution
Enabling SSE-C
Enabling SSE-KMS
Enabling SSE-S3
Enabling the Oozie web console on managed clusters
Enabling the SQL editor autocompleter
Enabling TLS/SSL communication with HiveServer2
Enabling TLS/SSL communication with Impala
Enabling TLS/SSL for Hue Load Balancer
Enabling vectorized query execution
Encrypting an S3 Bucket with Amazon S3 Default Encryption
Encrypting Communication
Encrypting Data on S3
Encryption
Encryption Reference
End to End Latency Overview
End to End Latency Use Cases
Enforcing TLS version 1.2 for Hue
Environment variables for sizing NameNode heap memory
Erasure coding CLI command
Erasure coding examples
Erasure coding overview
Errors during hole punching test
Escape an illegal identifier
Essential metrics to monitor
ETL with Cloudera Morphlines
Evolving a schema
Example Morphline Usage
Example of Atlas S3 Lineage
Example use cases
Example workload
Example: Configuration for work preserving recovery
Example: Running SparkPi on YARN
Example: Using the HBase-Spark connector
Examples
Examples of accessing Amazon S3 data from Spark
Examples of controlling data access using classifications
Examples of creating and using UDFs
Examples of DistCp commands using the S3 protocol and hidden credentials
Examples of estimating NameNode heap memory
Examples of Interacting with Schema Registry
Examples of overlapping quota policies
Execute the Disk Balancer plan
Exit statuses for the HDFS Balancer
EXPLAIN statement
Exploring using Lineage
Export a Note
Export a snapshot to another cluster
Export all resource-based policies for all services
Export Ranger reports
Export resource-based policies for a specific service
Export tag-based policies
Exporting query results to Amazon S3
Expose HBase metrics to a Ganglia server
Extending Atlas to Manage Metadata from Additional Sources
External table access
Extracting S3 Metadata using Atlas
Extraction Command
Extractor configuration properties
Failures during INSERT, UPDATE, UPSERT, and DELETE operations
FAQ
Feature comparison
Fetching Spark Maven dependencies
File descriptor limits
File descriptors
Files and directories
Files and directories
Filesystems
Filter HMS results
Filter types
Finding issues
Finding the list of Hue superusers
Finding the list of Hue superusers
Fine-grained authorization
FIRST_VALUE
Fixed Issues In Cloudera Runtime 7.2.2
Fixing a warning related to accessing non-optimized Hue
Fixing authentication issues between HBase and Hue
Fixing issues
FLOAT data type
Flushing data to disk
Format for using Hadoop archives with MapReduce
Functions
General Quota Syntax
General Settings
Generate a collection configuration using configs
Generate a collection configuration using instance directories
Generate and view Apache Hive statistics
Generate surrogate keys
Generating a table list
Generating statistics
Generating Table and Column Statistics
Get scheduled query information and monitor the query
Getting Started with Operational Database
Glossaries overview
Governance
Governance
Governance Overview
Graceful HBase Shutdown
Gracefully shut down an HBase RegionServer
Gracefully shut down the HBase service
GRANT statement
Granting permission to access S3 and ABFS File Browser in Hue
Granularity of Metrics
GROUP BY clause
GROUPING() and GROUPING_ID() functions
Groups and fetching
GROUP_CONCAT function
Guidelines for Schema Design
Hadoop
Hadoop archive components
Hadoop File Formats Support
Handling bucketed tables
Handling disk failures
Handling large messages
Hash and hash partitioning
Hash and range partitioning
Hash partitioning
Hash partitioning
HashTable/SyncTable tool configuration
HAVING clause
HBase
HBase
HBase
HBase
HBase actions that produce Atlas entities
HBase audit entries
HBase Authentication
HBase Authorization
HBase backup and disaster recovery strategies
HBase entities created in Atlas
HBase filtering
HBase I/O components
HBase is using more disk space than expected
Hbase lineage
HBase metadata collection
HBase on CDP
HBase online merge
HBase read replicas
HBase Shell example
HBase snapshots on Amazon S3 with Kerberos enabled
HBaseMapReduceIndexerTool command line reference
HBCK2 tool command reference
HDFS
HDFS
HDFS
HDFS
HDFS ACLs
HDFS Block Skew
HDFS Caching
HDFS commands for metadata files and directories
HDFS entity metadata migration
HDFS Metrics
HDFS Overview
HDFS storage policies
HDFS storage types
HDFS storage types
Heap sampling
Hierarchical queue characteristics
High Availability on HDFS clusters
Hive
Hive
Hive
Hive 3 ACID transactions
Hive Authentication
Hive entity metadata migration
Hive table locations
Hive Warehouse Connector for accessing Apache Spark data
Hive Warehouse Connector Interfaces
HiveServer actions that produce Atlas entities
HiveServer audit entries
HiveServer entities created in Atlas
HiveServer lineage
HiveServer metadata collection
HiveServer relationships
HMS table storage
How Cloudera Search Works
How DAS helps to debug Hive on Tez queries
How NameNode manages blocks on a failed DataNode
How NFS Gateway authenticates and maps users
How tag-based access control works
HttpFS authentication
Hue
Hue
Hue
Hue Advanced Configuration Snippet
Hue configuration files
Hue logs
Hue Overview
Hue supported browsers
HWC API Examples
HWC execution modes
HWC supported types mapping
IAM Role permissions for working with SSE-KMS
Identifiers
Identifying problems
Impact of quota violation policy
Impala
Impala
Impala
Impala actions that produce Atlas entities
Impala audit entries
Impala Authentication
Impala Authorization
Impala database containment model
Impala DDL for Kudu
Impala DML for Kudu Tables
Impala entities created in Atlas
Impala entity metadata migration
Impala integration limitations
Impala lineage
Impala lineage
Impala Logs
Impala metadata collection
Impala Shell Command Reference
Impala Shell Configuration File
Impala Shell Configuration Options
Impala Shell Tool
Impala SQL and Hive SQL
Impala with Amazon S3
Impala with Azure Data Lake Store (ADLS)
Impala with HBase
Impala with HDFS
Impala with Kudu
Import a Note
Import and sync LDAP users and groups
Import command options
Import External Packages
Import RDBMS data into Hive
Import RDBMS data to HDFS
Import resource-based policies for a specific service
Import resource-based policies for all services
Import tag-based policies
Importing a Bucket into S3Guard
Importing and exporting resource-based policies
Importing and exporting tag-based policies
Importing Business Metadata associations in bulk
Importing data into HBase
Importing Glossary terms in bulk
Improving Performance for S3A
Improving performance using partitions
Improving performance with centralized cache management
Improving performance with short-circuit local reads
Improving Software Performance
Increasing StateStore Timeout
Increasing storage capacity with HDFS compression
Increasing the maximum number of processes for Oracle database
Incrementally update an imported table
Index Sample Data
Indexing
Indexing Data
Indexing Data Using Morphlines
Indexing Data Using Spark-Solr Connector
Indexing Sample Tweets with Cloudera Search
Information and debugging
Ingestion
Initiate replication when data already exist
INSERT and primary key uniqueness violations
Insert data into a table
INSERT statement
Inserting a row
Inserting in bulk
Installing Apache Knox
Installing Atlas in HA using CDP Private Cloud Base cluster
Installing Atlas in HA using HDP cluster
Installing Hive on Tez and adding a HiveServer role
Installing NTP-related packages
Installing the REST Server using Cloudera Manager
Installing the UDF development package
INT data type
Integrating Apache Hive with Apache Spark and BI
Integrating Kafka and Schema Registry
Integrating Kafka and Schema Registry Using NiFi Processors
Integrating with Kafka
Integrating with NiFi
Integrating with Schema Registry
Integrating your identity provider's SAML server with Hue
Interacting with Hive views
Internal and external Impala tables
Internal private key infrastructure (PKI)
Introducing the S3A Committers
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction to HDFS metadata files and directories
Introduction to Hive metastore
Introduction to S3Guard
Invalid method name: 'GetLog' error
Invalid query handle
INVALIDATE METADATA statement
ISR management
Issues starting or restarting the master or the tablet server
Java API example
Java client
JBOD
JBOD Disk migration
JBOD setup
JDBC connection string syntax
JDBC connection string syntax
JDBC execution mode
Joins in Impala SELECT statements
JournalNodes
JournalNodes
JVM and garbage collection
Kafka
Kafka
Kafka
Kafka
Kafka Architecture
Kafka brokers and Zookeeper
Kafka clients and ZooKeeper
Kafka consumers
Kafka FAQ
Kafka Introduction
Kafka producers
Kafka public APIs
Kafka security hardening with Zookeeper ACLs
Kafka storage handler and table properties
Kafka Streams
kafka-*-perf-test
kafka-configs
kafka-console-consumer
kafka-console-producer
kafka-consumer-groups
kafka-delegation-tokens
kafka-log-dirs
kafka-reassign-partitions
kafka-topics
Kafka-ZooKeeper performance tuning
Keep replicas current
Kerberos
Kerberos authentication
Kerberos configurations for HWC
Kernel stack watchdog traces
Key Differences between INSERT-ONLY and FULL ACID Tables
Known issue: Ranger group mapping
Known issues and limitations
Known issues and limitations
Known Issues In Cloudera Runtime 7.2.2
Knox
Knox
Knox
Knox Supported Services Matrix
Kudu
Kudu
Kudu
Kudu
Kudu authentication with Kerberos
Kudu example applications
Kudu integration with Spark
Kudu master web interface
Kudu metrics
Kudu network architecture
Kudu Python client
Kudu security
Kudu tablet server web interface
Kudu tracing
Kudu web interfaces
Kudu-Impala integration
LAG
LAST_VALUE
Launch a YARN service
Launch Zeppelin
LAZY_PERSIST memory storage policy
LDAP authentication
LDAP properties
LDAP Settings
LEAD
Leader positions and in-sync replicas
Lengthy BalancerMember Route length
Leveraging Business Metadata
Lily HBase Batch Indexing for Cloudera Search
Lily HBase Near Real Time Indexing for Cloudera Search
LIMIT clause
Limit concurrent connections
Limit CPU usage with Cgroups
Limitations and restrictions for Impala UDFs
Limitations of Amazon S3
Limitations of erasure coding
Limitations of Phoenix-Hive Connector
Limitations of the S3A Committers
Limiting the Speed of Compactions
Lineage lifecycle
Lineage overview
Linux Container Executor
List files in Hadoop archives
Listing available metrics
Literals
Live write access
Livy API reference for batch jobs
Livy API reference for interactive sessions
Livy batch object
Livy objects for interactive sessions
LOAD DATA statement
Loading ORC data into DataFrames using predicate push-down
Loading the Oozie database
Log Aggregation File Controllers
Log Aggregation Properties
Log cleaner
Log redaction
Logging Extractor Activity
Logical operators, comparison operators and comparators
Logical replication
Logs and log segments
Low-latency analytical processing
Maintenance manager
Manage databases and tables
Manage HBase snapshots on Amazon S3 in Cloudera Manager
Manage HBase snapshots using Cloudera Manager
Manage HBase snapshots using the Command Line
Manage individual delegation tokens
Manage partition retention time
Manage partitions
Manage Policies for HBase snapshots in Amazon S3
Manage queries
Manage query rewrites
Manage Queues
Manage Ranger authorization in Solr
Manage reports
Manage the YARN service life cycle through the REST API
Management basics
Managing Access Control Lists
Managing Alert Policies and Notifiers
Managing Alert Policies using Streams Messaging Manager
Managing and Allocating Cluster Resources using Capacity Scheduler
Managing Apache Hadoop YARN Services
Managing Apache HBase
Managing Apache HBase Security
Managing Apache Hive
Managing Apache Impala
Managing Apache Kafka
Managing Apache Phoenix Security
Managing Apache Phoenix Security
Managing Apache ZooKeeper
Managing Apache ZooKeeper Security
Managing Auditing with Ranger
Managing Business Terms with Atlas Glossaries
Managing Cloudera Search
Managing collection configuration
Managing collections
Managing columns
Managing Data Storage
Managing Hue permissions
Managing Kafka Topics using Streams Messaging Manager
Managing Kudu with Cloudera Manager
Managing Logs
Managing Metadata in Impala
Managing Metadata in Impala
Managing partitions
Managing Resources in Impala
Managing snapshot policies using Cloudera Manager
Managing tables
Managing topics across multiple Kafka clusters
Managing YARN queue users
Manually configuring SAML authentication
Manually failing over to the standby NameNode
MAP complex type
Mapping Phoenix Schemas to HBase Namespaces
MapReduce Indexing
MapReduce Job ACLs
MapReduceIndexerTool
MapReduceIndexerTool Input Splits
MapReduceIndexerTool Metadata
MapReduceIndexerTool Usage Syntax
Master
Mathematical functions
Maven artifacts
Maven Artifacts for Cloudera Runtime 7.2.2
MAX
MAX function
Maximizing storage resources using ORC
Memory
Memory limits
Merge data in tables
Merge process stops during Sqoop incremental imports
Metrics
Metrics and Insight
Migrate brokers by modifying broker IDs in meta.properties
Migrate Solr replicas
Migrating Data from Cloudera Navigator to Atlas
Migrating Data Using Sqoop
Migrating Kudu data from one directory to another on the same host
Migrating to multiple Kudu masters
Migration from Fair Scheduler to Capacity Scheduler
Migration Guide
MIN
MIN function
Minimizing cluster disruption during temporary planned downtime of a single tablet server
Miscellaneous functions
MOB cache properties
Modify a Kafka Topic
Modify GCS Bucket Permissions
Modify interpreter settings
Modifying a collection configuration generated using an instance directory
Modifying Impala Startup Options
Modifying Impala Startup Options
Monitor blocksize metrics
Monitor RegionServer grouping
Monitor the BlockCache
Monitor the performance of hedged reads
Monitoring
Monitoring and Debugging Spark Applications
Monitoring and Maintaining S3Guard
Monitoring Brokers
Monitoring cluster health with ksck
Monitoring Clusters
Monitoring Consumers
Monitoring End-to-end Latency
Monitoring End-to-End Latency using Streams Messaging Manager
Monitoring heap memory usage
Monitoring Impala
Monitoring Kafka Clusters using Streams Messaging Manager
Monitoring NTP status
Monitoring Producers
Monitoring Topics
More Resources
Move HBase Master Role to another host
Moving a NameNode to a different host using Cloudera Manager
Moving data from databases to Apache Hive
Moving data from HDFS to Apache Hive
Moving highly available NameNode, failover controller, and JournalNode roles using the Migrate Roles wizard
Moving NameNode roles
Moving the JournalNode edits directory for a role group using Cloudera Manager
Moving the JournalNode edits directory for a role instance using Cloudera Manager
Multi-server LDAP/AD autentication
Multilevel partitioning
MySQL: 1040, 'Too many connections' exception
NameNode architecture
NameNodes
NameNodes
NDV function
Near Real Time Indexing
Network and I/O threads
Networking parameters
Next steps
Non-covering range partitions
Notes about replication
Notifiers
NTILE
NTP clock synchronization
NTP configuration best practices
Number-of-Regions Quotas
Number-of-Regions Quotas
Number-of-Tables Quotas
Off-heap BucketCache
OFFSET clause
On-demand Metadata
On-demand Metadata
Oozie
Oozie
Oozie
Oozie configurations with CDP services
Oozie database configurations
Oozie scheduling examples
Operating system requirements
Operational Database
Operational Database
Operational Database
Operational database cluster
Operators
Optimizer hints
Optimizing data storage
Optimizing HBase I/O
Optimizing NameNode disk space with Hadoop archives
Optimizing performance
Optimizing performance for evaluating SQL predicates
Optimizing queries using partition pruning
Optimizing S3A read performance for different file types
Options to determine differences between contents of snapshots
ORC vs Parquet in CDP
Orchestrating a rolling restart with no downtime
ORDER BY clause
Other known issues
OVER
Overview
Overview
Overview
Overview
Overview of Hadoop archives
Overview of HDFS
Overview of Oozie
Packaging different versions of libraries with an Apache Spark application
PAM Authentication
Parameters to configure the Disk Balancer
Partition a cluster using node labels
Partition pruning
Partition Pruning for Queries
Partitioning
Partitioning
Partitioning examples
Partitioning for Kudu Tables
Partitioning guidelines
Partitioning limitations
Partitioning tables
Partitions
Partitions introduction
PERCENT_RANK
Perform a backup of the HDFS metadata
Perform ETL by ingesting data from Kafka into Hive
Perform hostname changes
Perform scans using HBase Shell
Perform the migration
Perform the recovery
Perform the removal
Performance and storage considerations for Spark SQL DROP TABLE PURGE
Performance Best Practices
Performance considerations
Performance Considerations
Performance considerations for UDFs
Performance Impact of Encryption
Performance tuning
Performant .NET producer
Periodically rebuild a materialized view
Phoenix
Phoenix
Phoenix
Phoenix
Phoenix Overview
Phoenix-Spark Connector usage examples
Physical backups of an entire node
Physical backups of an entire node
Plan the data movement across disks
Planning for Apache Impala
Populating an HBase Table
Populating an S3 bucket
Ports Used by Impala
POST /admin/audit/ API
Pre-defined Access Policies for Schema Registry
Predicate push-down optimization
Preloaded resource-based services and policies
Prepare for hostname changes
Prepare for removal
Prepare for the migration
Prepare for the recovery
Prepare to back up the HDFS metadata
Preparing the hardware resources for HDFS High Availability
Preparing the S3 Bucket
Preparing to Index Sample Tweets with Cloudera Search
Prerequisites
Prerequisites
Prerequisites for configuring short-ciruit local reads
Prerequisites for configuring TLS/SSL for Oozie
Prerequisites for enabling erasure coding
Prerequisites for enabling HDFS HA using Cloudera Manager
Prerequisites for setting up Atlas HA
Prerequisites to configure TLS/SSL for HBase
Preventing inadvertent deletion of directories
Previewing tables using Data Preview
Primary key design
Primary key index
Problem area: Compose page
Problem area: Queries page
Problem area: Reports page
Propagating classifications through lineage
Properties for configuring centralized caching
Properties for configuring short-circuit local reads on HDFS
Properties for configuring the Balancer
Properties to set the size of the NameNode edits directory
Protocol between consumer and broker
Provision an operational database cluster
Proxy Cloudera Manager through Apache Knox
Pruning Old Data from S3Guard Tables
Purging deleted entities
PUT /admin/purge/ API
Queries are not appearing on the Queries page
Query column is empty but you can see the DAG ID and Application ID
Query correlated data
Query Join Performance
Query live data from Kafka
Query options
Query Sample Data
Query the information_schema database
Query vectorization
Querying
Querying a schema
Querying an existing Kudu table from Impala
Querying files into a DataFrame
Querying Kafka data
Queue ACLs
Quota enforcement
Quota violation policies
Quotas
Rack awareness (Location awareness)
Raft consensus algorithm
Range partitioning
Range partitioning
Ranger
Ranger
Ranger
Ranger
Ranger access conditions
Ranger AD Integration
Ranger client caching
Ranger console navigation
Ranger Policies Overview
Ranger Security Zones
Ranger tag-based policies
Ranger UI authentication
Ranger UI authorization
Ranger user management
Ranger Usersync
RANK
Read access
Read and write operations
Read operations (scans)
Read replica properties
READ Support for FULL ACID ORC Tables
Reading data from HBase
Reading Hive ORC tables
Reading managed tables through HWC
Reads (scans)
REAL data type
Reassigning replicas between log directories
Reassignment examples
Rebalancing partitions
Rebuilding a Kudu filesystem layout
Recommendations for client development
Recommended configurations for the Balancer
Recommended configurations for the balancer
Recommended settings for G1GC
Record management
Record order and assignment
Records
Recover data from a snapshot
Recovering from a dead Kudu master in a multi-master deployment
Recovering from disk failure
Recovering from full disks
Redeploying the Oozie ShareLib
Redeploying the Oozie sharelib using Cloudera Manager
Reducing the Size of Data Structures
Refer to a table using dot notation
Reference architecture
Referencing S3 Data in Applications
Refining query search using filters
REFRESH AUTHORIZATION statement
REFRESH FUNCTIONS statement
REFRESH statement
Register the UDF
Registering a Lily HBase Indexer Configuration with the Lily HBase Indexer Service
Reload, view, and filter functions
Remove a DataNode
Remove a RegionServer from RegionServer grouping
Remove or add storage directories for NameNode data directories
Remove storage directories using Cloudera Manager
Removing Kudu masters from a multi-master deployment
Removing scratch directories
Reorder placement rules
Repair partitions manually using MSCK repair
Replace a ZooKeeper disk
Replace a ZooKeeper role on an unmanaged cluster
Replace a ZooKeeper role with ZooKeeper service downtime
Replace a ZooKeeper role without ZooKeeper service downtime
Replicate pre-exist data in an active-active deployment
Replication
Replication across three or more clusters
Replication caveats
Replication requirements
Reporting Kudu crashes using breakpad
Request a timeline-consistent read
Reserved words
Resetting Hue user password
Resource allocation overview
Resource distribution workflow
Resource Scheduling and Management
Resource Tuning Example
Resource-based Services and Policies
Restore a Solr collection
Restore an HBase snapshot from Amazon S3
Restore an HBase snapshot from Amazon S3 with a new name
Restore data from a replica
Restore HDFS metadata from a backup using Cloudera Manager
Restoring NameNode metadata
Restoring tables from backups
Restrict access to Kafka metadata in Zookeeper
Restricting Access to S3Guard Tables
Restricting supported ciphers for Hue
Retries
Retrieving log directory replica assignment information
REVOKE statement
Rotate Auto-TLS Certificate Authority and Host Certificates
Rotate the master key/secret
Row-level filtering and column masking in Hive
Row-level filtering in Hive with Ranger policies
ROW_NUMBER
RPC timeout traces
Run a Hive command
Run the spark-submit job
Running a Spark MLlib example
Running a tablet rebalancing tool in Cloudera Manager
Running a tablet rebalancing tool on a rack-aware cluster
Running an interactive session with the Livy API
Running Apache Spark Applications
Running bulk extraction
Running Commands and SQL Statements in Impala Shell
Running HBaseMapReduceIndexerTool
Running incremental extraction
Running PySpark in a virtual environment
Running sample Spark applications
Running shell commands
Running Spark applications on secure clusters
Running Spark applications on YARN
Running Spark Python applications
Running tablet rebalancing tool
Running the balancer
Running the HBCK2 tool
Running YARN Services
Running your first Spark application
Runtime environment for UDFs
Runtime error: Could not create thread: Resource temporarily unavailable (error 11)
Runtime Filtering
S3 actions that produce or update Atlas entities
S3 entities created in Atlas
S3 entity audit entries
S3 Extractor configuration
S3 Performance Checklist
S3 relationships
S3A and Checksums (Advanced Feature)
S3Guard: Operational Issues
Safely Writing to S3 Through the S3A Committers
SAML properties
Sample pom.xml file for Spark Streaming with Kafka
Save a YARN service definition
Saving searches
Saving the search results
Scalability
Scalability Considerations
Scaling Kudu
Scaling Limits and Guidelines
Scaling recommendations and limitations
Scaling storage on Kudu master and tablet servers in the cloud
Scheduler performance improvements
Scheduling among queues
Scheduling in Oozie using cron-like syntax
Scheduling queries
Schema alterations
Schema design limitations
Schema design limitations
Schema Entities
Schema objects
Schema Registry
Schema Registry
Schema Registry
Schema Registry Authorization through Ranger Access Policies
Schema Registry Component Architecture
Schema Registry Concepts
Schema Registry Overview
Schema Registry Overview
Schema Registry Use Cases
Schemaless Mode Overview and Best Practices
Script with HBase Shell
Search
Search
Search
Search and Other Runtime Components
Search applications
Search Ranger reports
Search Tutorial
Searching for entities using Business Metadata attributes
Searching for entities using classifications
Searching metadata tags
Searching overview
Searching queries
Searching tables
Searching using terms
Searching with Metadata
Secondary Sort
Secure configs with ZooKeeper ACLs and Ranger
Secure Hive Metastore
Secure HiveServer using LDAP
Secure-to-secure: Kerberos principal name
Secure-to-secure: ResourceManager mapping rules
Securing Access to Hadoop Cluster: Apache Knox
Securing Apache Hive
Securing Apache Kafka
Securing Atlas
Securing Atlas
Securing Cloudera Search
Securing database connections with TLS/SSL
Securing Hue
Securing Hue passwords with scripts
Securing Impala
Securing Schema Registry
Securing sessions
Securing Streams Messaging Manager
Securing Streams Messaging Manager
Securing the S3A Committers
Security
Security considerations
Security considerations for UDFs
Security examples
Security examples
Security limitations
Security Model and Operations on S3
SELECT statement
Server management limitations
Services backed by PostgreSQL fail or stop responding
Set Application-Master resource-limit for a specific queue
Set consumer and producer properties as table properties
Set default Application Master resource limit
Set global application limits
Set global maximum application priority
Set Maximum Application limit for a specific queue
Set Ordering policies within a specific queue
Set properties in Cloudera Manager
Set quotas using Cloudera Manager
SET statement
Set up a JDBC URL connection override
Set up a PostgreSQL database
Set up a storage policy for HDFS
Set up an Oracle database
Set up JDBCStorageHandler for Postgres
Set up MariaDB or MySQL database
Set up MirrorMaker in Cloudera Manager
Set Up Sqoop
Set up SSD storage using Cloudera Manager
Set up the backend Hive metastore database
Set up the cost-based optimizer and statistics
Set up the development environment
Set up WebHDFS on a secure cluster
Set user limits within a queue
Setting HDFS quotas
Setting Java System Properties for Solr
Setting Lucene Version
Setting Oozie permissions
Setting Python path variables for Livy
Setting the cache timeout
Setting the Idle Query and Idle Session Timeouts
Setting the Oozie database timezone
Setting the trash interval
Setting Timeout and Retries for Thrift Connections to Backend Client
Setting Timeouts in Impala
Setting up Atlas High Availability
Setting up Data Cache for Remote Reads
Setting up Data Cache for Remote Reads
Setting Up HDFS Caching
Setting up the HortonworksSchemaRegistry Controller Service
Setting up the metastore database
Setting User Limits for HBase
Setting user limits for Kafka
Settings to avoid data loss
Shell commands
Shiro Settings: Reference
shiro.ini Example
Show materialized views
SHOW MATERIALIZED VIEWS
SHOW statement
Showing Atlas Server status
SHUTDOWN statement
Simple .NET consumer
Simple .NET producer
Simple Java consumer
Simple Java producer
Single tablet write operations
Size the BlockCache
Sizing estimation based on network and disk message throughput
Sizing NameNode heap memory
Slow name resolution and nscd
SMALLINT data type
Snapshot failures
Solr
Solr and HDFS - the Block Cache
Solr Server Tuning Categories
solrctl Reference
Space quotas
Spark
Spark
Spark
Spark actions that produce Atlas entities
Spark application model
Spark audit entries
Spark cluster execution overview
Spark Direct Reader mode
Spark entities created in Apache Atlas
Spark entity metadata migration
Spark execution model
Spark Indexing
Spark integration best practices
Spark integration known issues and limitations
Spark integration limitations
Spark Job ACLs
Spark lineage
Spark metadata collection
Spark on YARN deployment modes
Spark relationships
Spark security
Spark SQL example
Spark Streaming and Dynamic Allocation
Spark Streaming Example
Spark troubleshooting
Spark tuning
spark-submit command options
Specify the JDBC connection string
Specifying domains or pages to which Hue can redirect users
Specifying HTTP request methods
Specifying Impala Credentials to Access S3
Speeding up Job Commits by Increasing the Number of Threads
Spooling Query Results
SQL migration
SQL statements
SQLContext and HiveContext
Sqoop
Sqoop
Sqoop
Sqoop Hive import stops when HS2 does not use Kerberos authentication
SSE-C: Server-Side Encryption with Customer-Provided Encryption Keys
SSE-KMS: Amazon S3-KMS Managed Encryption Keys
SSE-S3: Amazon S3-Managed Encryption Keys
Start and stop queues
Start and stop the NFS Gateway services
Start compaction manually
Start HBase
Start Hive on an insecure cluster
Start Hive using a password
Starting and Stopping HBase using Cloudera Manager
Starting and stopping Kudu processes
Starting Apache Hive
Starting the Lily HBase NRT Indexer Service
Starting the Oozie server
Stateless Mode and High Availability
Statistics generation and viewing commands
STDDEV, STDDEV_SAMP, STDDEV_POP functions
Step 1: Generate keys and certificates for Kafka brokers
Step 1: Worker host configuration
Step 2: Create your own certificate authority
Step 2: Worker host planning
Step 3: Cluster size
Step 3: Sign the certificate
Step 4: Configure Kafka brokers
Step 5: Configure Kafka clients
Step 6: Verify container settings on cluster
Step 6A: Cluster container capacity
Step 6B: Container sanity checking
Step 7: MapReduce configuration
Step 7A: MapReduce sanity checking
Steps 4 and 5: Verify settings
Stop HBase
Stop replication in an emergency
Stopping Impala
Stopping the Oozie server
Storage
Storage
Storage group classification
Storage group pairing
Storage Systems Supports
Storage-based operation permissions
Store HBase snapshots on Amazon S3
Storing Medium Objects (MOBs)
Streams Messaging
Streams Messaging
Streams Messaging Manager
Streams Messaging Manager
Streams Messaging Manager
Streams Messaging Manager Overview
Streams Messaging Manager Overview
STRING data type
String functions
STRUCT complex type
Submit a Python app
Submit a Scala or Java application
Submit Oozie Jobs in Data Engineering Cluster
Submitting batch applications using the Livy API
Submitting Spark applications
Submitting Spark Applications to YARN
Submitting Spark applications using Livy
Subqueries in Impala SELECT statements
Subquery restrictions
Subscribing to a topic
SUM
SUM function
Supported special characters
Switching from CMS to G1GC
Symbolizing stack traces
Synchronize table data using HashTable/SyncTable tool
System Level Broker Tuning
System metadata migration
Table
Table and Column Statistics
Tables
TABLESAMPLE clause
Tablet
Tablet history garbage collection and the ancient history mark
Tablet server
Tag-based Services and Policies
Tags and policy evaluation
Take a snapshot using a shell script
Take HBase snapshots
Terms
Test MOB storage and retrieval performance
Testing the LDAP configuration
The certmanager utility
The Cloud Storage Connectors
The HDFS mover command
The Hue load balancer not distributing users evenly across various Hue servers
The perfect schema
The S3A Committers and Third-Party Object Stores
Thread Tuning for S3A Data Upload
Threads
Thrift Server crashes after receiving invalid data
Throttle quota examples
Throttle quotas
Timeline consistency
TIMESTAMP compatibility for Parquet files
TIMESTAMP data type
TINYINT data type
TLS
To configure an S3 bucket to publish events
To configure an SQS queue suitable for Atlas extraction
Tombstoned or STOPPED tablet replicas
Tool usage
Top-down process for adding a new metadata source
Topics
Tracking an Apache Hive query in YARN
Tracking Hive on Tez query execution
Transactional table access
Transactions
Transactions
Transitioning Navigator content to Atlas
Trash behavior with HDFS Transparent Encryption enabled
Troubleshoot RegionServer grouping
Troubleshooting
Troubleshooting Apache Hadoop YARN
Troubleshooting Apache HBase
Troubleshooting Apache Hive
Troubleshooting Apache Impala
Troubleshooting Apache Kudu
Troubleshooting Apache Kudu
Troubleshooting Apache Sqoop
Troubleshooting Cloudera Search
Troubleshooting Data Analytics Studio
Troubleshooting Docker on YARN
Troubleshooting HBase
Troubleshooting Hue
Troubleshooting Impala
Troubleshooting Linux Container Executor
Troubleshooting NTP stability problems
Troubleshooting performance issues
Troubleshooting replication failure in the DAS Event Processor
Troubleshooting S3 and S3Guard
Troubleshooting SAML authentication
Troubleshooting the S3A Committers
TRUNCATE TABLE statement
Trusted users
Tuning Apache Hadoop YARN
Tuning Apache Kafka Performance
Tuning Apache Spark
Tuning Apache Spark Applications
Tuning Cloudera Search
Tuning Garbage Collection
Tuning Hue
Tuning Impala
Tuning Replication
Tuning Resource Allocation
Tuning S3A Uploads
Tuning Spark Shuffle Operations
Tuning the metastore
Tuning the Number of Partitions
Turning safe mode on HA NameNodes
Tutorial
UDF concepts
UI Tools
Unable to alter S3-backed tables
Unable to authenticate users in Hue using SAML
Unable to connect to database with provided credential
Unable to view new databases and tables, or unable to see changes to the existing databases or tables
Unable to view Snappy-compressed files
Understanding --go-live and HDFS ACLs
Understanding erasure coding policies
Understanding HBase Garbage Collection
Understanding Hue users and groups
Understanding NiFi Record Based Processing
Understanding Performance using EXPLAIN Plan
Understanding Performance using Query Profile
Understanding Performance using SUMMARY Report
Understanding the extractHBaseCells Morphline Command
Understanding the extractHBaseCells Morphline Command
Understanding the kafka-run-class Bash Script
Understanding YARN architecture
UNION, INTERSECT, and EXCEPT clauses
Unlock Kafka metadata in Zookeeper
Unsupported Apache Spark Features
Unsupported command line tools
Unsupported Interfaces and Features
Update and overwrite
Update data in a table
UPDATE statement
Update the schema in a collection
Updating a Notifier
Updating a row
Updating an Alert Policy
Updating in bulk
Uploading tables
Upsert option in Kudu Spark
UPSERT statement
Upserting a row
Usability issues
Use a CTE in a query
Use a custom MapReduce job
Use a subquery
Use BulkLoad
Use Case 1: Registering and Querying a Schema for a Kafka Topic
Use Case 2: Reading/Deserializing and Writing/Serializing Data from and to a Kafka Topic
Use Case 3: Dataflow Management with Schema-based Routing
Use cases
Use cases for ACLs on HDFS
Use cases for BulkLoad
Use cases for centralized cache management
Use cases for HBase
Use Cgroups
Use cluster replication
Use CopyTable
Use CPU scheduling
Use CPU scheduling with distributed shell
Use curl to access a URL protected by Kerberos HTTP SPNEGO
Use custom JAR files with Search
Use dfs.datanode.max.transfer.threads with Hbase
Use DNS with HBase
Use FPGA scheduling
Use FPGA with distributed shell
Use GZipCodec with a one-time job
Use HashTable and SyncTable Tool
Use HWC for streaming
Use materialized view optimations from a subquery
Use multiple ZooKeeper services
Use node labels
Use rsync to copy files from one broker to another
Use snapshots
Use Spark
Use Sqoop
USE statement
Use the Apache Thrift Proxy API
Use the HBase APIs for Java
Use the HBase command-line utilities
Use the HBase REST server
Use the HBase shell
Use the Hue HBase app
Use the JDBC interpreter to access Hive
Use the JDBC interpreter to access Phoenix
Use the Livy interpreter to access Spark
Use the Network Time Protocol (NTP) with HBase
Use the YARN CLI to View Logs for Applications
Use the YARN REST APIs to manage applications
Use the yarn rmadmin tool to administer ResourceManager high availability
Use wildcards with SHOW DATABASES
User Account Requirements
User authentication in Hue
User management in Hue
User-defined functions (UDFs)
Using --go-live with SSL or Kerberos
Using a credential provider to secure S3 credentials
Using advanced search
Using Amazon S3 with Hue
Using Apache HBase Backup and Disaster Recovery
Using Apache Hive
Using Apache Impala with Apache Kudu
Using Apache Impala with Apache Kudu
Using Apache Phoenix to Store and Access Data
Using Apache Phoenix-Hive connector
Using Apache Phoenix-Spark connector
Using Apache Zeppelin
Using Avro Data Files
Using Azure Data Lake Storage Gen2 with Hue
Using Basic Search
Using Breakpad Minidumps for Crash Reporting
Using chrony for time synchronization
Using CLI commands to create and list ACLs
Using Cloudera Manager to manage HDFS HA
Using cluster names in the kudu command line tool
Using common table expressions
Using Configuration Properties to Authenticate
Using constraints
Using custom libraries with Spark
Using Data Analytics Studio
Using DistCp
Using DistCp to copy files
Using DistCp with Amazon S3
Using EC2 Instance Metadata to Authenticate
Using Environment Variables to Authenticate
Using erasure coding for existing data
Using erasure coding for new data
Using Free-text Search
Using functions
Using governance-based data discovery
Using HBase Blocksize
Using HBase Coprocessors
Using HBase Replication
Using HBase Scanner Heartbeat
Using HDFS snapshots for data protection
Using Hedged Reads
Using Hive Warehouse Connector with Oozie Spark Action
Using HttpFS to provide access to HDFS
Using Hue
Using Hue
Using Impala to query Kudu tables
Using JDBC API with Apache Phoenix
Using JdbcStorageHandler to query RDBMS
Using JdbcStorageHandler to query RDBMS
Using JMX for accessing HDFS metrics
Using Kafka's inter-broker security
Using Livy with interactive notebooks
Using Livy with Spark
Using Load Balancer with HttpFS
Using MapReduce Batch Indexing to Index Sample Tweets
Using materialized views
Using metadata for cluster governance
Using ORC Data Files
Using Parquet Data Files
Using Per-Bucket Credentials to Authenticate
Using PySpark
Using quota management
Using rack awareness for read replicas
Using Ranger to Provide Authorization in CDP
Using RCFile Data Files
Using Record-Enabled Processors
Using RegionServer Grouping
Using S3Guard for Consistent S3 Metadata
Using Schema Registry
Using Search filters
Using SequenceFile Data Files
Using solrctl with an HTTP proxy
Using Spark Hive Warehouse and HBase Connector Client .jar files with Livy
Using Spark MLlib
Using Spark SQL
Using Spark Streaming
Using Spark with a secure Kudu cluster
Using Sqoop actions with Oozie
Using tag attributes and values in Ranger tag-based policy conditions
Using Text Data Files
Using the Charts Library with the Kudu service
Using the Cloudera Runtime Maven Repository
Using the Database Explorer
Using the Directory Committer in MapReduce
Using the HBase-Spark connector
Using the HBCK2 tool to remediate HBase clusters
Using the Indexer HTTP Interface
Using the Lily HBase NRT Indexer Service
Using the Livy API to run Spark jobs
Using the NFS Gateway for accessing HDFS
Using the Note Toolbar
Using the Ranger Console
Using the REST API
Using the REST Proxy API
Using the S3Guard CLI
Using the S3Guard Command to List and Delete Uploads
Using the Spark DataFrame API
Using Unique Filenames to Avoid File Update Inconsistency
Using YARN Web UI and CLI
Using Zeppelin Interpreters
UTF-8 codec error
Validating the Cloudera Search Deployment
VALUES statement
VARCHAR data type
Varchar type
VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP functions
Variations on Put
Verify that replication works
Verify the ZooKeeper authentication
Verify validity of the NFS services
Verifying if a memory limit is sufficient
Verifying That an S3A Committer Was Used
Verifying that Indexing Works
Verifying that S3Guard is Enabled on a Bucket
Verifying the Impala dependency on Kudu
Versions
View All Applications
View and modify log levels for Search and related services
View and modify Search configuration
View application details
View audit details
View Cluster Overview
View compaction progress
View existing collections
View Nodes and Node Details
View query details
View Queues and Queue Details
View Ranger reports
View transaction locks
View transactions
Viewing detailed information
Viewing lineage
Viewing storage information
Viewing table and column statistics
Viewing the API documentation
Viewing the DAG counters
Viewing the DAG flow
Viewing the Hive configurations for a query
Viewing the Join report
Viewing the query details
Viewing the query recommendations
Viewing the query timeline
Viewing the Read and Write report
Viewing the task-level DAG information
Viewing the Tez configurations for a query
Viewing the visual explain for a query
Views
Virtual machine options for HBase Shell
Virtual memory handling
Web UI encryption
Web UI redaction
Web User Interface for Debugging
What Is Cloudera Search
What's New
When Shuffles Do Not Occur
When to Add a Shuffle Transformation
When to use Atlas classifications for access control
Why HDFS data becomes unbalanced
Why one scheduler?
Wildcards and variables in resource-based policies
WINDOW
WITH clause
Work Preserving Recovery for YARN components
Working with Amazon S3
Working with Apache Hive Metastore
Working with Atlas classifications and labels
Working with Classifications and Labels
Working with Google Cloud Storage
Working with S3 buckets in the same AWS region
Working with the Oozie server
Working with Third-party S3-compatible Object Stores
Working with versioned S3 buckets
Working with Zeppelin Notes
Write transformed Hive data to Kafka
Write-ahead log garbage collection
Writes
Writing data to HBase
Writing data to Kafka
Writing managed tables through HWC
Writing to multiple tablets
Writing UDFs
Writing user-defined aggregate functions (UDAFs)
YARN
YARN
YARN
YARN
YARN ACL rules
YARN ACL syntax
YARN ACL types
YARN Configuration Properties
YARN Features
YARN Log Aggregation Overview
YARN resource allocation of multiple resource-types
YARN ResourceManager High Availability
YARN ResourceManager high availability architecture
YARN services API examples
YARN tuning overview
Zeppelin
Zeppelin
ZooKeeper
ZooKeeper
ZooKeeper
ZooKeeper ACLs Best Practices
ZooKeeper ACLs Best Practices: Atlas
ZooKeeper ACLs Best Practices: HBase
ZooKeeper ACLs Best Practices: HDFS
ZooKeeper ACLs Best Practices: Kafka
ZooKeeper ACLs Best Practices: Oozie
ZooKeeper ACLs Best Practices: Ranger
ZooKeeper ACLs best practices: Search
ZooKeeper ACLs Best Practices: YARN
ZooKeeper ACLs Best Practices: ZooKeeper
ZooKeeper Authentication
zookeeper-security-migration

«

Filter topics

COUNT

Apache Impala SQL Overview
▶︎Schema objects
▶︎Data types
Literals
Operators
Comments
▶︎SQL statements
▼Built-in functions
▶︎User-defined functions (UDFs)
Transactions
Reserved words
Impala SQL and Hive SQL
SQL migration

»

Apache Impala SQL Reference

COUNT

You can include an OVER clause with a call to this function to use it as an analytic function.

Related information

COUNT function

© 2019–2020 by Cloudera, Inc. All rights reserved.

This site uses cookies and related technologies, as described in our privacy policy, for purposes that may include site operation, analytics, enhanced user experience, or advertising. You may choose to consent to our use of these technologies, or

7.3.1
7.2
7.1.0
7.0