This is the documentation for Cloudera Enterprise 5.8.x. Documentation for other versions is available at Cloudera Documentation.
List of Pages in Category SQL (120 pages)
SQL
A declarative programming language designed for managing data in relational database management systems. It includes features for creating schema objects such as databases and tables, and for querying and modifying data. CDH includes SQL support through Impala for high-performance interactive queries, and Hive for long-running batch-oriented jobs.
*
A
- Accessing Avro Data Files From Spark SQL Applications
- Accessing Parquet Files From Spark SQL Applications
- ALTER TABLE Statement
- ALTER VIEW Statement
- Apache Impala (incubating) - Interactive SQL
- APPX_MEDIAN Function
- ARRAY Complex Type (CDH 5.5 or higher only)
- AVG Function
)B
C
- CHAR Data Type (CDH 5.2 or higher only)
- Comments
- Complex Types (CDH 5.5 and higher only)
- COMPUTE STATS Statement
- Configuring HiveServer2
- Configuring Impala to Work with JDBC
- Configuring Impala to Work with ODBC
- Configuring Sqoop 2
- 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 (CDH 5.1 or higher only)
- DESCRIBE Statement
- Developing Impala Applications
- 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
E
F
G
- GRANT Statement (CDH 5.2 or higher only)
- GROUP BY Clause
- GROUP_CONCAT Function
- Guidelines for Designing Impala Schemas
H
I
- Impala Aggregate Functions
- Impala Analytic Functions
- Impala Bit Functions
- Impala Built-In Functions
- Impala Conditional Functions
- Impala Date and Time Functions
- Impala Mathematical Functions
- Impala Miscellaneous Functions
- 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-shell Command Reference
- INSERT Statement
- Installing the Hive JDBC Driver on Clients
- Installing the JDBC Drivers for Sqoop 1
- INT Data Type
- INVALIDATE METADATA Statement
J
L
M
N
O
- OFFSET Clause
- 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
- Partitioning for Impala Tables
- Performance Considerations for Join Queries
- Porting SQL from Other Database Systems to Impala
Q
R
- REAL Data Type
- REFRESH Statement
- REVOKE Statement (CDH 5.2 or higher only)
- Running Commands and SQL Statements in impala-shell
- Runtime Filtering for Impala Queries
S
- SELECT Statement
- Sensitive Data Redaction
- SET Statement
- SHOW Statement
- SMALLINT Data Type
- 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
- SYNC_DDL Query Option
T
- TIMESTAMP Data Type
- TINYINT Data Type
- TRUNCATE TABLE Statement (CDH 5.5 or higher only)
- Tuning Impala for Performance
U
- UNION Clause
- Upgrading Hive
- USE Statement
- Using Spark SQL
- Using the Impala Shell (impala-shell Command)
V
- VARCHAR Data Type (CDH 5.2 or higher only)
- VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP Functions
W
| © 2016 Cloudera, Inc. All rights reserved | ||
| Terms and Conditions Privacy Policy |