Impala schema objects

Schema objects are logical structures that you use to store and manipulate data. Schema objects include databases, tables, views, functions, etc.

Impala aliases
You can assign an alias to the names of tables, columns, or column expressions in SQL statements and use the alias when referencing the table or column in the same statement. You typically specify aliases that are shorter, easier to remember, or both than the original names. The aliases are printed in the query header, making them useful for self-documenting output.
Impala databases
Databases are logical containers for a group of tables, and each database defines a separate namespace.
Overview of Impala functions
Functions let you apply arithmetic, string, or other computations and transformations to Impala data. You typically use them in SELECT lists and WHERE clauses to filter and format query results so that the result set is exactly what you want, with no further processing needed on the application side.
Impala identifiers
Identifiers are the names of databases, tables, or columns that you specify when you create the objects.
Impala tables
Tables are the primary containers for data in Impala.
Impala views
Views are lightweight logical constructs that act as aliases for queries. You can specify a view name in a query (a SELECT statement or the SELECT portion of an INSERT statement) where you would usually specify a table name.

Parent topic: Impala SQL