Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot Import Exported Parquet Database #203

Closed
mxwli opened this issue Aug 15, 2024 · 1 comment
Closed

Cannot Import Exported Parquet Database #203

mxwli opened this issue Aug 15, 2024 · 1 comment
Assignees

Comments

@mxwli
Copy link

mxwli commented Aug 15, 2024

When a database is exported, all column names are prefixed by a.. A property labeled id is now a.id inside the parquet file. This is a problem because the explorer then cannot recognise the dataset if you try loading it:
image
Probably the best solution would be for the core to support syntax like the following:

COPY table TO 'output.csv'

This is a known problem, and would solve issues with importing exported data elsewhere as well.
Supporting a. prefixes solves this issue as well.

@mewim mewim self-assigned this Aug 15, 2024
mewim added a commit that referenced this issue Aug 17, 2024
mewim added a commit that referenced this issue Aug 17, 2024
@mewim
Copy link
Member

mewim commented Aug 17, 2024

Fixed in #207

@mewim mewim closed this as completed Aug 17, 2024
mewim added a commit that referenced this issue Aug 17, 2024
* Fix #203

* Fix #202
mewim added a commit that referenced this issue Aug 19, 2024
* Fix grammar generation

* Publish next branch as dev build (#151)

* Update Dockerfile to install libatomic1

* Implemented query progress (#152)

* Implemented query progress

* Run linters

* Fix grammar generation

* Publish next branch as dev build (#151)

* Update Dockerfile to install libatomic1

* Implemented query progress

* Run linters

* Publish next branch as dev build (#151)

* Implemented query progress

* Run linters

* Implemented feedback

---------

Co-authored-by: Lint Bot <[email protected]>
Co-authored-by: Chang Liu <[email protected]>

* Update kuzu

* Fix deduplication issue (#172)

* Update kuzu

* Data import UI (#174)

* X

* Update kuzu

* Update kuzu

* Update grammar

* X

* X

* X

* X

* X

* X

* X

* X

* X

* X

* X

* Add dialog when files are initially selected

* X

* X

* Improve parquet format detection

* X

* X

* X

* Minor fix

* Fix custom CSV format issues for previewing and type detection (#175)

* X

* X

* X

* X

* X

* X

* Additional import ui fixes I (#176)

* Refactor ImporterViewFileProcessingModal with ImporterViewProcessingModal

* Fix column ignore functionality

* Additional validation rules for import ui (#177)

* Fix preview header display

* X

* Address column name change for from and to keys

* X

* X

* X

* X

* X

* Refactor ImporterViewValidationModal component for error display

* Refactor planning to use DDL module

* Import UI fix (#178)

* Handle simple import cases independently

* Refactor ImporterViewValidationModal and ImporterViewProcessingModal components

* Improve uploading efficiency with multer dependency (#179)

* Improve uploading efficiency with multer dependency

* X

* Lint

* X

* X

* Fix several issues in planning

* Lint

* Additional fixes (#180)

* Fix table name handling with special chars

* Delete temporary files in Import.js router

* X

* Refactor

* X

* Lint

* Import UI fix (#181)

* Improve wording

* Improve UI consistency

* Update kuzu

* Update grammar

* Update server API routes for read-only mode

* Bump kuzu to 0.5.0

* Address #183 (#194)

* Fix rel validation (#195)

* Enable src and dst key validation for existing rel tables

* Add file remove confirmation hack

* Address 188 (#196)

* Address #188

* Improve error message

* Improve style for very long table name (#199)

* Make column name case insensitive (#200)

* Add in-memory mode support

* Update kuzu

* Update submodule

* Address comments in #201 (#206)

* Fix #203

* Fix #202

* Fix #209 (#211)

* Handle #210

* Update grammar

---------

Co-authored-by: Mattias <[email protected]>
Co-authored-by: Lint Bot <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants