toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync
https://pgsync.com
MIT License
1.11k stars 174 forks source link

Compeletion type #425

Closed parisa-mghd closed 1 year ago

parisa-mghd commented 1 year ago

PGSync version: 2.5.0

Postgres version:

Elasticsearch version:

Redis version:

Python version:

Problem Description: I'm trying to transform the mapping to "compeletion" type and I get below error

[
    {
        "database": "n",
        "index": "n",
        "nodes": {
            "table": "n",
            "columns": [
                "id",
                "name",
                "name2",
                "name3"

            ],
            "transform": {
                           "mapping": {
                            "name": { "type": "compeletion"}
                              }
                           }
        }
    }
]

Error Message (if any):

Required materialized view columns not present on _view. Please re-run bootstrap
parisa-mghd commented 1 year ago

solved with dropping materialized view