List of Pages in Category Data Analysts (229 pages)
*
A
- ABORT_ON_DEFAULT_LIMIT_EXCEEDED Query Option
- ABORT_ON_ERROR Query Option
- Accessing Avro Data Files From Spark SQL Applications
- Accessing Data Stored in Amazon S3 through Spark
- Accessing Data Stored in Azure Data Lake Store (ADLS) through Spark
- Accessing External Storage from Spark
- Accessing HBase by using the HBase Shell
- Accessing HBase by using the HBase Shell
- Accessing Parquet Files From Spark SQL Applications
- Accessing Table Data with Pig
- ALTER TABLE Statement
- ALTER VIEW Statement
- Apache Impala - Interactive SQL
- Apache Impala Overview
- APPX_COUNT_DISTINCT Query Option (CDH 5.2 or higher only)
- APPX_MEDIAN Function
- ARRAY Complex Type (CDH 5.5 or higher only)
- AVG Function
)B
- BATCH_SIZE Query Option
- Benchmarking Impala Queries
- BIGINT Data Type
- BOOLEAN Data Type
- Building Spark Applications
C
- CHAR Data Type (CDH 5.2 or higher only)
- Cloudera Search Guide
- Cloudera Search Overview
- 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
- Configuration Settings for HBase
- Configuring Impala Delegation for Hue and BI Tools
- Connecting to impalad through impala-shell
- Controlling Impala Resource Usage
- Copying Cluster Data Using DistCp
- Copying Data between a Secure and an Insecure Cluster using DistCp and WebHDFS
- COUNT Function
- CREATE DATABASE Statement
- CREATE FUNCTION Statement
- CREATE ROLE Statement (CDH 5.2 or higher only)
- CREATE TABLE Statement
- CREATE VIEW Statement
D
- Data Types
- DDL Statements
- DECIMAL Data Type
- DEFAULT_JOIN_DISTRIBUTION_MODE Query Option
- DEFAULT_ORDER_BY_LIMIT Query Option
- DELETE Statement (CDH 5.10 or higher only)
- DESCRIBE Statement
- Detecting and Correcting HDFS Block Skew Conditions
- Developing and Running a Spark WordCount Application
- Developing Impala Applications
- 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
E
- EXEC_SINGLE_NODE_ROWS_THRESHOLD Query Option (CDH 5.3 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 Filtering
- HBASE_CACHE_BLOCKS Query Option
- HBASE_CACHING Query Option
- How Impala Fits Into the Hadoop Ecosystem
- How Impala Works with Hadoop File Formats
I
- Impala Aggregate Functions
- Impala Analytic Functions
- Impala Bit Functions
- Impala Built-In Functions
- Impala Concepts and Architecture
- Impala Conditional Functions
- Impala Date and Time Functions
- Impala Frequently Asked Questions
- Impala Mathematical Functions
- Impala Miscellaneous Functions
- Impala Performance Guidelines and Best Practices
- Impala Requirements
- Impala Requirements
- Impala Reserved Words
- Impala Schema Objects and Object Names
- Impala SQL Language Reference
- Impala SQL Statements
- Impala String Functions
- Impala Tutorials
- Impala Type Conversion Functions
- Impala Web User Interface for Debugging
- impala-shell Command Reference
- impala-shell Configuration Options
- Importing Data Into HBase
- INSERT Statement
- INT Data Type
- INVALIDATE METADATA Statement
J
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
- MAP Complex Type (CDH 5.5 or higher only)
- MAX Function
- MAX_ERRORS Query Option
- MAX_IO_BUFFERS Query Option
- MAX_NUM_RUNTIME_FILTERS Query Option (CDH 5.7 or higher only)
- MAX_SCAN_RANGE_LENGTH Query Option
- MEM_LIMIT Query Option
- MIN Function
- MT_DOP Query Option
N
O
- OFFSET Clause
- 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.11 or higher only)
- PARQUET_DICTIONARY_FILTERING Query Option (CDH 5.11 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.11 or higher only)
- Partitioning for Impala Tables
- Performance Considerations for Join Queries
- Porting SQL from Other Database Systems to Impala
- Ports Used by Impala
- PREFETCH_MODE Query Option (CDH 5.8 or higher only)
Q
- Query Hints in Impala SELECT Statements
- Query Options for the SET Statement
- QUERY_TIMEOUT_S Query Option (CDH 5.2 or higher only)
R
- Reading Data from HBase
- REAL Data Type
- REFRESH FUNCTIONS Statement
- REFRESH Statement
- REPLICA_PREFERENCE Query Option (CDH 5.9 or higher only)
- REQUEST_POOL Query Option
- RESERVATION_REQUEST_TIMEOUT Query Option (CDH 5.0 or higher 5 only)
- Resource Management for Impala
- REVOKE Statement (CDH 5.2 or higher only)
- Running Commands and SQL Statements in impala-shell
- Running Spark Applications
- Running Your First Spark Application
- 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)
- SCAN_NODE_CODEGEN_THRESHOLD Query Option (CDH 5.7 or higher only)
- SCHEDULE_RANDOM_REPLICA Query Option (CDH 5.7 or higher only)
- SCRATCH_LIMIT Query Option
- SELECT Statement
- SET Statement
- SHOW Statement
- SMALLINT Data Type
- Spark and IPython and Jupyter Notebooks
- 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
- Supported Sources, Sinks, and Channels
- SYNC_DDL Query Option
T
- Table and Column Statistics
- TABLESAMPLE Clause
- Testing Impala Performance
- TIMESTAMP Data Type
- TINYINT Data Type
- Troubleshooting Impala
- TRUNCATE TABLE Statement (CDH 5.5 or higher only)
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 Avro Data Files with CDH
- Using Apache Hive with HBase in CDH
- Using Apache Parquet Data Files with CDH
- Using Azure Data Lake Store with HBase
- Using CDH with Isilon Storage
- Using HBase Command-Line Utilities
- 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 Isilon Storage
- Using Impala with the Amazon S3 Filesystem
- Using Impala with the Azure Data Lake Store (ADLS)
- Using Pig with HBase
- Using PySpark
- Using Spark MLlib
- Using Spark SQL
- Using Spark Streaming
- Using Text Data Files with Impala Tables
- Using the Avro File Format with Impala Tables
- Using the Impala Shell (impala-shell Command)
- 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
- VARCHAR Data Type (CDH 5.2 or higher only)
- VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP Functions
- V_CPU_CORES Query Option (CDH 5.0 or higher only)
W