mimic iii to sql unable to import data
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
^
mimic=# \set ON_ERROR_STOP 1
mimic=# \set mimic_data_dir 'F:/mimic-iii-clinical-database-1.4'
mimic=# \i F:/PostgreSQL_scripts/postgres_load_data_7zip.sql
psql:F:/PostgreSQL_scripts/postgres_load_data_7zip.sql:31: 错误: 关系 "admissions" 不存在
ERROR: 管道正在被关闭。
psql:F:/PostgreSQL_scripts/postgres_load_data_7zip.sql:31: 错误: 7z e -so ADMISSIONS.csv.gz: 子进程已退出, 退出码为 2
mimic=# 7z
mimic-# \set mimic_data_dir 'F:/TEMP'
mimic-# \i F:/PostgreSQL_scripts/postgres_load_data.sql
psql:F:/PostgreSQL_scripts/postgres_load_data.sql:31: 错误: 关系 "admissions" 不存在
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 postgres_load_data_7zip.sql and postgres_load_data.sql, especially line 31, and verify the database setup steps that should create the admissions relation before loading data. Reproduce the command shown in psql and compare the two scripts; done means the import no longer fails because admissions is missing.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100