Can we update/port this Elasticsearch plugin for arcadedb

[tolgaulas]

This a feature request, this is a good plugin for Elasticsearch, can we have it for arcadedb?
https://github.com/orientechnologies/orientdb-elasticsearch

[lvca]

What's your use case?

[lvca]

You can use ArcadeDB's Full-Text index that uses Lucene (the same as ES) to tokenize works.

[lvca]

@tolgaulas did you use that plugin with OrientDB before?

[tolgaulas]

Hey, sorry for late response. No I did not. But your previous inquiry made us rethink it; as arcadedb now supports many protocol i.e postgresql etc we are now playing around with its grafana integration; so far import from orientdb was not successful with postgresql driver, nor with native json (which worked well with orientdb). I guess you can close this one, we may open a new one for sharing our endeavor.

[lvca]

@tolgaulas did you import the database from orientdb with the orientdb importer https://docs.arcadedb.com/#OrientDB-Importer?

[tolgaulas]

Yes, asked my colleague who will share the details here as much as possible without revealing too much data :)

[lvca]

Ok, since you're a sponsor you can write to support at arcadedb.com if you have sensitive data. If you need to sign an NDA please send it to the same email address.

[tolgaulas]

Will do if things is harder to sanitize for public, otherwise we like to keep public for future generations. :)

[tolgaulas]

Ok i think the problem is not import, but our habits from oriendtb sql language. In orientdb, we had v1, v2 vertices and v1v2 edge from v1 to v2. So, in orientdb we would have v1.out_v1v2 and v2.in_v1v2 and v1v2.in pointing to v1 and v1v2.out pointing to v2. And we used to have some sql queries like select expand(out_v1v2) from v1 to access to v1v2 via vertex; or select expand(in) from v1v2 to access to v1 via edge. But I guess this logic is changed in arcadedb.

When we create the v1,v2 and v1v2 and add related records, select from v1 does not show any out_* records, actually nothing related to any edges.

Similarly, when we rung select from v1v2 it display @in and @out pointing to the respected vertices as in db. But in this time select expand(@out) from v1v2 return empty.

Is there any formula or should i open a new issue for this as this is not related with this issue topic.

[tolgaulas]

And on the grafana part, definetly their postgres adapter is not compatible with current arcadeb; we're not getting results we're getting with postgres clients out of arcadedb. Also we could not try mongodb as it requries grafana enterprise. And for redis, redis plugin in grafana needs specific parameters on server to connect to. it can not recognize the driver as a redis server to connect to.
So far, we could fetch data with in grafana with HTTP/JSON adapter out of arcadedb,
which satisfied our needs of Elasticsearch migrator as we can use arcadedb with grafana.

[tolgaulas]

This is select from v1v2 :

{
  "result": {
    "vertices": [
      {
        "p": {
          "foo": "bar"
        },
        "r": "#25:0",
        "t": "v2",
        "i": 1,
        "o": 0
      },
      {
        "p": {
          "hello": "world"
        },
        "r": "#1:0",
        "t": "v1",
        "i": 0,
        "o": 1
      }
    ],
    "records": [
      {
        "@out": "#1:0",
        "@rid": "#49:0",
        "@in": "#25:0",
        "@type": "v1v2",
        "@cat": "e"
      },
      {
        "@out": 0,
        "@rid": "#25:0",
        "@in": 1,
        "@type": "v2",
        "foo": "bar",
        "@cat": "v"
      },
      {
        "@out": 1,
        "@rid": "#1:0",
        "@in": 0,
        "@type": "v1",
        "@cat": "v",
        "hello": "world"
      }
    ],
    "edges": [
      {
        "p": {},
        "r": "#49:0",
        "t": "v1v2",
        "i": "#25:0",
        "o": "#1:0"
      }
    ]
  },
  "user": "root",
  "version": "21.12.1-SNAPSHOT (build 94c9efa44b0430f8a79bf2e8b572c2fc81a7d50a/1638857567344/main)"
}

and this is select from v1:

{
  "result": {
    "vertices": [
      {
        "p": {
          "hello": "world"
        },
        "r": "#1:0",
        "t": "v1",
        "i": 0,
        "o": 1
      }
    ],
    "records": [
      {
        "@out": 1,
        "@rid": "#1:0",
        "@in": 0,
        "@type": "v1",
        "@cat": "v",
        "hello": "world"
      }
    ],
    "edges": []
  },
  "user": "root",
  "version": "21.12.1-SNAPSHOT (build 94c9efa44b0430f8a79bf2e8b572c2fc81a7d50a/1638857567344/main)"
}