在好例子网,分享、交流、成长!
您当前所在位置:首页SQL 开发实例SQL基础 → impala参考.pdf

impala参考.pdf

SQL基础

下载此实例
  • 开发语言:SQL
  • 实例大小:3.71M
  • 下载次数:6
  • 浏览次数:111
  • 发布时间:2020-07-28
  • 实例类别:SQL基础
  • 发 布 人:cocoa2003
  • 文件格式:.pdf
  • 所需积分:2
 相关标签: Impala pal 参考 IM

实例介绍

【实例简介】
【实例截图】

【核心代码】

Contents
Introducing Apache Impala...................................................................................14
Impala Benefits................................................................................................................................................... 14
How Impala Works with Apache Hadoop.........................................................................................................14
Primary Impala Features.....................................................................................................................................15
Impala Concepts and Architecture.......................................................................15
Components of the Impala Server......................................................................................................................15
The Impala Daemon............................................................................................................................... 15
The Impala Statestore............................................................................................................................. 16
The Impala Catalog Service................................................................................................................... 16
Developing Impala Applications........................................................................................................................ 17
Overview of the Impala SQL Dialect.................................................................................................... 17
Overview of Impala Programming Interfaces........................................................................................18
How Impala Fits Into the Hadoop Ecosystem...................................................................................................18
How Impala Works with Hive............................................................................................................... 18
Overview of Impala Metadata and the Metastore..................................................................................19
How Impala Uses HDFS........................................................................................................................19
How Impala Uses HBase....................................................................................................................... 19
Planning for Impala Deployment..........................................................................19
Impala Requirements.......................................................................................................................................... 20
Supported Operating Systems................................................................................................................ 20
Hive Metastore and Related Configuration............................................................................................20
Java Dependencies.................................................................................................................................. 20
Networking Configuration Requirements...............................................................................................21
Hardware Requirements..........................................................................................................................21
User Account Requirements...................................................................................................................21
Guidelines for Designing Impala Schemas........................................................................................................21
Installing Impala.....................................................................................................23
What is Included in an Impala Installation........................................................................................................23
Managing Impala....................................................................................................24
Post-Installation Configuration for Impala.........................................................................................................24
Configuring Impala to Work with ODBC......................................................................................................... 26
Configuring Impala to Work with JDBC...........................................................................................................26
Configuring the JDBC Port....................................................................................................................26
Choosing the JDBC Driver.................................................................................................................... 26
Enabling Impala JDBC Support on Client Systems.............................................................................. 27
Establishing JDBC Connections.............................................................................................................28
Notes about JDBC and ODBC Interaction with Impala SQL Features................................................. 28
Kudu Considerations for DML Statements............................................................................................29
Upgrading Impala...................................................................................................29
 | Contents | iii
Upgrading Impala............................................................................................................................................... 29
Impala Upgrade Considerations......................................................................................................................... 30
List of Reserved Words Updated in Impala 3.0.................................................................................... 30
Decimal V2 Used by Default in Impala 3.0.......................................................................................... 30
Behavior of Column Aliases Changed in Impala 3.0............................................................................ 30
Default PARQUET_ARRAY_RESOLUTION Changed in Impala 3.0................................................ 30
Enable Clustering Hint for Inserts......................................................................................................... 30
Deprecated Query Options Removed in Impala 3.0.............................................................................. 31
Fine-grained Privileges Added in Impala 3.0........................................................................................ 31
refresh_after_connect Impala Shell Option Removed in Impala 3.0..................................................... 31
Default Setting Changes......................................................................................................................... 31
Starting Impala....................................................................................................... 31
Starting Impala from the Command Line..........................................................................................................32
Modifying Impala Startup Options.................................................................................................................... 32
Configuring Impala Startup Options through the Command Line.........................................................32
Checking the Values of Impala Configuration Options.........................................................................35
Startup Options for impalad Daemon.................................................................................................... 35
Startup Options for statestored Daemon................................................................................................ 35
Startup Options for catalogd Daemon....................................................................................................35
Impala Tutorials..................................................................................................... 35
Tutorials for Getting Started.............................................................................................................................. 36
Explore a New Impala Instance............................................................................................................. 36
Load CSV Data from Local Files.......................................................................................................... 41
Point an Impala Table at Existing Data Files........................................................................................ 43
Describe the Impala Table......................................................................................................................44
Query the Impala Table..........................................................................................................................45
Data Loading and Querying Examples.................................................................................................. 46
Advanced Tutorials.............................................................................................................................................48
Attaching an External Partitioned Table to an HDFS Directory Structure............................................48
Switching Back and Forth Between Impala and Hive...........................................................................50
Cross Joins and Cartesian Products with the CROSS JOIN Operator...................................................51
Dealing with Parquet Files with Unknown Schema.......................................................................................... 53
Impala Administration........................................................................................... 67
Admission Control and Query Queuing.............................................................................................................68
Overview of Impala Admission Control................................................................................................68
Concurrent Queries and Admission Control.......................................................................................... 69
Memory Limits and Admission Control................................................................................................ 69
How Impala Admission Control Relates to Other Resource Management Tools..................................69
How Impala Schedules and Enforces Limits on Concurrent Queries....................................................70
How Admission Control works with Impala Clients (JDBC, ODBC, HiveServer2).............................70
SQL and Schema Considerations for Admission Control..................................................................... 71
Configuring Admission Control............................................................................................................. 71
Resource Management for Impala..................................................................................................................... 76
How Resource Limits Are Enforced......................................................................................................76
impala-shell Query Options for Resource Management........................................................................ 77
Limitations of Resource Management for Impala................................................................................. 77
Setting Timeout Periods for Daemons, Queries, and Sessions..........................................................................77
Increasing the Statestore Timeout.......................................................................................................... 77
Setting the Idle Query and Idle Session Timeouts for impalad.............................................................77
Setting Timeout and Retries for Thrift Connections to the Backend Client.......................................... 78
 | Contents | iv
Cancelling a Query................................................................................................................................. 78
Using Impala through a Proxy for High Availability........................................................................................78
Overview of Proxy Usage and Load Balancing for Impala...................................................................79
Choosing the Load-Balancing Algorithm.............................................................................................. 79
Special Proxy Considerations for Clusters Using Kerberos.................................................................. 80
Example of Configuring HAProxy Load Balancer for Impala..............................................................81
Managing Disk Space for Impala Data..............................................................................................................83
Impala Security.......................................................................................................84
Security Guidelines for Impala.......................................................................................................................... 85
Securing Impala Data and Log Files................................................................................................................. 86
Installation Considerations for Impala Security.................................................................................................86
Securing the Hive Metastore Database.............................................................................................................. 86
Securing the Impala Web User Interface...........................................................................................................86
Configuring TLS/SSL for Impala...................................................................................................................... 87
Using the Command Line...................................................................................................................... 87
Using TLS/SSL with Business Intelligence Tools.................................................................................88
Specifying TLS/SSL Minimum Allowed Version and Ciphers.............................................................88
Enabling Sentry Authorization for Impala.........................................................................................................88
The Sentry Privilege Model................................................................................................................... 88
Starting the impalad Daemon with Sentry Authorization Enabled........................................................89
Using Impala with the Sentry Service (Impala 1.4 or higher only).......................................................90
Using Impala with the Sentry Policy File..............................................................................................90
Setting Up Schema Objects for a Secure Impala Deployment.............................................................. 95
Privilege Model and Object Hierarchy.................................................................................................. 96
Debugging Failed Sentry Authorization Requests................................................................................. 99
The DEFAULT Database in a Secure Deployment...............................................................................99
Impala Authentication.........................................................................................................................................99
Enabling Kerberos Authentication for Impala..................................................................................... 100
Enabling LDAP Authentication for Impala......................................................................................... 102
Using Multiple Authentication Methods with Impala..........................................................................104
Configuring Impala Delegation for Hue and BI Tools........................................................................105
Auditing Impala Operations............................................................................................................................. 105
Durability and Performance Considerations for Impala Auditing....................................................... 105
Format of the Audit Log Files............................................................................................................. 106
Which Operations Are Audited............................................................................................................106
Viewing Lineage Information for Impala Data............................................................................................... 107
Impala SQL Language Reference.......................................................................107
Comments..........................................................................................................................................................108
Data Types........................................................................................................................................................ 108
ARRAY Complex Type (Impala 2.3 or higher only).......................................................................... 109
BIGINT Data Type...............................................................................................................................112
BOOLEAN Data Type......................................................................................................................... 113
CHAR Data Type (Impala 2.0 or higher only)....................................................................................114
DECIMAL Data Type (Impala 3.0 or higher only).............................................................................118
DOUBLE Data Type............................................................................................................................ 122
FLOAT Data Type............................................................................................................................... 124
INT Data Type......................................................................................................................................125
MAP Complex Type (Impala 2.3 or higher only)............................................................................... 126
REAL Data Type..................................................................................................................................130
SMALLINT Data Type........................................................................................................................ 130
STRING Data Type..............................................................................................................................131
STRUCT Complex Type (Impala 2.3 or higher only).........................................................................132
 | Contents | v
TIMESTAMP Data Type..................................................................................................................... 138
TINYINT Data Type............................................................................................................................ 146
VARCHAR Data Type (Impala 2.0 or higher only)............................................................................147
Complex Types (Impala 2.3 or higher only)....................................................................................... 149
Literals...............................................................................................................................................................181
Numeric Literals................................................................................................................................... 181
String Literals........................................................................................................................................182
Boolean Literals....................................................................................................................................183
Timestamp Literals............................................................................................................................... 183
NULL.................................................................................................................................................... 184
SQL Operators.................................................................................................................................................. 185
Arithmetic Operators............................................................................................................................ 185
BETWEEN Operator............................................................................................................................ 188
Comparison Operators.......................................................................................................................... 189
EXISTS Operator..................................................................................................................................190
ILIKE Operator.....................................................................................................................................193
IN Operator........................................................................................................................................... 194
IREGEXP Operator.............................................................................................................................. 197
IS DISTINCT FROM Operator............................................................................................................198
IS NULL Operator................................................................................................................................200
IS TRUE Operator................................................................................................................................201
LIKE Operator...................................................................................................................................... 201
Logical Operators..................................................................................................................................202
REGEXP Operator................................................................................................................................205
RLIKE Operator....................................................................................................................................207
Impala Schema Objects and Object Names.....................................................................................................208
Overview of Impala Aliases.................................................................................................................208
Overview of Impala Databases............................................................................................................ 210
Overview of Impala Functions.............................................................................................................210
Overview of Impala Identifiers............................................................................................................ 212
Overview of Impala Tables..................................................................................................................213
Overview of Impala Views.................................................................................................................. 217
Impala SQL Statements....................................................................................................................................221
DDL Statements....................................................................................................................................221
DML Statements................................................................................................................................... 222
ALTER TABLE Statement.................................................................................................................. 223
ALTER VIEW Statement.....................................................................................................................237
COMPUTE STATS Statement.............................................................................................................238
CREATE DATABASE Statement....................................................................................................... 246
CREATE FUNCTION Statement.........................................................................................................248
CREATE ROLE Statement (Impala 2.0 or higher only)..................................................................... 254
CREATE TABLE Statement................................................................................................................255
CREATE VIEW Statement.................................................................................................................. 269
DELETE Statement (Impala 2.8 or higher only).................................................................................271
DESCRIBE Statement.......................................................................................................................... 273
DROP DATABASE Statement............................................................................................................ 285
DROP FUNCTION Statement............................................................................................................. 287
DROP ROLE Statement (Impala 2.0 or higher only)..........................................................................288
DROP STATS Statement..................................................................................................................... 289
DROP TABLE Statement.....................................................................................................................293
DROP VIEW Statement....................................................................................................................... 295
EXPLAIN Statement............................................................................................................................ 296
GRANT Statement (Impala 2.0 or higher only).................................................................................. 299
INSERT Statement................................................................................................................................301
INVALIDATE METADATA Statement..............................................................................................311
LOAD DATA Statement......................................................................................................................313
 | Contents | vi
REFRESH Statement............................................................................................................................ 317
REVOKE Statement (Impala 2.0 or higher only)................................................................................321
SELECT Statement...............................................................................................................................322
SET Statement...................................................................................................................................... 352
SHOW Statement..................................................................................................................................392
TRUNCATE TABLE Statement (Impala 2.3 or higher only)............................................................. 411
UPDATE Statement (Impala 2.8 or higher only)................................................................................ 413
UPSERT Statement (Impala 2.8 or higher only)................................................................................. 415
USE Statement......................................................................................................................................416
Optimizer Hints.....................................................................................................................................416
Impala Built-In Functions.................................................................................................................................421
Impala Mathematical Functions........................................................................................................... 423
Impala Bit Functions............................................................................................................................ 441
Impala Type Conversion Functions..................................................................................................... 453
Impala Date and Time Functions.........................................................................................................457
Impala Conditional Functions.............................................................................................................. 508
Impala String Functions........................................................................................................................515
Impala Miscellaneous Functions.......................................................................................................... 540
Impala Aggregate Functions.................................................................................................................542
Impala Analytic Functions....................................................................................................................573
Impala User-Defined Functions (UDFs).............................................................................................. 592
SQL Differences Between Impala and Hive....................................................................................................609
HiveQL Features not Available in Impala...........................................................................................609
Semantic Differences Between Impala and HiveQL Features.............................................................610
Porting SQL from Other Database Systems to Impala....................................................................................611
Porting DDL and DML Statements..................................................................................................... 611
Porting Data Types from Other Database Systems..............................................................................612
SQL Statements to Remove or Adapt..................................................................................................614
SQL Constructs to Doublecheck.......................................................................................................... 615
Next Porting Steps after Verifying Syntax and Semantics.................................................................. 616
Using the Impala Shell (impala-shell Command)..............................................617
impala-shell Configuration Options................................................................................................................. 617
Summary of impala-shell Configuration Options................................................................................ 617
impala-shell Configuration File............................................................................................................621
Connecting to impalad through impala-shell................................................................................................... 622
Running Commands and SQL Statements in impala-shell..............................................................................623
Rerunning impala-shell Commands..................................................................................................... 627
impala-shell Command Reference....................................................................................................................628
Tuning Impala for Performance.........................................................................631
Impala Performance Guidelines and Best Practices.........................................................................................632
Performance Considerations for Join Queries..................................................................................................634
How Joins Are Processed when Statistics Are Unavailable................................................................ 635
Overriding Join Reordering with STRAIGHT_JOIN.......................................................................... 635
Examples of Join Order Optimization..................................................................................................636
Table and Column Statistics.............................................................................................................................641
Overview of Table Statistics................................................................................................................ 641
Overview of Column Statistics............................................................................................................ 642
How Table and Column Statistics Work for Partitioned Tables..........................................................644
Generating Table and Column Statistics..............................................................................................646
Detecting Missing Statistics................................................................................................................. 649
Manually Setting Table and Column Statistics with ALTER TABLE................................................ 651
Examples of Using Table and Column Statistics with Impala............................................................ 652
 | Contents | vii
Benchmarking Impala Queries......................................................................................................................... 656
Controlling Impala Resource Usage.................................................................................................................657
Runtime Filtering for Impala Queries (Impala 2.5 or higher only)................................................................. 657
Background Information for Runtime Filtering................................................................................... 657
Runtime Filtering Internals...................................................................................................................658
File Format Considerations for Runtime Filtering...............................................................................659
Wait Intervals for Runtime Filters....................................................................................................... 659
Query Options for Runtime Filtering...................................................................................................659
Runtime Filtering and Query Plans......................................................................................................659
Examples of Queries that Benefit from Runtime Filtering..................................................................660
Tuning and Troubleshooting Queries that Use Runtime Filtering.......................................................661
Limitations and Restrictions for Runtime Filtering............................................................................. 662
Using HDFS Caching with Impala (Impala 2.1 or higher only)..................................................................... 662
Overview of HDFS Caching for Impala.............................................................................................. 662
Setting Up HDFS Caching for Impala.................................................................................................663
Enabling HDFS Caching for Impala Tables and Partitions................................................................. 663
Loading and Removing Data with HDFS Caching Enabled................................................................664
Administration for HDFS Caching with Impala.................................................................................. 665
Performance Considerations for HDFS Caching with Impala.............................................................666
Testing Impala Performance.............................................................................................................................667
Understanding Impala Query Performance - EXPLAIN Plans and Query Profiles.........................................668
Using the EXPLAIN Plan for Performance Tuning............................................................................ 669
Using the SUMMARY Report for Performance Tuning..................................................................... 669
Using the Query Profile for Performance Tuning............................................................................... 671
Detecting and Correcting HDFS Block Skew Conditions...............................................................................677
Scalability Considerations for Impala................................................................678
Impact of Many Tables or Partitions on Impala Catalog Performance and Memory Usage............................678
Scalability Considerations for the Impala Statestore....................................................................................... 679
Controlling which Hosts are Coordinators and Executors...............................................................................680
Effect of Buffer Pool on Memory Usage (Impala 2.10 and higher)................................................................680
SQL Operations that Spill to Disk...................................................................................................................681
Limits on Query Size and Complexity............................................................................................................ 684
Scalability Considerations for Impala I/O........................................................................................................684
Scalability Considerations for Table Layout....................................................................................................685
Kerberos-Related Network Overhead for Large Clusters................................................................................685
Avoiding CPU Hotspots for HDFS Cached Data............................................................................................685
Scalability Considerations for NameNode Traffic with File Handle Caching.................................................686
Partitioning for Impala Tables............................................................................686
When to Use Partitioned Tables...................................................................................................................... 687
SQL Statements for Partitioned Tables............................................................................................................687
Static and Dynamic Partitioning Clauses.........................................................................................................688
Refreshing a Single Partition............................................................................................................................688
Permissions for Partition Subdirectories.......................................................................................................... 688
Partition Pruning for Queries........................................................................................................................... 689
Checking if Partition Pruning Happens for a Query............................................................................689
What SQL Constructs Work with Partition Pruning............................................................................689
Dynamic Partition Pruning................................................................................................................... 690
Partition Key Columns..................................................................................................................................... 692
Setting Different File Formats for Partitions................................................................................................... 692
Managing Partitions..........................................................................................................................................693
Using Partitioning with Kudu Tables...............................................................................................................693
Keeping Statistics Up to Date for Partitioned Tables......................................................................................693
 | Contents | viii
How Impala Works with Hadoop File Formats................................................696
Choosing the File Format for a Table............................................................................................................. 697
Using Text Data Files with Impala Tables...................................................................................................... 698
Query Performance for Impala Text Tables........................................................................................ 698
Creating Text Tables............................................................................................................................ 699
Data Files for Text Tables................................................................................................................... 700
Loading Data into Impala Text Tables................................................................................................ 701
Using LZO-Compressed Text Files..................................................................................................... 702
Using gzip, bzip2, or Snappy-Compressed Text Files.........................................................................704
Using the Parquet File Format with Impala Tables.........................................................................................705
Creating Parquet Tables in Impala.......................................................................................................705
Loading Data into Parquet Tables........................................................................................................706
Query Performance for Impala Parquet Tables....................................................................................708
Snappy and GZip Compression for Parquet Data Files.......................................................................709
Parquet Tables for Impala Complex Types......................................................................................... 712
Exchanging Parquet Data Files with Other Hadoop Components....................................................... 712
How Parquet Data Files Are Organized.............................................................................................. 715
Compacting Data Files for Parquet Tables.......................................................................................... 716
Schema Evolution for Parquet Tables..................................................................................................717
Data Type Considerations for Parquet Tables..................................................................................... 718
Using the Avro File Format with Impala Tables.............................................................................................719
Creating Avro Tables............................................................................................................................719
Using a Hive-Created Avro Table in Impala.......................................................................................721
Specifying the Avro Schema through JSON....................................................................................... 722
Loading Data into an Avro Table........................................................................................................ 722
Enabling Compression for Avro Tables...............................................................................................722
How Impala Handles Avro Schema Evolution....................................................................................722
Data Type Considerations for Avro Tables......................................................................................... 724
Query Performance for Impala Avro Tables....................................................................................... 724
Using the RCFile File Format with Impala Tables......................................................................................... 724
Creating RCFile Tables and Loading Data..........................................................................................725
Enabling Compression for RCFile Tables........................................................................................... 726
Query Performance for Impala RCFile Tables.................................................................................... 727
Using the SequenceFile File Format with Impala Tables................................................................................727
Creating SequenceFile Tables and Loading Data................................................................................ 727
Enabling Compression for SequenceFile Tables..................................................................................728
Query Performance for Impala SequenceFile Tables.......................................................................... 729
Using Impala to Query Kudu Tables................................................................. 729
Benefits of Using Kudu Tables with Impala................................................................................................... 730
Configuring Impala for Use with Kudu...........................................................................................................730
Cluster Topology for Kudu Tables...................................................................................................... 730
Impala DDL Enhancements for Kudu Tables (CREATE TABLE and ALTER TABLE)...............................730
Primary Key Columns for Kudu Tables.............................................................................................. 731
Kudu-Specific Column Attributes for CREATE TABLE....................................................................731
Partitioning for Kudu Tables................................................................................................................735
Handling Date, Time, or Timestamp Data with Kudu.........................................................................738
How Impala Handles Kudu Metadata..................................................................................................740
Loading Data into Kudu Tables.......................................................................................................................741
Impala DML Support for Kudu Tables (INSERT, UPDATE, DELETE, UPSERT).......................................741
Consistency Considerations for Kudu Tables.................................................................................................. 742
Security Considerations for Kudu Tables........................................................................................................ 742
Impala Query Performance for Kudu Tables...................................................................................................743
 | Contents | ix
Using Impala to Query HBase Tables................................................................743
Overview of Using HBase with Impala...........................................................................................................743
Configuring HBase for Use with Impala......................................................................................................... 744
Supported Data Types for HBase Columns.....................................................................................................744
Performance Considerations for the Impala-HBase Integration...................................................................... 745
Use Cases for Querying HBase through Impala..............................................................................................750
Loading Data into an HBase Table..................................................................................................................751
Limitations and Restrictions of the Impala and HBase Integration.................................................................751
Examples of Querying HBase Tables from Impala.........................................................................................751
Using Impala with the Amazon S3 Filesystem.................................................. 753
How Impala SQL Statements Work with S3...................................................................................................754
Specifying Impala Credentials to Access Data in S3...................................................................................... 754
Loading Data into S3 for Impala Queries........................................................................................................755
Using Impala DML Statements for S3 Data........................................................................................755
Manually Loading Data into Impala Tables on S3..............................................................................755
Creating Impala Databases, Tables, and Partitions for Data Stored on S3......................................................756
Internal and External Tables Located on S3....................................................................................................757
Running and Tuning Impala Queries for Data Stored on S3.......................................................................... 759
Understanding and Tuning Impala Query Performance for S3 Data...................................................759
Restrictions on Impala Support for S3.............................................................................................................760
Best Practices for Using Impala with S3.........................................................................................................760
Using Impala with the Azure Data Lake Store (ADLS)................................... 761
Prerequisites...................................................................................................................................................... 761
How Impala SQL Statements Work with ADLS.............................................................................................761
Specifying Impala Credentials to Access Data in ADLS................................................................................ 762
Loading Data into ADLS for Impala Queries................................................................................................. 762
Using Impala DML Statements for ADLS Data..................................................................................763
Manually Loading Data into Impala Tables on ADLS........................................................................763
Creating Impala Databases, Tables, and Partitions for Data Stored on ADLS................................................763
Internal and External Tables Located on ADLS..............................................................................................765
Running and Tuning Impala Queries for Data Stored on ADLS.................................................................... 767
Understanding and Tuning Impala Query Performance for ADLS Data.............................................767
Restrictions on Impala Support for ADLS...................................................................................................... 768
Best Practices for Using Impala with ADLS...................................................................................................768
Using Impala with Isilon Storage....................................................................... 768
Using Impala Logging.......................................................................................... 769
Locations and Names of Impala Log Files......................................................................................................769
Managing Impala Logs.....................................................................................................................................770
Rotating Impala Logs....................................................................................................................................... 770
Reviewing Impala Logs....................................................................................................................................770
Understanding Impala Log Contents................................................................................................................771
Setting Logging Levels.....................................................................................................................................771
Redacting Sensitive Information from Impala Log Files................................................................................ 772
Troubleshooting Impala....................................................................................... 772
 | Contents | x
Troubleshooting Impala SQL Syntax Issues....................................................................................................772
Troubleshooting I/O Capacity Problems..........................................................................................................773
Impala Troubleshooting Quick Reference........................................................................................................773
Impala Web User Interface for Debugging......................................................................................................775
Debug Web UI for impalad................................................................................................................. 776
Breakpad Minidumps for Impala (Impala 2.6 or higher only)........................................................................ 777
Enabling or Disabling Minidump Generation......................................................................................777
Specifying the Location for Minidump Files.......................................................................................778
Controlling the Number of Minidump Files........................................................................................ 778
Detecting Crash Events........................................................................................................................ 778
Demonstration of Breakpad Feature.....................................................................................................778
Ports Used by Impala...........................................................................................780
Impala Reserved Words.......................................................................................781
List of Reserved Words....................................................................................................................................782
Impala Frequently Asked Questions.................................................................. 797
Impala Release Notes........................................................................................... 798
New Features in Apache Impala...................................................................................................................... 798
New Features in Impala 3.0................................................................................................................. 798
New Features in Impala 2.12............................................................................................................... 798
New Features in Impala 2.11............................................................................................................... 798
New Features in Impala 2.10............................................................................................................... 798
New Features in Impala 2.9................................................................................................................. 798
New Features in Impala 2.8................................................................................................................. 798
New Features in Impala 2.7................................................................................................................. 801
New Features in Impala 2.6................................................................................................................. 801
New Features in Impala 2.5................................................................................................................. 803
New Features in Impala 2.4................................................................................................................. 806
New Features in Impala 2.3................................................................................................................. 806
New Features in Impala 2.8................................................................................................................. 808
New Features in Impala 2.1................................................................................................................. 810
New Features in Impala 2.0................................................................................................................. 810
New Features in Impala 1.4................................................................................................................. 812
New Features in Impala 1.3.2.............................................................................................................. 813
New Features in Impala 1.3.1.............................................................................................................. 814
New Features in Impala 1.3................................................................................................................. 814
New Features in Impala 1.2.4.............................................................................................................. 815
New Features in Impala 1.2.3.............................................................................................................. 815
New Features in Impala 1.2.2.............................................................................................................. 815
New Features in Impala 1.2.1.............................................................................................................. 816
New Features in Impala 1.2.0 (Beta)................................................................................................... 817
New Features in Impala 1.1.1.............................................................................................................. 819
New Features in Impala 1.1................................................................................................................. 819
New Features in Impala 1.0.1.............................................................................................................. 820
New Features in Impala 1.0................................................................................................................. 820
New Features in Version 0.7 of the Impala Beta Release................................................................... 820
New Features in Version 0.6 of the Impala Beta Release................................................................... 821
New Features in Version 0.5 of the Impala Beta Release................................................................... 821
New Features in Version 0.4 of the Impala Beta Release................................................................... 821
 | Contents | xi
New Features in Version 0.3 of the Impala Beta Release................................................................... 821
New Features in Version 0.2 of the Impala Beta Release................................................................... 821
Incompatible Changes and Limitations in Apache Impala.............................................................................. 821
Incompatible Changes Introduced in Impala 3.0.x.............................................................................. 821
Incompatible Changes Introduced in Impala 2.12.x............................................................................ 822
Incompatible Changes Introduced in Impala 2.11.x............................................................................ 822
Incompatible Changes Introduced in Impala 2.10.x............................................................................ 822
Incompatible Changes Introduced in Impala 2.9.x.............................................................................. 822
Incompatible Changes Introduced in Impala 2.8.x.............................................................................. 822
Incompatible Changes Introduced in Impala 2.7.x.............................................................................. 822
Incompatible Changes Introduced in Impala 2.6.x.............................................................................. 823
Incompatible Changes Introduced in Impala 2.5.x.............................................................................. 823
Incompatible Changes Introduced in Impala 2.4.x.............................................................................. 824
Incompatible Changes Introduced in Impala 2.3.x.............................................................................. 824
Incompatible Changes Introduced in Impala 2.2.x.............................................................................. 825
Incompatible Changes Introduced in Impala 2.1.x.............................................................................. 825
Incompatible Changes Introduced in Impala 2.0.5.............................................................................. 825
Incompatible Changes Introduced in Impala 2.0.4.............................................................................. 825
Incompatible Changes Introduced in Impala 2.0.3.............................................................................. 825
Incompatible Changes Introduced in Impala 2.0.2.............................................................................. 826
Incompatible Changes Introduced in Impala 2.0.1.............................................................................. 826
Incompatible Changes Introduced in Impala 2.0.0.............................................................................. 826
Incompatible Changes Introduced in Impala 1.4.4.............................................................................. 827
Incompatible Changes Introduced in Impala 1.4.3.............................................................................. 827
Incompatible Changes Introduced in Impala 1.4.2.............................................................................. 827
Incompatible Changes Introduced in Impala 1.4.1.............................................................................. 827
Incompatible Changes Introduced in Impala 1.4.0.............................................................................. 828
Incompatible Changes Introduced in Impala 1.3.3.............................................................................. 828
Incompatible Changes Introduced in Impala 1.3.2.............................................................................. 828
Incompatible Changes Introduced in Impala 1.3.1.............................................................................. 828
Incompatible Changes Introduced in Impala 1.3.0.............................................................................. 828
Incompatible Changes Introduced in Impala 1.2.4.............................................................................. 829
Incompatible Changes Introduced in Impala 1.2.3.............................................................................. 829
Incompatible Changes Introduced in Impala 1.2.2.............................................................................. 829
Incompatible Changes Introduced in Impala 1.2.1.............................................................................. 830
Incompatible Changes Introduced in Impala 1.2.0 (Beta)................................................................... 830
Incompatible Changes Introduced in Impala 1.1.1.............................................................................. 831
Incompatible Change Introduced in Impala 1.1...................................................................................831
Incompatible Changes Introduced in Impala 1.0................................................................................. 831
Known Issues and Workarounds in Impala..................................................................................................... 831
Impala Known Issues: Startup..............................................................................................................831
Impala Known Issues: Performance.....................................................................................................832
Impala Known Issues: JDBC and ODBC Drivers............................................................................... 833
Impala Known Issues: Resources.........................................................................................................833
Impala Known Issues: Correctness...................................................................................................... 834
Impala Known Issues: Interoperability................................................................................................ 835
Impala Known Issues: Limitations.......................................................................................................836
Impala Known Issues: Miscellaneous.................................................................................................. 837
Impala Known Issues: Crashes and Hangs.......................................................................................... 837
Fixed Issues in Apache Impala........................................................................................................................ 838
Issues Fixed in Impala 3.0................................................................................................................... 838
Issues Fixed in Impala 2.12................................................................................................................. 838
Issues Fixed in Impala 2.11................................................................................................................. 838
Issues Fixed in Impala 2.10................................................................................................................. 838
Issues Fixed in Impala 2.9.0................................................................................................................ 838
Issues Fixed in Impala 2.8.0................................................................................................................ 838
 | Contents | xii
Issues Fixed in Impala 2.7.0................................................................................................................ 838
Issues Fixed in Impala 2.6.3................................................................................................................ 838
Issues Fixed in Impala 2.6.2................................................................................................................ 838
Issues Fixed in Impala 2.6.0................................................................................................................ 838
Issues Fixed in Impala 2.5.4................................................................................................................ 840
Issues Fixed in Impala 2.5.2................................................................................................................ 840
Issues Fixed in Impala 2.5.1................................................................................................................ 840
Issues Fixed in Impala 2.5.0................................................................................................................ 840
Issues Fixed in Impala 2.4.1................................................................................................................ 843
Issues Fixed in Impala 2.4.0................................................................................................................ 843
Issues Fixed in Impala 2.3.4................................................................................................................ 843
Issues Fixed in Impala 2.3.2................................................................................................................ 843
Issues Fixed in Impala 2.3.1................................................................................................................ 846
Issues Fixed in Impala 2.3.0................................................................................................................ 846
Issues Fixed in Impala 2.2.10.............................................................................................................. 846
Issues Fixed in Impala 2.2.9................................................................................................................ 846
Issues Fixed in Impala 2.2.8................................................................................................................ 848
Issues Fixed in Impala 2.2.7................................................................................................................ 848
Issues Fixed in Impala Impala 2.2.5.................................................................................................... 850
Issues Fixed in Impala 2.2.3................................................................................................................ 851
Issues Fixed in Impala 2.2.1................................................................................................................ 851
Issues Fixed in Impala 2.2.0................................................................................................................ 851
Issues Fixed in Impala 2.1.10.............................................................................................................. 853
Issues Fixed in Impala 2.1.7................................................................................................................ 853
Issues Fixed in Impala 2.1.6................................................................................................................ 853
Issues Fixed in Impala 2.1.5................................................................................................................ 854
Issues Fixed in Impala 2.1.4................................................................................................................ 854
Issues Fixed in Impala 2.1.3................................................................................................................ 855
Issues Fixed in Impala 2.1.2................................................................................................................ 856
Issues Fixed in Impala 2.1.1................................................................................................................ 856
Issues Fixed in Impala 2.1.0................................................................................................................ 857
Issues Fixed in Impala 2.0.5................................................................................................................ 857
Issues Fixed in Impala 2.0.4................................................................................................................ 857
Issues Fixed in Impala 2.0.3................................................................................................................ 858
Issues Fixed in Impala 2.0.2................................................................................................................ 858
Issues Fixed in Impala 2.0.1................................................................................................................ 859
Issues Fixed in Impala 2.0.0................................................................................................................ 859
Issues Fixed in Impala 1.4.4................................................................................................................ 861
Issues Fixed in Impala 1.4.3................................................................................................................ 861
Issues Fixed in Impala 1.4.2................................................................................................................ 861
Issues Fixed in Impala 1.4.1................................................................................................................ 861
Issues Fixed in Impala 1.4.0................................................................................................................ 862
Issues Fixed in Impala 1.3.3................................................................................................................ 863
Issues Fixed in Impala 1.3.2................................................................................................................ 863
Issues Fixed in Impala 1.3.1................................................................................................................ 864
Issues Fixed in Impala 1.3.0................................................................................................................ 865
Issues Fixed in the 1.2.4 Release.........................................................................................................867
Issues Fixed in the 1.2.3 Release.........................................................................................................868
Issues Fixed in the 1.2.2 Release.........................................................................................................868
Issues Fixed in the 1.2.1 Release.........................................................................................................869
Issues Fixed in the 1.2.0 Beta Release................................................................................................ 870
Issues Fixed in the 1.1.1 Release.........................................................................................................870
Issues Fixed in the 1.1.0 Release.........................................................................................................871
Issues Fixed in the 1.0.1 Release.........................................................................................................871
Issues Fixed in the 1.0 GA Release.....................................................................................................873
Issues Fixed in Version 0.7 of the Beta Release................................................................................. 875
 | Contents | xiii
Issues Fixed in Version 0.6 of the Beta Release................................................................................. 876
Issues Fixed in Version 0.5 of the Beta Release................................................................................. 877
Issues Fixed in Version 0.4 of the Beta Release................................................................................. 877
Issues Fixed in Version 0.3 of the Beta Release................................................................................. 878
Issues Fixed in Version 0.2 of the Beta Release................................................................................. 878

标签: Impala pal 参考 IM

实例下载地址

impala参考.pdf

不能下载?内容有错? 点击这里报错 + 投诉 + 提问

好例子网口号:伸出你的我的手 — 分享

网友评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。

关于好例子网

本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享,对搜索内容的合法性不具有预见性、识别性、控制性,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论平台是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定,若资源存在侵权或相关问题请联系本站客服人员,点此联系我们。关于更多版权及免责申明参见 版权及免责申明

;
报警