loaddata.q fails on startup

Academy Support
1

https://learninghub.kx.com/forums/topic/loaddata-q-fails-on-startup

Can anyone please help me with my first tutorial (course-introductory-workshop, Kx Workshop Session 1 qSQL.ipynb)?

It fails on startup of the Jupyter Notebook in loaddata.q script. From the top of my head I can't see anything wrong with the data. :(

Thanks in advance!

-----------------
evaluation error:

./.ipynb_checkpoints/par-checkpoint.txt

  [9]  ()


  [8]  (.Q.lo@)


  [7]  (.Q.lo)


  [6]  \l /home/jovyan/course-introductory-workshop/data/taxi
       ^

  [5]  /home/jovyan/course-introductory-workshop/scripts/loaddata.q:3: loadtripsdb:
    `KX_OBJSTR_INVENTORY_FILE setenv"_inventory/all.json.gz";
    system"l ",.trn.nbdir,"/data/taxi";
    ^
    0N!"Loaded Taxi Trips partitioned DB";

  [4]  /home/jovyan/course-introductory-workshop/scripts/loaddata.q:17: initdata:
    smalltrips set ("DMSPPNIFFFFFSFEFFF";enlist ",") 0:$":",.trn.nbdir,"/data/smalltrips.csv";
    loadtripsdb[];
    ^
 }

  [3]  /home/jovyan/course-introductory-workshop/scripts/loaddata.q:21: initdata[]
                                                                        ^

  [0]  \l scripts/loaddata.q
2

Hi @lkragins

This problem has been reported by another user internally so we will look in to a fix for this.

However for now, if you want to erase this instance and start again, can I suggest that you you try closing the notebook and returning to the terminal and running:

cd ..

And then:

rm -rf course-introductory-workshop
This should remove the current instance of the course.

To restart the project, go to the academy and launch the capstone sandbox as normal.

Let me know if this works!

Thanks,

Megan

3

It worked! Thanks a lot!!!