arcadedb icon indicating copy to clipboard operation
arcadedb copied to clipboard

IMPORT DATABASE not work as expected

Open xtay opened this issue 10 months ago • 2 comments

ArcadeDB Version:

tried with 24.2.1, 24.1.1, 23.12.1

OS and JDK Version:

Linux 6.6.16-linuxkit - OpenJDK 64-Bit Server VM 11.0.22 (Temurin-11.0.22+7) (docker image)

Expected behavior

exported database cannot be imported

Actual behavior

exported database should be imported

Steps to reproduce

  • create a database (e.g test) and build a simple graph (any graph is fine, it seems has nothing to do with the content)
  • export the database test with command: EXPORT DATABASE file://test.jsonl.gz OVERWRITE true
  • just drop and recreate the test database。
  • import file into current test database with command: IMPORT DATABASE file://exports/test.jsonl.gz WITH database = 'test'
  • after the import operation, test database ends with NOTHING inside...

SOME REMARK

I clone the source and try debug, it seems that the implementation of importers are all about import format from other kind of databases and never handles arcadedb's own format. seems to be a missing feature?

xtay avatar Apr 06 '24 06:04 xtay

and unique field is missing from the exported jsonl

this is from the exported jsonl

"person_7_256124489999602":{"type":"LSM_TREE","bucket":"person_7","properties":["age"],"nullStrategy":"SKIP"}

and this is from select from schema: types

                {
                    "name": "person[age]",
                    "typeName": "person",
                    "type": "LSM_TREE",
                    "unique": false,
                    "properties": [
                        "age"
                    ],
                    "automatic": true
                },

xtay avatar Apr 06 '24 08:04 xtay

See also: https://github.com/ArcadeData/arcadedb/issues/645

gramian avatar Apr 06 '24 08:04 gramian