tree 76f80951339db0ee5c451628a6ca314295deec3d
parent d06943c27563cf69ce3a5f739b5f71aba0989ddc
author Anurag Mantripragada <anuragmantri93@gmail.com> 1550607398 -0800
committer Impala Public Jenkins <impala-public-jenkins@cloudera.com> 1573643053 +0000

IMPALA-2112: Support primary key/foreign key constraints as part of
create table in Impala.

This is the first of several changes to use informational, unenforced
primary key(pk) and foreign key(fk) specifications in Impala.
The parent JIRA for this effort is IMPALA-3531.

This change adds support for adding pk/fk information during create
table DDLs. There is only limited SQL syntax support as of now and will
add various other SQL styles including ANSI syntax support in later
changes. Currently the only supported way of adding fk/pk information
is after the column definitions. Examples are:

CREATE TABLE pk(col1 INT, col2 STRING, PRIMARY KEY(col1, col2));

CREATE TABLE fk(id INT, col1 INT, col2 STRING, PRIMARY KEY(id),
FOREIGN KEY(col1, col2) REFERENCES pk(col1, col2));

In the current implementation, manual specification of constraint names
is not supported. Internally we use UUIDs for contraint name generation.
Additionally, three constraint states are supported to comply with
Hive's implementation which were taken from Oracle.
   DISABLE (default true)
   NOVALIDATE (default true)
   RELY (default true)
More info here:
https://docs.oracle.com/database/121/DWHSG/schemas.htm#DWHSG9053

These constraints can be optionally specified after each PK/FK
specification like:

CREATE TABLE pk(id INT, PRIMARY KEY(id) DISABLE, NOVALIDATE, RELY);

However, a specification like this will throw an analysis errror:

CREATE TABLE pk(id INT, PRIMARY KEY(id) ENABLE, VALIDATE, RELY);

Notes:
- toSql support is not fully functional. Observability changes like showing
  PK/FK information in DESCRIBE output will be done separately.
- Retrieval of primary keys and foreign keys is currently not supported
  in Local Catalog Mode.

Tests:
Added tests to:
 - AnalyzeDDLTest#TestCreateTable
 - ParserTest#TestCreateTable
 - ToSqlTest#TestCreateTable
 - Built against both Hive-2 and Hive-3
Change-Id: Id03d8d4d41a2ac1b15e7060e2a013e334d044ee7
Reviewed-on: http://gerrit.cloudera.org:8080/14592
Reviewed-by: Impala Public Jenkins <impala-public-jenkins@cloudera.com>
Tested-by: Impala Public Jenkins <impala-public-jenkins@cloudera.com>