List of Pages in Category Impala (290 pages)
Impala
Official name: Apache Impala. A service that enables real-time querying of data stored in HDFS or HBase. It supports the same metadata and ODBC and JDBC drivers as Apache Hive and a query language based on the Hive Standard Query Language (HiveQL). To avoid latency, Impala circumvents MapReduce to directly access data through a specialized distributed query engine that is similar to those found in commercial parallel RDBMS.
*
A
- ABORT_ON_ERROR Query Option
- Adding a Service
- Admission Control and Query Queuing
- Admission Control Sample Scenario
- ALLOW_ERASURE_CODED_FILES Query Option
- ALLOW_UNSUPPORTED_FORMATS Query Option
- ALTER DATABASE Statement
- ALTER TABLE Statement
- ALTER VIEW Statement
- Apache Impala - Interactive SQL
- APPX_COUNT_DISTINCT Query Option (CDH 5.2 or higher only)
- APPX_MEDIAN Function
- ARRAY Complex Type (CDH 5.5 or higher only)
- Auditing Impala Operations
- Authorization With Apache Sentry
- AVG Function
)B
- BATCH_SIZE Query Option
- Benchmarking Impala Queries
- BIGINT Data Type
- BOOLEAN Data Type
- Breakpad Minidumps for Impala (CDH 5.8 or higher only)
- BUFFER_POOL_LIMIT Query Option
C
- CHAR Data Type (CDH 5.2 or higher only)
- Cluster Utilization Reports
- COMMENT Statement
- Comments
- Complex Types (CDH 5.5 or higher only)
- Components of the Impala Server
- COMPRESSION_CODEC Query Option (CDH 5.2 or higher only)
- COMPUTE STATS Statement
- COMPUTE_STATS_MIN_SAMPLE_SIZE Query Option
- Configuring ADLS Access Using Cloudera Manager
- Configuring Impala Delegation for Hue and BI Tools
- Configuring Impala to Work with JDBC
- Configuring Impala to Work with JDBC
- Configuring Impala to Work with ODBC
- Configuring Impala to Work with ODBC
- Configuring Other CDH Components to Use HDFS HA
- Configuring Resource Pools and Admission Control
- Configuring Short-Circuit Reads
- Configuring TLS/SSL for Hue
- Configuring TLS/SSL for Impala
- Connecting to impalad through impala-shell
- Controlling Impala Resource Usage
- COUNT Function
- CREATE DATABASE Statement
- CREATE FUNCTION Statement
- CREATE ROLE Statement (CDH 5.2 or higher only)
- CREATE TABLE Statement
- CREATE VIEW Statement
- Creating a Custom Cluster Utilization Report
- Customizing Time Zones
D
- Data Types
- DDL Statements
- DEBUG_ACTION Query Option
- DECIMAL Data Type (CDH 6.0 / Impala 3.0 or higher only)
- DECIMAL_V2 Query Option
- DEFAULT_JOIN_DISTRIBUTION_MODE Query Option
- DEFAULT_SPILLABLE_BUFFER_SIZE Query Option
- DELETE Statement (CDH 5.10 or higher only)
- DESCRIBE Statement
- Detecting and Correcting HDFS Block Skew Conditions
- Developing Impala Applications
- DISABLE_CODEGEN Query Option
- DISABLE_CODEGEN_ROWS_THRESHOLD Query Option (CDH 5.13 / Impala 2.10 or higher only)
- DISABLE_ROW_RUNTIME_FILTERING Query Option (CDH 5.7 or higher only)
- DISABLE_STREAMING_PREAGGREGATIONS Query Option (CDH 5.7 or higher only)
- DISABLE_UNSAFE_SPILLS Query Option (CDH 5.2 or higher only)
- DISTINCT Operator
- DML Statements
- DOUBLE Data Type
- DROP DATABASE Statement
- DROP FUNCTION Statement
- DROP ROLE Statement (CDH 5.2 or higher only)
- DROP STATS Statement
- DROP TABLE Statement
- DROP VIEW Statement
- Dynamic Resource Pools
E
- ENABLE_EXPR_REWRITES Query Option
- Enabling Kerberos Authentication for Impala
- Enabling LDAP Authentication for Impala
- Enabling Sentry Authorization for Impala
- EXEC_SINGLE_NODE_ROWS_THRESHOLD Query Option (CDH 5.3 or higher only)
- EXEC_TIME_LIMIT_S Query Option (CDH 5.15 / Impala 2.12 or higher only)
- EXPLAIN Statement
- EXPLAIN_LEVEL Query Option
F
G
- GRANT Statement (CDH 5.2 or higher only)
- GROUP BY Clause
- GROUP_CONCAT Function
- Guidelines for Designing Impala Schemas
H
- HAVING Clause
- HBASE_CACHE_BLOCKS Query Option
- HBASE_CACHING Query Option
- Hive and Impala Lineage Configuration
- Hive/Impala Replication
- How Impala Fits Into the Hadoop Ecosystem
- How Impala Works with Hadoop File Formats
- How to Configure Impala with Dedicated Coordinators
- How to Enable Sensitive Data Redaction
- Hue Authentication
- Hue Security
I
- IDLE_SESSION_TIMEOUT Query Option (CDH 5.15 / Impala 2.12 or higher only)
- Impala
- Impala Administration
- Impala Aggregate Functions
- Impala Analytic Functions
- Impala Authentication
- Impala Bit Functions
- Impala Built-In Functions
- Impala Catalog Server Metrics
- Impala Concepts and Architecture
- Impala Conditional Functions
- Impala Daemon Metrics
- Impala Daemon Resource Pool Metrics
- Impala Date and Time Functions
- Impala Frequently Asked Questions
- Impala Llama ApplicationMaster Metrics
- Impala Mathematical Functions
- Impala Metrics
- Impala Miscellaneous Functions
- Impala Performance Guidelines and Best Practices
- Impala Pool Metrics
- Impala Pool User Metrics
- Impala Query Metrics
- Impala Requirements
- Impala Requirements
- Impala Reserved Words
- Impala Schema Objects and Object Names
- Impala Security Overview
- Impala SQL Language Reference
- Impala SQL Statements
- Impala StateStore Metrics
- Impala String Functions
- Impala Tutorials
- Impala Type Conversion Functions
- Impala Web User Interface for Debugging
- impala-shell Command Reference
- impala-shell Configuration Options
- INSERT Statement
- Installation Considerations for Impala Security
- INT Data Type
- INVALIDATE METADATA Statement
J
K
L
- LIMIT Clause
- Literals
- LIVE_PROGRESS Query Option (CDH 5.5 or higher only)
- LIVE_SUMMARY Query Option (CDH 5.5 or higher only)
- LOAD DATA Statement
M
- Managing Disk Space for Impala Data
- Managing Impala
- MAP Complex Type (CDH 5.5 or higher only)
- MAX Function
- MAX_ERRORS Query Option
- MAX_MEM_ESTIMATE_FOR_ADMISSION Query Option
- MAX_NUM_RUNTIME_FILTERS Query Option (CDH 5.7 or higher only)
- MAX_ROW_SIZE Query Option
- MAX_SCAN_RANGE_LENGTH Query Option
- MEM_LIMIT Query Option
- Metadata Management
- MIN Function
- MIN_SPILLABLE_BUFFER_SIZE Query Option
- Modifying Impala Startup Options
- Monitoring Impala Queries
- Monitoring the Performance of Hive/Impala Replications
- MT_DOP Query Option
N
- NDV Function
- NUM_NODES Query Option
- NUM_ROWS_PRODUCED_LIMIT Query Option
- NUM_SCANNER_THREADS Query Option
O
- OFFSET Clause
- Optimizer Hints in Impala
- OPTIMIZE_PARTITION_KEY_SCANS Query Option (CDH 5.7 or higher only)
- ORDER BY Clause
- Overview of Impala Aliases
- Overview of Impala Databases
- Overview of Impala Functions
- Overview of Impala Identifiers
- Overview of Impala Tables
- Overview of Impala Views
P
- PARQUET_ANNOTATE_STRINGS_UTF8 Query Option (CDH 5.8 or higher only)
- PARQUET_ARRAY_RESOLUTION Query Option (CDH 5.12 or higher only)
- PARQUET_COMPRESSION_CODEC Query Option
- PARQUET_DICTIONARY_FILTERING Query Option (CDH 5.12 or higher only)
- PARQUET_FALLBACK_SCHEMA_RESOLUTION Query Option (CDH 5.8 or higher only)
- PARQUET_FILE_SIZE Query Option
- PARQUET_READ_STATISTICS Query Option (CDH 5.12 or higher only)
- Partitioning for Impala Tables
- Performance Considerations for Join Queries
- Planning for Impala Deployment
- Porting SQL from Other Database Systems to Impala
- Ports Used by Impala
- Post-Installation Configuration for Impala
- Predicate Pushdown in Parquet
- PREFETCH_MODE Query Option (CDH 5.8 or higher only)
Q
- Query Details
- Query Options for the SET Statement
- QUERY_TIMEOUT_S Query Option (CDH 5.2 or higher only)
R
- REAL Data Type
- REFRESH AUTHORIZATION Statement
- REFRESH FUNCTIONS Statement
- REFRESH Statement
- Replicating Data to Impala Clusters
- REPLICA_PREFERENCE Query Option (CDH 5.9 or higher only)
- REQUEST_POOL Query Option
- Resource Management
- RESOURCE_TRACE_RATIO Query Option (CDH 6.2 / Impala 3.2 or higher only)
- REVOKE Statement (CDH 5.2 or higher only)
- Running Commands and SQL Statements in impala-shell
- Runtime Filtering for Impala Queries (CDH 5.7 or higher only)
- RUNTIME_BLOOM_FILTER_SIZE Query Option (CDH 5.7 or higher only)
- RUNTIME_FILTER_MAX_SIZE Query Option (CDH 5.8 or higher only)
- RUNTIME_FILTER_MIN_SIZE Query Option (CDH 5.8 or higher only)
- RUNTIME_FILTER_MODE Query Option (CDH 5.7 or higher only)
- RUNTIME_FILTER_WAIT_TIME_MS Query Option (CDH 5.7 or higher only)
S
- S3_SKIP_INSERT_STAGING Query Option (CDH 5.8 or higher only)
- Scalability Considerations for Impala
- Scaling Limits and Guidelines
- SCAN_BYTES_LIMIT Query Option (CDH 6.1 or higher only)
- SCHEDULE_RANDOM_REPLICA Query Option (CDH 5.7 or higher only)
- SCRATCH_LIMIT Query Option
- Securing Impala Data and Log Files
- Securing the Hive Metastore Database
- Securing the Impala Web User Interface
- Security Guidelines for Impala
- SELECT Statement
- SET Statement
- Setting Timeout Periods for Daemons, Queries, and Sessions
- SHOW Statement
- SHUFFLE_DISTINCT_EXPRS Query Option
- SHUTDOWN Statement
- SMALLINT Data Type
- Specifying Impala Credentials to Access Data in S3
- Specifying Impala Credentials to Access Data in S3 with Cloudera Manager
- SQL Differences Between Impala and Hive
- SQL Operators
- STDDEV, STDDEV_SAMP, STDDEV_POP Functions
- STRING Data Type
- STRUCT Complex Type (CDH 5.5 or higher only)
- Subqueries in Impala SELECT Statements
- SUM Function
- SUPPORT_START_OVER Query Option
- SYNC_DDL Query Option
T
- Table and Column Statistics
- TABLESAMPLE Clause
- Testing Impala Performance
- The Impala Service
- THREAD_RESERVATION_AGGREGATE_LIMIT Query Option (CDH 6.1 or higher only)
- THREAD_RESERVATION_LIMIT Query Option (CDH 6.1 or higher only)
- TIMESTAMP Data Type
- TIMEZONE Query Option (CDH 6.1 / Impala 3.1 or higher only)
- TINYINT Data Type
- TOPN_BYTES_LIMIT Query Option (CDH 6.1 / Impala 3.1 or higher only)
- Troubleshooting Impala
- TRUNCATE TABLE Statement (CDH 5.5 or higher only)
- Tuning Impala for Performance
- Tutorial: Using Impala, Hive and Hue with Virtual Private Clusters
U
- Understanding Impala Query Performance - EXPLAIN Plans and Query Profiles
- UNION Clause
- UPDATE Statement (CDH 5.10 or higher only)
- UPSERT Statement (CDH 5.10 or higher only)
- USE Statement
- User-Defined Functions (UDFs)
- Using Apache Impala with Kudu
- Using Apache Parquet Data Files with CDH
- Using CDH with Isilon Storage
- Using HDFS Caching with Impala (CDH 5.3 or higher only)
- Using Impala Logging
- Using Impala through a Proxy for High Availability
- Using Impala to Query HBase Tables
- Using Impala to Query Kudu Tables
- Using Impala with the Amazon S3 Filesystem
- Using Impala with the Azure Data Lake Store (ADLS)
- Using Lineage to Display Table Schema
- Using Multiple Authentication Methods with Impala
- Using Snapshots with Replication
- Using Text Data Files with Impala Tables
- Using the Avro File Format with Impala Tables
- Using the Hive Metastore with Kudu
- Using the Impala Shell (impala-shell Command)
- Using the ORC File Format with Impala Tables
- Using the Parquet File Format with Impala Tables
- Using the RCFile File Format with Impala Tables
- Using the SequenceFile File Format with Impala Tables
V
- VALUES Statement
- VARCHAR Data Type (CDH 5.2 or higher only)
- VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP Functions
- Viewing Lineage Information for Impala Data
W