Documentation
Products
Services & Support
Solutions
List of Pages in Category Data Analysts (211 pages)
Start typing to see matching topic titles in the
Data Analysts
category:
If this category isn't helpful:
List of all categories
|
Back to navigation tree view
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
*
All Cloudera Documentation Categories
A
ABORT_ON_DEFAULT_LIMIT_EXCEEDED Query Option
(211 words:
)
ABORT_ON_ERROR Query Option
(291 words:
)
(Task)
Accessing Avro Data Files From Spark SQL Applications
(1261 words:
)
(Task)
Accessing Data Stored in Amazon S3 through Spark
(482 words:
)
(Task)
Accessing External Storage from Spark
(333 words:
)
(Task)
Accessing HBase by using the HBase Shell
(574 words:
)
(Task)
Accessing HBase by using the HBase Shell
(574 words:
)
(Task)
Accessing Parquet Files From Spark SQL Applications
(425 words:
)
(Task)
Accessing Table Data with Pig
(206 words:
)
ALTER TABLE Statement
(5356 words:
)
ALTER VIEW Statement
(701 words:
)
Apache Impala - Interactive SQL
(544 words:
)
Apache Impala Overview
(778 words:
)
APPX_COUNT_DISTINCT Query Option (CDH 5.2 or higher only)
(404 words:
)
APPX_MEDIAN Function
(636 words:
)
ARRAY Complex Type (CDH 5.5 or higher only)
(1556 words:
)
AVG Function
(1850 words:
)
B
BATCH_SIZE Query Option
(215 words:
)
(Task)
Benchmarking Impala Queries
(291 words:
)
BIGINT Data Type
(669 words:
)
BOOLEAN Data Type
(737 words:
)
(Task)
Building Spark Applications
(697 words:
)
C
CHAR Data Type (CDH 5.2 or higher only)
(1426 words:
)
Cloudera Search Guide
(320 words:
)
Cloudera Search Overview
(1235 words:
)
Comments
(305 words:
)
Complex Types (CDH 5.5 or higher only)
(13416 words:
)
Components of the Impala Server
(1228 words:
)
COMPRESSION_CODEC Query Option (CDH 5.2 or higher only)
(373 words:
)
COMPUTE STATS Statement
(3016 words:
)
Configuration Settings for HBase
(2327 words:
)
(Task)
Configuring Impala Delegation for Hue and BI Tools
(609 words:
)
(Task)
Connecting to impalad through impala-shell
(970 words:
)
(Task)
Controlling Impala Resource Usage
(401 words:
)
(Task)
Copying Cluster Data Using DistCp
(2502 words:
)
(Task)
Copying Data between a Secure and an Insecure Cluster using DistCp and WebHDFS
(316 words:
)
COUNT Function
(1946 words:
)
CREATE DATABASE Statement
(1043 words:
)
CREATE FUNCTION Statement
(2833 words:
)
CREATE ROLE Statement (CDH 5.2 or higher only)
(370 words:
)
CREATE TABLE Statement
(5172 words:
)
CREATE VIEW Statement
(1040 words:
)
D
Data Types
(278 words:
)
DDL Statements
(692 words:
)
DECIMAL Data Type (CDH 5.1 or higher only)
(3993 words:
)
DEFAULT_ORDER_BY_LIMIT Query Option
(252 words:
)
DESCRIBE Statement
(3778 words:
)
(Task)
Detecting and Correcting HDFS Block Skew Conditions
(1104 words:
)
(Task)
Developing and Running a Spark WordCount Application
(1221 words:
)
(Task)
Developing Impala Applications
(1017 words:
)
DISABLE_ROW_RUNTIME_FILTERING Query Option (CDH 5.7 or higher only)
(376 words:
)
DISABLE_STREAMING_PREAGGREGATIONS Query Option (CDH 5.7 or higher only)
(330 words:
)
DISABLE_UNSAFE_SPILLS Query Option (CDH 5.2 or higher only)
(384 words:
)
DISTINCT Operator
(511 words:
)
DML Statements
(495 words:
)
DOUBLE Data Type
(621 words:
)
DROP DATABASE Statement
(882 words:
)
DROP FUNCTION Statement
(692 words:
)
DROP ROLE Statement (CDH 5.2 or higher only)
(371 words:
)
DROP STATS Statement
(2208 words:
)
DROP TABLE Statement
(1033 words:
)
E
EXEC_SINGLE_NODE_ROWS_THRESHOLD Query Option (CDH 5.3 or higher only)
(548 words:
)
EXPLAIN Statement
(1316 words:
)
EXPLAIN_LEVEL Query Option
(1862 words:
)
F
File Formats and Compression
(346 words:
)
FLOAT Data Type
(612 words:
)
G
GRANT Statement (CDH 5.2 or higher only)
(549 words:
)
GROUP BY Clause
(797 words:
)
GROUP_CONCAT Function
(636 words:
)
(Concept)
Guidelines for Designing Impala Schemas
(1288 words:
)
H
HAVING Clause
(230 words:
)
HBase Filtering
(2438 words:
)
HBASE_CACHE_BLOCKS Query Option
(228 words:
)
HBASE_CACHING Query Option
(203 words:
)
How Impala Fits Into the Hadoop Ecosystem
(873 words:
)
How Impala Works with Hadoop File Formats
(1046 words:
)
I
Impala Aggregate Functions
(267 words:
)
Impala Analytic Functions
(8219 words:
)
Impala Bit Functions
(2860 words:
)
Impala Built-In Functions
(707 words:
)
Impala Concepts and Architecture
(220 words:
)
Impala Conditional Functions
(1823 words:
)
Impala Date and Time Functions
(8800 words:
)
Impala Frequently Asked Questions
(8349 words:
)
Impala Mathematical Functions
(4081 words:
)
Impala Miscellaneous Functions
(636 words:
)
(Concept)
Impala Performance Guidelines and Best Practices
(2237 words:
)
(Release Notes)
Impala Requirements
(1372 words:
)
(Release Notes)
Impala Requirements
(1369 words:
)
Impala Reserved Words
(699 words:
)
Impala Schema Objects and Object Names
(440 words:
)
Impala SQL Language Reference
(414 words:
)
Impala SQL Statements
(408 words:
)
Impala String Functions
(4549 words:
)
Impala Tutorials
(12040 words:
)
Impala Type Conversion Functions
(1416 words:
)
Impala User-Defined Functions (UDFs)
(7126 words:
)
Impala Web User Interface for Debugging
(1387 words:
)
impala-shell Command Reference
(1381 words:
)
impala-shell Configuration Options
(1659 words:
)
(Task)
Importing Data Into HBase
(6934 words:
)
INSERT Statement
(4813 words:
)
INT Data Type
(504 words:
)
INVALIDATE METADATA Statement
(1607 words:
)
J
Joins in Impala SELECT Statements
(3198 words:
)
L
LIMIT Clause
(843 words:
)
Literals
(2043 words:
)
LIVE_PROGRESS Query Option (CDH 5.5 or higher only)
(604 words:
)
LIVE_SUMMARY Query Option (CDH 5.5 or higher only)
(1272 words:
)
LOAD DATA Statement
(1872 words:
)
M
(Task)
Managing Disk Space for Impala Data
(991 words:
)
MAP Complex Type (CDH 5.5 or higher only)
(1592 words:
)
MAX Function
(1752 words:
)
MAX_ERRORS Query Option
(243 words:
)
MAX_IO_BUFFERS Query Option
(161 words:
)
MAX_NUM_RUNTIME_FILTERS Query Option (CDH 5.7 or higher only)
(334 words:
)
MAX_SCAN_RANGE_LENGTH Query Option
(282 words:
)
MEM_LIMIT Query Option
(985 words:
)
MIN Function
(1754 words:
)
N
NDV Function
(1068 words:
)
NUM_NODES Query Option
(387 words:
)
NUM_SCANNER_THREADS Query Option
(209 words:
)
O
OFFSET Clause
(515 words:
)
OPTIMIZE_PARTITION_KEY_SCANS Query Option (CDH 5.7 or higher only)
(979 words:
)
ORDER BY Clause
(2507 words:
)
(Concept)
Overview of Impala Aliases
(649 words:
)
(Concept)
Overview of Impala Databases
(434 words:
)
(Concept)
Overview of Impala Functions
(637 words:
)
(Concept)
Overview of Impala Identifiers
(615 words:
)
(Concept)
Overview of Impala Tables
(1333 words:
)
(Concept)
Overview of Impala Views
(1818 words:
)
P
PARQUET_ANNOTATE_STRINGS_UTF8 Query Option (CDH 5.8 or higher only)
(323 words:
)
PARQUET_FALLBACK_SCHEMA_RESOLUTION Query Option (CDH 5.8 or higher only)
(259 words:
)
PARQUET_FILE_SIZE Query Option
(459 words:
)
(Task)
Partitioning for Impala Tables
(3745 words:
)
Performance Considerations for Join Queries
(2879 words:
)
(Task)
Porting SQL from Other Database Systems to Impala
(3383 words:
)
(Reference)
Ports Used by Impala
(505 words:
)
PREFETCH_MODE Query Option (CDH 5.8 or higher only)
(224 words:
)
Q
Query Hints in Impala SELECT Statements
(1904 words:
)
Query Options for the SET Statement
(311 words:
)
QUERY_TIMEOUT_S Query Option (CDH 5.2 or higher only)
(345 words:
)
R
(Task)
Reading Data from HBase
(1172 words:
)
REAL Data Type
(252 words:
)
REFRESH Statement
(1505 words:
)
REQUEST_POOL Query Option
(212 words:
)
RESERVATION_REQUEST_TIMEOUT Query Option (CDH 5 only)
(232 words:
)
Resource Management for Impala
(445 words:
)
REVOKE Statement (CDH 5.2 or higher only)
(456 words:
)
(Task)
Running Commands and SQL Statements in impala-shell
(1272 words:
)
(Task)
Running Spark Applications
(1239 words:
)
(Task)
Running Your First Spark Application
(527 words:
)
Runtime Filtering for Impala Queries
(3105 words:
)
RUNTIME_BLOOM_FILTER_SIZE Query Option (CDH 5.7 or higher only)
(509 words:
)
RUNTIME_FILTER_MAX_SIZE Query Option (CDH 5.8 or higher only)
(299 words:
)
RUNTIME_FILTER_MIN_SIZE Query Option (CDH 5.8 or higher only)
(299 words:
)
RUNTIME_FILTER_MODE Query Option (CDH 5.7 or higher only)
(426 words:
)
RUNTIME_FILTER_WAIT_TIME_MS Query Option (CDH 5.7 or higher only)
(259 words:
)
S
S3_SKIP_INSERT_STAGING Query Option (CDH 5.8 or higher only)
(471 words:
)
SCAN_NODE_CODEGEN_THRESHOLD Query Option (CDH 5.7 or higher only)
(445 words:
)
SCHEDULE_RANDOM_REPLICA Query Option (CDH 5.7 or higher only)
(394 words:
)
SELECT Statement
(1182 words:
)
SET Statement
(861 words:
)
SHOW Statement
(7136 words:
)
SMALLINT Data Type
(540 words:
)
Spark and IPython and Jupyter Notebooks
(246 words:
)
SQL Differences Between Impala and Hive
(1329 words:
)
SQL Operators
(8508 words:
)
STDDEV, STDDEV_SAMP, STDDEV_POP Functions
(519 words:
)
STRING Data Type
(1123 words:
)
STRUCT Complex Type (CDH 5.5 or higher only)
(2250 words:
)
Subqueries in Impala SELECT Statements
(1560 words:
)
SUM Function
(1926 words:
)
Supported Sources, Sinks, and Channels
(944 words:
)
SYNC_DDL Query Option
(420 words:
)
T
Table and Column Statistics
(6831 words:
)
(Task)
Testing Impala Performance
(691 words:
)
TIMESTAMP Data Type
(2622 words:
)
TINYINT Data Type
(593 words:
)
(Task)
Troubleshooting Impala
(1588 words:
)
TRUNCATE TABLE Statement (CDH 5.5 or higher only)
(896 words:
)
U
(Task)
Understanding Impala Query Performance - EXPLAIN Plans and Query Profiles
(1554 words:
)
UNION Clause
(692 words:
)
USE Statement
(395 words:
)
(Task)
Using Apache Avro Data Files with CDH
(1518 words:
)
(Task)
Using Apache Parquet Data Files with CDH
(3258 words:
)
(Task)
Using CDH with Isilon Storage
(2612 words:
)
(Task)
Using HBase Command-Line Utilities
(2211 words:
)
(Task)
Using HDFS Caching with Impala (CDH 5.1 or higher only)
(3524 words:
)
(Task)
Using Hive with HBase
(250 words:
)
(Task)
Using Impala Logging
(1928 words:
)
(Task)
Using Impala through a Proxy for High Availability
(1989 words:
)
(Task)
Using Impala to Query HBase Tables
(4156 words:
)
(Task)
Using Impala with Isilon Storage
(829 words:
)
(Task)
Using Impala with the Amazon S3 Filesystem
(4461 words:
)
(Task)
Using Pig with HBase
(240 words:
)
(Task)
Using PySpark
(199 words:
)
(Task)
Using Spark MLlib
(521 words:
)
(Task)
Using Spark SQL
(1468 words:
)
(Task)
Using Spark Streaming
(1037 words:
)
(Task)
Using Text Data Files with Impala Tables
(4019 words:
)
(Task)
Using the Avro File Format with Impala Tables
(2603 words:
)
(Task)
Using the Impala Shell (impala-shell Command)
(620 words:
)
(Task)
Using the Parquet File Format with Impala Tables
(7180 words:
)
(Task)
Using the RCFile File Format with Impala Tables
(1095 words:
)
(Task)
Using the SequenceFile File Format with Impala Tables
(1066 words:
)
V
VARCHAR Data Type (CDH 5.2 or higher only)
(1052 words:
)
VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP Functions
(591 words:
)
V_CPU_CORES Query Option (CDH 5 only)
(239 words:
)
W
WITH Clause
(427 words:
)
(Task)
Writing Data to HBase
(1129 words:
)