topic Re: Mounting Data IOException in Get Started Discussions

Mounting Data IOException

EricMa — Fri, 19 Jul 2024 01:35:51 GMT

Hello,

I am currently taking a course from Coursera for data science using SQL. For one of our assignments we need to mount some data by running a script that has been provided to us by the class. When I run the script I receive the following error.

IOException: s3a://AKIAJDDJNXBZ3FJHWLDQ:wD26wPuGshDAIObuOFKPBsQ8n5LPd0aJYWyS2H+%2F@davis-dsv1071/data/fire-calls/fire-calls-truncated-comma.csv at com.databricks.backend.daemon.data.client.DbfsClient.sendIdempotent(DbfsClient.scala:70) at com.databricks.backend.daemon.driver.DriverWrapper.run(DriverWrapper.scala:290)

I would much appreciate it if anyone could advise on what could be causing this error and how to possibly fix it.

Below is also a view of the notebook that contains this script.

Thank you.

Re: Mounting Data IOException

EricMa — Sat, 20 Jul 2024 03:33:05 GMT

Thank you for the feedback Kaniz. Unfortunately I did not mount any of this data myself or create the notebook that this data mount is contained in. The notebook was given to me by the instructor of the course I am taking. The course I am taking had me import the notebooks for course using the URL https://files.training.databricks.com/courses/ucdavis/Lessons.dbc . If you import this URL yourself you will see that the notebooks for this script I am trying to run as well as the dataset mounts are contained in the first folder titled "Includes."

Is this issue something that the instructor of the course needs to resolve on their end? Below is a screenshot of the notebook that contains the dataset mounts.

Re: Mounting Data IOException

EricMa — Mon, 22 Jul 2024 23:21:53 GMT

Is this issue something that the instructor of the course needs to resolve on their end? Below is a screenshot of the notebook that contains the dataset mounts.

Thank you.

Re: Mounting Data IOException

Tawfeeq — Wed, 31 Jul 2024 10:02:20 GMT

Hi EricMa, If you have solved the issue, can you please help me?

Re: Mounting Data IOException

Tawfeeq — Wed, 31 Jul 2024 10:02:46 GMT

Hi EricMa, If you have solved the issue, can you please help me?

Re: Mounting Data IOException

EricMa — Tue, 06 Aug 2024 01:28:39 GMT

Hi Kaniz,

I sent you a follow up question a couple of weeks ago for further assistance and I just wanted to see if you are able to answer my response. I would very much appreciate it. Thank you.

Re: Mounting Data IOException

EricMa — Tue, 06 Aug 2024 01:41:25 GMT

Hi Tawfeeq,

Unfortunately I have not received a response from Kaniz to the follow up question I sent her. I just sent her another reply asking if she could get back to me about it. I flagged a couple of the videos in Coursera explaining the issue and I haven't heard anything yet. I'm going to send Coursera an e-mail by filling out a contact support form informing them of the issue. If I was you I would do these things as well since I think if enough students flag videos and reach out to them directly by contacting customer support I think it might get their attention. If I don't hear anything from Coursera I'm going to send UC Davis an e-mail informing them of the issue. I found an e-mail address, cpeinfo@ucdavis.edu, listed at the bottom of their web page for the course at https://extension.ucdavis.edu/section/learn-sql-basics-data-science-specialization-coursera

Re: Mounting Data IOException

ArpitSharma — Wed, 07 Aug 2024 03:31:00 GMT

This seems to be a new issue. I am also having exact same issue. I deleted all my account information. then signed up again using another email address and it is still the same issue. Some link somewhere is broken in the course material and Amazon bucket.

@Retired_mod Please advise the next steps. Multiple people having same issue !!!

Re: Mounting Data IOException

Tawfeeq — Thu, 08 Aug 2024 13:00:09 GMT

Hi EricMa,

I will send an Email to the mentioned mail-id. Try uploading the file as mentioned in '1.5 - import data'. Did you complete the first module?

Re: Mounting Data IOException

Tawfeeq — Thu, 08 Aug 2024 13:06:26 GMT

Hi ArpitSharma,
I am from India. I completed the first module. If you are okay you could contact me.
Mail-id - stawfeeqofficial@gmail.com

Re: Mounting Data IOException

Tawfeeq — Thu, 08 Aug 2024 13:23:12 GMT

Hi People,
Use this path

"dbfs:/databricks-datasets/learning-spark-v2/sf-fire/sf-fire-calls.csv".
This works fine. In case any doubt please contact me.
Mail-id : stawfeeqofficial@gmail.com

Re: Mounting Data IOException

Retired_mod — Thu, 08 Aug 2024 15:06:26 GMT

Hi @EricMa and @ArpitSharma, To expedite your request, please list your concerns on our ticketing portal. Our support staff would be able to act faster on the resolution (our standard resolution time is 24-48 hours).

Re: Mounting Data IOException

BrunoGomesWeb — Mon, 19 Aug 2024 20:47:00 GMT

and the others files, like

/mnt/davis/fire-calls/fire-calls-truncated.json

Re: Mounting Data IOException

smdatainsights — Sat, 31 Aug 2024 13:49:59 GMT

Any updates on this? I'm experiencing the same issue.

Re: Mounting Data IOException

shyamadur — Tue, 10 Sep 2024 10:27:59 GMT

Hi Tawfeeq,

I am facing the same issue. Can you help me solve? I have already send the details to your email ID.

Thank you,

Shyam

Re: Mounting Data IOException

Tawfeeq — Wed, 25 Sep 2024 04:42:09 GMT

Hi Shyamadur, I will contact you via mail.

Re: Mounting Data IOException

Tawfeeq — Wed, 25 Sep 2024 04:46:43 GMT

Hi BrunoGomesWeb, this json path is a faulty one. I couldn't find the right path on the ineternet.

Re: Mounting Data IOException

kishormendhe — Sun, 13 Oct 2024 18:02:31 GMT

How we can use this csv for our use ?

Re: Mounting Data IOException

nataliedo74 — Mon, 14 Oct 2024 20:39:45 GMT

Thanks for the responses EricMa and Tawfeeq. I was able to load both tables in and was able to complete Module 1 exercises.

Re: Mounting Data IOException

YunHai — Sun, 10 Nov 2024 06:23:00 GMT

I have resolved this issue. Please see the Databricks notebook below.

Thanks to Tawfeeq for the helpful method.

https://databricks-prod-cloudfront.cloud.databricks.com/public/4027ec902e239c93eaaa8714f173bcfc/2108650195107345/4043517972039275/8748925243774050/latest.html