question

jrodkelley_194102 avatar image
jrodkelley_194102 asked bettina.swynnerton commented

Getting NPE in the Data Modeling notebook of the week 2 workshop

In trying to complete the Data Modeling workbook for Week 2... I was able to complete the step of "Describe Table" and examine the "schema? However, when I went to the next step and ran the cell I receive a "java.lang.NullPointerException" and am unable then to complete the next step "Points of interest in the data above." I'm new to programming and am sure its something I'm doing wrong.

workshopastrastudio
2 comments
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

chucks240_168748 avatar image chucks240_168748 commented ·

I also noticed some of the cells are missing the select statements. View the cell contents and see if it's blank.

0 Likes 0 ·
bettina.swynnerton avatar image bettina.swynnerton ♦♦ chucks240_168748 commented ·

Hi @chucks240_168748,

some of the cells have been left blank on purpose to encourage the users to practice these statements.

Let us know if you have any problems with these practice exercises, we want to help.

0 Likes 0 ·
bettina.swynnerton avatar image
bettina.swynnerton answered

Hi @jrodkelley_194102,

there have been a couple of instances where the first cell is not executed completely. This is the cell where the schema is set up and data is populated into some of the tables, including the table killrvideo.video_recommendations.

Would you try to run this first cell again, and if the problem persists, could you attach a screenshot when you see the NullPointerException, as it would be helpful to see how this presents itself in Studio.

Thanks very much for your help.

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

chucks240_168748 avatar image
chucks240_168748 answered bettina.swynnerton commented

I had the same issue as above in the data types notebook, and figure out I needed to do the query, but I said to just execute the cell initially.



1 comment Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

bettina.swynnerton avatar image bettina.swynnerton ♦♦ commented ·

thanks, this explains both the error and the solution!

0 Likes 0 ·