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/06 23:56:31 UTC
[incubator-pinot] branch te-database-schema-application-index
created (now 92943ba)
This is an automated email from the ASF dual-hosted git repository.
apucher pushed a change to branch te-database-schema-application-index
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git.
at 92943ba [TE] database - add missing schema fields and index to application_index
This branch includes the following new commits:
new 92943ba [TE] database - add missing schema fields and index to application_index
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[incubator-pinot] 01/01: [TE] database - add missing schema fields
and index to application_index
Posted by ap...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
apucher pushed a commit to branch te-database-schema-application-index
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
commit 92943bafa9fb3c1027bbaf8bfc47e025db36ee87
Author: Alexander Pucher <al...@alexpucher.com>
AuthorDate: Fri Mar 6 15:54:59 2020 -0800
[TE] database - add missing schema fields and index to application_index
---
.../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