KX Fundamentals Capstone

Community Support
1

I am having an error in regards to the KX Fundamentals Capstone, I got up to excercise 2.2 yesterday with all the tests passing. Today I loaded my laptop back up to continue my progress. All of my code was still there however all the tables had dissapeared. I went to run te code again so that I could continue however when I tried to load excercise 1.1 again, I kept getting part. I have tried to run the setup in the terminal a few times and I have tried to restart the entire thing a few times with no luck.

I tried the solution from this forum https://community.kx.com/t5/KX-Academy/Exercise-1-1-Capstone-Fundamentals-Project/td-p/13817 , however, I kept getting the same issue.

 

Has anyone else had the same issue and able to help me please.

2

Ive found that if I load up each individual date partition, the table loads for that date, however I can’t seem to get all the partitions on the same table.

 

3

I have got a mildly inconvient fix if anyone is experiencing the same problem

"

\l /home/jovyan/fundamentals_capstone_dbs/2020.08.03
nbbone: nbbo
spread1: spread
trade1:trade

\l /home/jovyan/fundamentals_capstone_dbs/2020.08.04
nbbtwo: nbbo
spread2: spread
trade2:trade

\l /home/jovyan/fundamentals_capstone_dbs/2020.08.05
nbbthree: nbbo
spread3: spread
trade3:trade

\l /home/jovyan/fundamentals_capstone_dbs/2020.08.06
nbbfour: nbbo
spread4: spread
trade4:trade

nbbo: nbbone uj nbbtwo uj nbbthree uj nbbfour
spread: spread1 uj spread2 uj spread3 uj spread4
trade: trade1 uj trade2 uj trade3 uj trade4

delete nbbone from . delete nbbtwo from .
delete nbbthree from . delete nbbfour from .
delete spread1 from . delete spread2 from .
delete spread3 from . delete spread4 from .
delete trade1 from . delete trade2 from .
delete trade3 from . delete trade4 from .

"

4

Hi Tiaran, 

When you restarted your notebook you may have ended up in a different directory without the tables loaded, but they will have still existed on disk. 

Thanks for sharing how you resolved the issue, this will be really helpful for anyone else who has a simillar problem! 

Laura