You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In Release 0.6 we introduced [Flyway](https://flywaydb.org/) to handle schema migrations in PostgreSQL.
7
-
Flyway is integrated into `core` and for now on all migrations will be run automatically on
8
-
`core` start. It uses table `flyway_schema_history` in the same database (also created automatically) to keep track of already applied migrations.
9
-
So no specific maintenance should be needed.
6
+
7
+
In Release 0.6 we introduced [Flyway](https://flywaydb.org/) to handle schema migrations in PostgreSQL. Flyway is integrated into `core` and for now on all migrations will be run automatically on `core` start. It uses table `flyway_schema_history` in the same database \(also created automatically\) to keep track of already applied migrations. So no specific maintenance should be needed.
10
8
11
9
If you already have existing deployment of feast 0.5 - Flyway will detect existing tables and omit first baseline migration.
12
10
13
-
After `core` started you should have `flyway_schema_history` look
14
-
like this
15
-
```
11
+
After `core` started you should have `flyway_schema_history` look like this
12
+
13
+
```text
16
14
>> select version, description, script, checksum from flyway_schema_history
17
15
18
16
version | description | script | checksum
@@ -24,34 +22,44 @@ version | description | scr
24
22
In this release next major schema changes were done:
25
23
26
24
* Source is not shared between FeatureSets anymore. It's changed to 1:1 relation
27
-
and source's primary key is now auto-incremented number.
25
+
26
+
and source's primary key is now auto-incremented number.
27
+
28
28
* Due to generalization of Source `sources.topics` & `sources.bootstrap_servers` columns were deprecated.
29
-
They will be replaced with `sources.config`. Data migration handled by code when respected Source is used.
30
-
`topics` and `bootstrap_servers` will be deleted in the next release.
31
-
* Job (table `jobs`) is no longer connected to `Source` (table `sources`) since it uses consolidated source for optimization purposes.
32
-
All data required by Job would be embedded in its table.
33
29
34
-
New Models (tables):
35
-
* feature_statistics
30
+
They will be replaced with `sources.config`. Data migration handled by code when respected Source is used.
31
+
32
+
`topics` and `bootstrap_servers` will be deleted in the next release.
33
+
34
+
* Job \(table `jobs`\) is no longer connected to `Source`\(table `sources`\) since it uses consolidated source for optimization purposes.
35
+
36
+
All data required by Job would be embedded in its table.
37
+
38
+
New Models \(tables\):
39
+
40
+
* feature\_statistics
36
41
37
42
Minor changes:
38
-
* FeatureSet has new column version (see [proto](https://github.com/feast-dev/feast/blob/master/protos/feast/core/FeatureSet.proto) for details)
43
+
44
+
* FeatureSet has new column version \(see [proto](https://github.com/feast-dev/feast/blob/master/protos/feast/core/FeatureSet.proto) for details\)
39
45
* Connecting table `jobs_feature_sets` in many-to-many relation between jobs & feature sets
40
-
has now `version` and `delivery_status`.
41
46
42
-
## Migration 0.4 -> 0.6
47
+
has now `version` and `delivery_status`.
48
+
49
+
## Migration 0.4 -> 0.6
43
50
44
51
### Database
45
-
For all versions earlier than 0.5 seamless migration is not feasible due to earlier breaking changes and
46
-
creation of new database will be required.
47
52
48
-
Since database will be empty - first (baseline) migration would be applied:
53
+
For all versions earlier than 0.5 seamless migration is not feasible due to earlier breaking changes and creation of new database will be required.
54
+
55
+
Since database will be empty - first \(baseline\) migration would be applied:
49
56
50
-
```
57
+
```text
51
58
>> select version, description, script, checksum from flyway_schema_history
* We currently support [optional consolidation](https://github.com/feast-dev/feast/pull/825/files#diff-11e36b0d5cfc6742aa51adf2812b664eR85) of jobs by source. This allows one job to populate many stores if all the store share a source. The upside is we need to provision less jobs. The downside is we need to managing the ingestion of data into stores independently becomes a lot more complicated. For the time being we will allow a flag to switch between both consolidation strategies, but we may remove consolidation in the future if it introduces too much complexity in the overall design.
Online feature retrieval works in much the same way as batch retrieval, with one important distinction: Online stores only maintain the current state of features. No historical data is served.
0 commit comments