KX Academy

loaddata.q fails on startup

Posted by lkragins on July 18, 2024 at 5:42 pm

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]  (<fget>)


  [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

lkragins replied 5 months, 1 week ago 2 Members · 2 Replies

2 Replies

megan_mcp

Administrator
July 19, 2024 at 11:44 am
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
lkragins

Member
July 19, 2024 at 4:45 pm

It worked! Thanks a lot!!!

KX Community

loaddata.q fails on startup

megan_mcp

lkragins