Unable to import data to local PostgreSQL DB.
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
Prerequisites
Windows OS
Description
Tried to import as per https://mimic.mit.edu/docs/gettingstarted/local/install-mimic-locally-windows/ but receive answer through integrated PSQL Tool:
"psql:C:/Tools/mimic-code-master/buildmimic/postgres/postgres_load_data_7zip.sql:31: error: 7z e -so ADMISSIONS.csv.gz: child process exited with exit code 1"
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the Windows installation instructions at the linked MIMIC documentation and inspect postgres/postgres_load_data_7zip.sql, especially line 31. Reproduce the integrated PSQL Tool command involving ADMISSIONS.csv.gz and the 7z error. Done means identifying why the import fails on Windows and documenting or correcting the supported import path.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 32/100