Index
A
- ABS(DOUBLE a) function / Built-in function support in Impala
- aggregation functions
- ALL privilege / The ALL privilege
- alter command / Table- and database-specific commands
- ALTER TABLE statement / The ALTER TABLE statement
- ANALYZE TABLE statement / Table and column statistics
- Apache Hive
- about / Working with Apache Hive
- ASCII(STRING str) function / Built-in function support in Impala
- auditing
- about / Auditing
- authentication
- through Kerberos / Authentication through Kerberos
- authorization
- about / Authorization
- SELECT privilege / The SELECT privilege
- INSERT privilege / The INSERT privilege
- ALL privilege / The ALL privilege
- AVG aggregation function / Functions
- Avro file format / The Avro file format with Impala tables
B
- -B command / Query-specific options
- BETWEEN operator / Operators
- BIGINT data type / Data types
- BIN(BIGINT a) function / Built-in function support in Impala
- block locality issue / The block locality issue
- block location tracking
- enabling / Enabling block location tracking
- BOOLEAN data type / Data types
- built-in functions / Built-in function support in Impala
C
- ! command / General commands
- -c command / General command-line options
- CASE function / Built-in function support in Impala
- CAST() function / Data types, The type conversion function
- CAST operator / Data types
- Clause
- Cloudera Manager
- used, for installing Impala / Installing Impala with Cloudera Manager
- URL / Installing Impala with Cloudera Manager
- Impala, installing without / Installing Impala without Cloudera Manager
- Impala upgrading, parcels used / Upgrading Impala using parcels with Cloudera Manager
- Impala upgrading, packages used / Upgrading Impala using packages with Cloudera Manager
- Impala, upgrading with / Upgrading Impala without Cloudera Manager
- using, for Impala / Using Cloudera Manager for Impala
- administration with / Administration with Cloudera Manager
- used, to troubleshoot platform issues / Using Cloudera Manager to troubleshoot problems
- Impala log analysis / Impala log analysis using Cloudera Manager
- web interface / Using the Impala web interface for monitoring and troubleshooting
- Impala statestore web interface, using / Using the Impala statestore web interface
- Impala Maintenance Mode, using / Using the Impala Maintenance Mode
- Impala events, checking / Checking Impala events
- cluster statistics
- COALESCE function / Built-in function support in Impala
- command-line options
- about / Impala-shell command-line options with brief explanations
- general / General command-line options
- query-specific options / Query-specific options
- secure connectivity-specific options / Secure connectivity-specific options
- command-line options, connection-specific
- about / Connection-specific options
- -I hostname or -impalad=hostname / Connection-specific options
- -r or -refresh_after_connect / Connection-specific options
- -d database_name or -database database_name / Connection-specific options
- command-line options, general
- -h or --help / General command-line options
- -v or --version / General command-line options
- -V or --verbose / General command-line options
- --quiet / General command-line options
- -c / General command-line options
- command-line options, query-specific
- -q query or -query=query / Query-specific options
- -o filename or --output_file filename / Query-specific options
- -B or --delimited / Query-specific options
- -f query_file_name or -query_file=query_file_name / Query-specific options
- -p or --show_profiles / Query-specific options
- command-line options, secure connectivity-specific
- -k or --kerberos / Secure connectivity-specific options
- -s Kerberos_service_name or -kerberos_service_name=Kerberos_service_name / Secure connectivity-specific options
- commands
- general commands / General commands
- query-specific commands / Query-specific commands
- table- and database-specific commands / Table- and database-specific commands
- commands, general
- help command / General commands
- version command / General commands
- history command / General commands
- shell command / General commands
- ! command / General commands
- refresh command / General commands
- connect command / General commands
- exit command / General commands
- quit command / General commands
- commands, query-specific
- set command / Query-specific commands
- unset command / Query-specific commands
- profile command / Query-specific commands
- explain command / Query-specific commands
- commands, table- and database-specific commands
- about / Table- and database-specific commands
- alter command / Table- and database-specific commands
- describe command / Table- and database-specific commands
- insert command / Table- and database-specific commands
- drop command / Table- and database-specific commands
- select command / Table- and database-specific commands
- use command / Table- and database-specific commands
- compression types
- CONCAT(STRING a, STRING b..) function / Built-in function support in Impala
- Configuration-related issues
- about / Impala configuration-related issues
- block locality issue / The block locality issue
- native checksumming issues / Native checksumming issues
- Configuration Variables List
- connect command / General commands
- connectivity issues
- between Impala shell and Impala daemon / Connectivity between Impala shell and Impala daemon
- JDBC-specific connectivity issues / ODBC/JDBC-specific connectivity issues
- ODBC-specific connectivity issues / ODBC/JDBC-specific connectivity issues
- COS(DOUBLE a) function / Built-in function support in Impala
- COUNT aggregation function / Functions
- count SQL command / Using various types of SQL statements
- CREATE DATABASE statement / The CREATE DATABASE statement
- CREATE EXTERNAL TABLE statement / The CREATE EXTERNAL TABLE statement, Internal and external tables
- CREATE TABLE statement / The CREATE TABLE statement
D
- --delimited command / Query-specific options
- -database database_name command / Connection-specific options
- -d database_name command / Connection-specific options
- -d option / Impala-shell command-line options with brief explanations
- data
- loading, from HDFS / Loading data from HDFS using the LOAD DATA statement
- loading, into Impala tables / Commands for loading data into Impala tables
- loading, into Impala table, from HDFS / Loading data into the Impala table from HDFS
- visualizing, Impala used / Data visualization using Impala
- database-specific statements
- about / Database-specific statements
- CREATE DATABASE statement / The CREATE DATABASE statement
- DROP DATABASE statement / The DROP DATABASE statement
- SHOW DATABASES statement / The SHOW DATABASES statement
- using, in example / Using database-specific query sentence in an example
- DataNode
- short-circuit read, performing / Enabling Impala to perform short-circuit read on DataNode
- dataset
- data type / Data types
- BOOLEAN / Data types
- INT / Data types
- BIGINT / Data types
- SMALLINT / Data types
- TINYINT / Data types
- DOUBLE / Data types
- FLOAT / Data types
- STRING / Data types
- SUM / Data types
- TIMESTAMP / Data types
- DATEDIFF(date1, date2) function / Built-in function support in Impala
- describe command / Table- and database-specific commands, Database and table specific commands
- DESCRIBE statement / The DESCRIBE statement
- distinct command / SQL queries against the example database
- DISTINCT operator / Operators
- distinct SQL command / Using various types of SQL statements
- DOUBLE data type / Data types
- Dremel
- about / Technology behind Impala
- drop command / Table- and database-specific commands
- DROP DATABASE statement / The DROP DATABASE statement
- DROP TABLE statement / The DROP TABLE statement
E
- ETL
- example scenario, creating
- about / Creating an example scenario
- automobiles (automobiles.txt) / Example dataset one – automobiles (automobiles.txt)
- motorcycles (motorcycles.txt) / Example dataset two – motorcycles (motorcycles.txt)
- data and schema, considerations / Data and schema considerations
- exit command / General commands
- EXPLAIN clause / Query-specific SQL statements in Impala, Using various types of SQL statements
- explain command / Query-specific commands, Using various types of SQL statements
- external table / Internal and external tables
- Extract Transform Load (ETL) activity / Loading data from HDFS using the LOAD DATA statement
F
- -f query_file_name command / Query-specific options
- file format
- file formats
- FLOAT data type / Data types
- FLOOR(DOUBLE a) function / Built-in function support in Impala
- FORMAT() function / Functions
- FROM clause / Clauses
- functions
G
- Google Dremel
- URL / Technology behind Impala
- GROUP BY clause / Clauses
H
- --help command / General command-line options
- -h command / General command-line options
- hardware
- dependency / Hardware dependency
- HAVING clause / Clauses
- HBase
- about / Working with HBase
- URL / Working with HBase
- and Impala / Impala and HBase
- HBase tables
- querying, Impala used / Using Impala to query HBase tables
- HDFS
- about / Working with HDFS
- specific commands / HDFS specific commands
- data, loading into Impala table / Loading data into the Impala table from HDFS
- HDFS-specific problems / HDFS-specific problems
- help command / General commands
- High Availability (HA) / Impala High Availability
- Hive
- dependency, for Impala / Dependency on Hive for Impala
- and Impala / Impala and Hive
- and Impala, differences / Key differences between Impala and Hive, Why Impala is faster than Hive in query processing
- HiveQL statements / Unsupported SQL statements in Impala
I
- -I hostname command / Connection-specific options
- -impalad=hostname command / Connection-specific options
- IF function / Built-in function support in Impala
- Impala
- requisites / Impala requirements
- dependency on Hive / Dependency on Hive for Impala
- dependency on Java / Dependency on Java for Impala
- hardware dependency / Hardware dependency
- networking requisites / Networking requirements
- user account requisites / User account requirements
- installing / Installing Impala
- installing, with Cloudera Manager / Installing Impala with Cloudera Manager
- installing, without Cloudera Manager / Installing Impala without Cloudera Manager
- configuring, after installation / Configuring Impala after installation
- starting / Starting Impala
- stopping / Stopping Impala
- restarting / Restarting Impala
- upgrading / Upgrading Impala
- upgrading, parcels with Cloudera Manager used / Upgrading Impala using parcels with Cloudera Manager, Upgrading Impala using packages with Cloudera Manager
- upgrading, with Cloudera Manager / Upgrading Impala without Cloudera Manager
- core components / Impala core components
- execution architecture / The Impala execution architecture
- with Apache Hive / Working with Apache Hive
- with HDFS / Working with HDFS
- with HBase / Working with HBase
- security / Impala security
- Cloudera Manager, using / Using Cloudera Manager for Impala
- VIEWS, defining / Defining VIEWS in Impala
- SQL statements, comments / Comments in Impala SQL statements
- built-in function support / Built-in function support in Impala
- SQL statements, unsupported / Unsupported SQL statements in Impala
- example, scenario / Creating an example scenario
- administration / Impala administration
- statestore UI / The Impala statestore UI
- High Availability (HA) / Impala High Availability
- single point of failure / Single point of failure in Impala
- file format, selecting / Choosing an appropriate file format and compression type for better performance
- troubleshooting / Troubleshooting various problems
- and MapReduce / Impala and MapReduce
- and Hive / Impala and Hive
- and Hive, differences / Key differences between Impala and Hive, Why Impala is faster than Hive in query processing
- and Extract, Transform, Load (ETL) / Impala and Extract, Transform, Load (ETL)
- processing, strategy / Impala processing strategy
- and HBase / Impala and HBase
- using, to query HBase tables / Using Impala to query HBase tables
- file formats / File formats and compression types supported in Impala
- compression types / File formats and compression types supported in Impala
- compression types, processing / Processing different file and compression types in Impala
- file formats, processing / Processing different file and compression types in Impala
- unsupported features / The unsupported features in Impala
- resources / Impala resources
- issues, URL / Impala resources
- technology / Technology behind Impala
- used, for data visualization / Data visualization using Impala
- and Tableau / Tableau and Impala
- and Microsoft Excel / Microsoft Excel and Impala
- and Microstrategy / Microstrategy and Impala
- and Zoomdata / Zoomdata and Impala
- Real-time query, on Hadoop / Real-time query with Impala on Hadoop
- Real-time query subscription / Real-time query subscriptions with Impala
- Impala, core components
- about / Impala core components
- Impala daemon / Impala daemon
- Impala statestore / Impala statestore
- Impala metadata and metastore / Impala metadata and metastore
- programing interface / The Impala programming interface
- Impala, security
- authorization / Authorization
- authentication / Authentication through Kerberos
- auditing / Auditing
- guidelines / Impala security guidelines for a higher level of protection
- Impala specific guidelines / Impala security guidelines for a higher level of protection
- system specific guidelines / Impala security guidelines for a higher level of protection
- impala-shell command / Impala-shell command-line options with brief explanations
- Impala 1.2.0 (Beta)
- Impala daemon
- about / Impala daemon
- Impala Daemon (impalad) / Using Cloudera Manager for Impala
- Impala Download
- URL / Impala resources
- Impala events
- checking / Checking Impala events
- Impala metadata and metastore
- about / Impala metadata and metastore
- Impala nodes
- Impala performance, fine tuning
- about / Fine-tuning Impala performance
- partitioning / Partitioning
- join queries / Join queries
- table and column statistics / Table and column statistics
- Impala performance, improving
- about / Improving performance
- block location tracking, enabling / Enabling block location tracking
- native checksumming, enabling / Enabling native checksumming
- Impala, enabling / Enabling Impala to perform short-circuit read on DataNode
- Impala nodes, adding / Adding more Impala nodes to achieve higher performance
- memory usage, optimizing / Optimizing memory usage during query execution
- query execution / Query execution dependency on memory
- resource isolation, using / Using resource isolation
- Impala Query Planner / Why Impala is faster than Hive in query processing
- Impala Shell
- launching / Launching Impala shell, Launching the Impala shell
- connecting, to remotely located impalad daemon / Connecting impala-shell to the remotely located impalad daemon
- command-line options / Impala-shell command-line options with brief explanations
- connection-specific options / Connection-specific options
- query-specific options / Query-specific options
- secure connectivity-specific options / Secure connectivity-specific options
- commands / Impala-shell command reference, General commands
- database commands / Database and table specific commands
- table commands / Database and table specific commands
- and Impala daemon, connectiivty issues / Connectivity between Impala shell and Impala daemon
- Impala Source
- URL / Impala resources
- Impala statestore
- about / Impala statestore
- Impala Statestore Daemon (statstored) / Using Cloudera Manager for Impala
- Impala table
- data, loading from HDFS / Loading data into the Impala table from HDFS
- Impala tables
- data, loading in / Commands for loading data into Impala tables
- regular Text file format / The regular text file format with Impala tables
- Avro file format / The Avro file format with Impala tables
- RCFile file format / The RCFile file format with Impala tables
- SequenceFile file format / The SequenceFile file format with Impala tables
- Parquet file format / The Parquet file format with Impala tables
- Impala v1.x Latest Documentation
- URL / Impala resources
- Input file format-specific issues
- insert command / Table- and database-specific commands
- INSERT INTO statement / The INSERT statement
- INSERT OVERWRITE statement / The INSERT statement
- INSERT privilege / The INSERT privilege
- INSERT statement / The INSERT statement
- installation
- Impala / Installing Impala
- INT data type / Data types
- internal table / Internal and external tables
- ISNULL function / Built-in function support in Impala
J
- Java
- dependency, for Impala / Dependency on Java for Impala
- JDBC-specific connectivity issues / ODBC/JDBC-specific connectivity issues
- JOIN clause / Query-specific SQL statements in Impala
- join queries
- about / Join queries
- JOIN query / Table and column statistics
K
- --kerberos command / Secure connectivity-specific options
- -k command / Secure connectivity-specific options
- -kerberos_service_name=Kerberos_service_name command / Secure connectivity-specific options
L
- LCASE() function / Functions
- LEN() function / Functions
- LENGTH(STRING s) function / Built-in function support in Impala
- LIKE operator / Operators
- LIMIT clause / Clauses
- LOAD DATA statement / Loading data from HDFS using the LOAD DATA statement
- log analysis
- Cloudera Manager used / Impala log analysis using Cloudera Manager
M
- Maintenance Mode / Using the Impala Maintenance Mode
- MapReduce
- about / Impala and MapReduce
- MAX aggregation function / Functions
- Memory consumption details
- Microsoft Excel
- about / Microsoft Excel and Impala
- Microstrategy
- about / Microstrategy and Impala
- URL / Microstrategy and Impala
- MID() function / Functions
- MIN aggregation function / Functions
N
- native checksumming
- enabling / Enabling native checksumming
- native checksumming issues / Native checksumming issues
- NOW() function / Functions, Built-in function support in Impala
O
- --output_file filename command / Query-specific options
- -o filename command / Query-specific options
- ODBC-specific connectivity issues / ODBC/JDBC-specific connectivity issues
- ODBO / Microsoft Excel and Impala
- OLAP / Microsoft Excel and Impala
- operator
- ORDER BY clause / Clauses
P
- -p command / Query-specific options
- packages
- with Cloudera Manager, used for upgrading Impala / Upgrading Impala using packages with Cloudera Manager
- parcels
- with Cloudera Manager, used for upgrading Impala / Upgrading Impala using parcels with Cloudera Manager
- Parquet file format / The Parquet file format with Impala tables
- PARTITIONED BY method / Partitioning
- partitioning
- about / Partitioning
- PI() function / Built-in function support in Impala
- platform-specific issues
- about / Platform-specific issues
- Impala port mapping issues / Impala port mapping issues
- HDFS-specific problems / HDFS-specific problems
- port mapping issues / Impala port mapping issues
- profile command / Query-specific commands
Q
- --quiet command / General command-line options
- -q option / Impala-shell command reference
- -q query command / Query-specific options
- -query=query command / Query-specific options
- query-specific issues
- about / Query-specific issues
- query-specific SQL statements
- about / Query-specific SQL statements in Impala
- EXPLAIN clause / Query-specific SQL statements in Impala
- REFRESH clause / Query-specific SQL statements in Impala
- JOIN clause / Query-specific SQL statements in Impala
- query execution
- memory usage, optimizing on / Optimizing memory usage during query execution
- on memory / Query execution dependency on memory
- query performance, testing
- about / Testing query performance
- queries, benchmarking / Benchmarking queries
- data locality, verifying / Verifying data locality
- query_file=query_file_name command / Query-specific options
- quit command / General commands
R
- -r command / Connection-specific options
- -refresh_after_connect command / Connection-specific options
- RAND(INT seed) function / Built-in function support in Impala
- RCFile file format / The RCFile file format with Impala tables
- Real-time query
- with Impala, on Hadoop / Real-time query with Impala on Hadoop
- REFRESH clause / Query-specific SQL statements in Impala
- refresh command / General commands
- regular Text file format / The regular text file format with Impala tables
- resource isolation
- using / Using resource isolation
- REVERSE(STRING a) function / Built-in function support in Impala
- ROUND() function / Functions
- RTQ
S
- --show_profiles command / Query-specific options
- -s Kerberos_service_name command / Secure connectivity-specific options
- Scalar functions
- select command / Table- and database-specific commands, Using various types of SQL statements
- SELECT privilege / The SELECT privilege
- SELECT statement / The SELECT statement
- SequenceFile file format / The SequenceFile file format with Impala tables
- set command / Query-specific commands
- short-circuit read
- performing, on DataNode / Enabling Impala to perform short-circuit read on DataNode
- show databases command / Impala-shell command reference
- SHOW DATABASES statement / The SHOW DATABASES statement
- SHOW TABLES statement / The SHOW TABLES statement
- SMALLINT data type / Data types
- SQL join operation
- with example database / SQL join operation with the example database
- SQL statements, types / Using various types of SQL statements
- SQL language statements
- database-specific statements / Database-specific statements
- table-specific statements / Table-specific statements
- SQL queries
- against example database / SQL queries against the example database
- SQL statements
- statestore web interface
- STRING data type / Data types
- substr SQL command / Using various types of SQL statements
- SUM data type / Data types
T
- table-specific statements
- about / Table-specific statements
- CREATE TABLE statement / The CREATE TABLE statement
- CREATE EXTERNAL TABLE statement / The CREATE EXTERNAL TABLE statement
- ALTER TABLE statement / The ALTER TABLE statement
- DROP TABLE statement / The DROP TABLE statement
- SHOW TABLES statement / The SHOW TABLES statement
- DESCRIBE statement / The DESCRIBE statement
- INSERT statement / The INSERT statement
- SELECT statement / The SELECT statement
- external table / Internal and external tables
- internal table / Internal and external tables
- Tableau
- about / Tableau and Impala
- TIMESTAMP data type / Data types
- TINYINT data type / Data types
- TO_DATE(STRING date) function / Built-in function support in Impala
- troubleshooting
- configuration-related issues / Impala configuration-related issues
- connectivity issues / Various connectivity issues
- query-specific issues / Query-specific issues
- User Access Control (UAC)-specific issues / Issues specific to User Access Control (UAC)
- platform-specific issues / Platform-specific issues
- input file format-specific issues / Input file format-specific issues
- type-conversion function / The type conversion function
U
- UCASE() function / Functions
- unset command / Query-specific commands
- use command / Table- and database-specific commands
- user-defined aggregate (UDA) / The unsupported features in Impala
- user-defined aggregate functions (UDA) / What is new in Impala 1.2.0 (Beta)
- user-defined functions (UDF) / What is new in Impala 1.2.0 (Beta)
- User Access Control (UAC)-specific issues
- User Defined Aggregation Functions (UDAF) / Unsupported SQL statements in Impala
- User Defined Table Generating Functions (UDTF) / Unsupported SQL statements in Impala
V
- --verbose command / General command-line options
- --version command / General command-line options
- -v command / General command-line options
- version command / General commands
- VIEWS
- about / Defining VIEWS in Impala
W
- web interface
- for monitoring / Using the Impala web interface for monitoring and troubleshooting
- for troubleshooting / Using the Impala web interface for monitoring and troubleshooting
- WHERE clause / Clauses
- WITH clause / Clauses
Y
- YEAR(STRING date) function / Built-in function support in Impala
Z
- Zoomdata
- about / Zoomdata and Impala