Help：question and confusion after finishing the installation of MIMIC-IV-2.2

[washingtonwuyi]

Hello guys!Here is the problem description:after completing the installation of MIMIC-IV-2.2 via SQL Shell,I did the test of my build and it seemed that everything went the right way.However,next time I reentered the SQL Shell and retested my build,it came out with an error. Where have I missed?Any solutions?Thanks！

[heisenbug-1]

what happens when you run SHOW SEARCH_PATH; ?

[alistairewj]

You might be excluding the semi-colon ; required at the end of the SHOW statement

[washingtonwuyi]

Thank you guys for your replies and your concern.Actually I'm new to the codes,github,and of course the psql ~so I followed the MIMIC official instructions which can be found here：https://mimic.mit.edu/docs/gettingstarted/local/install-mimic-locally-windows/，and today I've tried it again.I installed the MIMIC-IV-2.2 into the psql,then verified my build by using the official instructions like this:"select icustay_id, intime, outtime from icustays limit 10;" I did it immediately after finishing the installation of the database without close the SQL Shell,and it came out with results,which went so normal.Then I restarted the SQL Shell(closed it then reopened it),did the same verification by using the same command "select icustay_id, intime, outtime from icustays limit 10;" It came out with an error.

[washingtonwuyi]

This is what I've got after typing in SHOW SEARCH_PATH;

[tompollard]

@washingtonwuyi I would strongly suggest working with the instance of the database on Google BigQuery, unless you need to be hosting it locally. Instructions for working in the cloud are at: https://mimic.mit.edu/docs/gettingstarted/cloud/

If you need to continue with a locally hosted version of the database, I would begin by following a psql tutorial. From a quick Google, https://tomcam.github.io/postgres/ looks like it covers the commands you need.

Basically it looks like the database engine can't find the icustays table specified in your command. Usually you see this kind of error if either:

1. the current user doesn't have permission to see/query the table or
2. the table is not available on the current search path

I think your problem is 2. To fix this, you need to locate the table that you're interested in, and then re-run your query. It's been a while since I used postgres, but from the top of my head this might help:

• Begin with \l to list the databases.
• Connect to the database containing the data with \c <name>
• List the schema on this database with \dn
• Set your search path to the appropriate schema with set search_path to <schema>
• You can view a list of tables with \dt
• If the schema contains the icustays table, your query will run.

[washingtonwuyi]

Thank you, guys! Problem solved! There are so many warm-hearted people here! I truly appreciate the help and suggestions from all of you. Thanks to the MIMIC team and the community, which is pretty good and cool, I've received a lot of support and gained valuable experience.