You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by ap...@apache.org on 2020/03/11 17:44:30 UTC
[incubator-pinot] branch master updated: [TE] database - add
missing schema fields and index to application_index (#5124)
This is an automated email from the ASF dual-hosted git repository.
apucher pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
The following commit(s) were added to refs/heads/master by this push:
new d8fabec [TE] database - add missing schema fields and index to application_index (#5124)
d8fabec is described below
commit d8fabecbf8ae7d15beb9f2de93713952348fb324
Author: Alexander Pucher <ap...@apache.org>
AuthorDate: Wed Mar 11 10:44:17 2020 -0700
[TE] database - add missing schema fields and index to application_index (#5124)
Co-authored-by: Alexander Pucher <al...@alexpucher.com>
---
.../thirdeye-pinot/src/main/resources/schema/create-schema.sql | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
diff --git a/thirdeye/thirdeye-pinot/src/main/resources/schema/create-schema.sql b/thirdeye/thirdeye-pinot/src/main/resources/schema/create-schema.sql
index 6126f25..00e6180 100644
--- a/thirdeye/thirdeye-pinot/src/main/resources/schema/create-schema.sql
+++ b/thirdeye/thirdeye-pinot/src/main/resources/schema/create-schema.sql
@@ -267,7 +267,6 @@ ALTER TABLE `classification_config_index` ADD UNIQUE `classification_config_uniq
create index classification_config_name_index on classification_config_index(name);
create index classification_config_base_id_idx ON classification_config_index(base_id);
-
create table if not exists entity_to_entity_mapping_index (
from_urn varchar(500) not null,
to_urn varchar(500) not null,
@@ -325,10 +324,13 @@ create index config_name_idx on config_index(name);
create index config_base_id_idx ON config_index(base_id);
create table application_index (
+ base_id bigint(20) not null,
+ create_time timestamp,
+ update_time timestamp default current_timestamp,
application VARCHAR (200) not null,
- recipients VARCHAR(1000) NOT NULL,
- base_id bigint(20) not null
+ recipients VARCHAR(1000) NOT NULL
);
+create index application_application_idx on application_index(application);
create table if not exists alert_snapshot_index (
base_id bigint(20) not null,
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org