mwoods
Forum Replies Created
-
Hi, this kind of error when loading data can often mean there are erroneous files in your data directory structure.
I had a quick look on your server and could see a checkpoints file saved there, i have removed this and your data load works now.
-
Thanks for flagging! We will review and fix.
-
This reply was modified 3 weeks, 4 days ago by mwoods.
-
This reply was modified 3 weeks, 4 days ago by
-
Hi @Akash thanks for flagging this issue with Table Importer, we will investigate.
Please try this alternative method in the meantime https://code.kx.com/q/ref/file-text/#load-csv
code.kx.com
File Text | Reference | kdb+ and q documentation - kdb+ and q documentation
File Text is a q operator that reads or writes text files.
-
Hi @Juanse there has been a recent upgrade, can you try these steps to resolve please?
https://learninghub.kx.com/forums/topic/kx-academy-upgrade/ -
Your code doesn’t need to be in the markdown file to validate. You just need to execute it, whether that be from file/scratchpad/elsewhere it doesn’t matter. We have some videos on Youtube showing how to use KX Developer which might help you get oriented https://www.youtube.com/watch?v=N_f38I7rqAI
As for your code not executing in the scratchpad that is odd, can you screenshot what happens when you use CTRL+D to run a line? As shown in this video
https://youtu.be/P8CP55sGX-k?si=CsNkRIFe0fqB9Cvi&t=243-
This reply was modified 1 month, 3 weeks ago by mwoods.
-
This reply was modified 1 month, 3 weeks ago by
-
Hi Akash, are you in the rendered version of the markdown file? You will not be able to edit code snippets there, you can edit in the unrendered version (saving file your edits will appear in the rendered version) or else just work directly in the scratchpad.
It is a good idea to add your code to project.md and continue to keep a backup up periodically by saving, or if working in scratchpad by copy & pasting somewhere periodically.
-
To return 5 6 you will need to index at depth by passing a semicolon
mm[0;2] 5 6
Indexing by passing a list of integers returns all indexes so in this case:
mm 0 // returns the element at position 0 1 2 3 4 5 6
mm 2 // returns the element at position 2 - which doesn't exist
mm 0 2 // get both elements at positions 0 and 2 - because none at 2 we just get the 0 elements back 1 2 3 4 5 6
This concept covered in the free academy course in the module on List Amendment and eliding at depth.
https://learninghub.kx.com/courses/kdb-developer-level-2/lessons/lists/topic/list-indexing-access/
-
https://learninghub.kx.com/forums/topic/kx-academy-upgrade/
Hi
With the recent upgrade to our Academy sandbox, JupyterQ/embedpy have been removed since PyKX can now be configured as a replacement.
As a result, when running notebooks, you might notice that a q kernel is unavailable.
To resolve this, we recommend running a ‘git pull’ on the project or reopening the sandbox link from the course page. This should fix the issue automatically.I would recommend signing up to our kx.com/slack community to get up to date with future changes.
learninghub.kx.com
KX Academy Upgrade !! - KX Learning Hub
February 3, 2025 - KX Academy Upgrade !! - Hi everyone,
-
Try
optRef: update "D"$expiry from optRef;
-
Thanks for the clarification Alex, @kdb_newbie you can try the below:
ej[`col1;t1;t2] uj select from t1 where not col1 in t2.col1 col1 col2 col3 col4 col5 ------------------------ a 1 11 4 44 a 1 11 5 55 b 2 22 6 66 c 3 33 7 77 d 8 88
-
You can use xkey to key the col1 column with lj to get your desired result:
t1 lj `col1 xkey t2
My joins cheatsheet might help you:https://www.linkedin.com/posts/michaela-woods-50502b60_kdb-dataanalytics-joinoperations-activity-7126225089632563200-jUOz?utm_source=share&utm_medium=member_desktop
As well as the joins modules in the free Academy courses: https://learninghub.kx.com/courses/kdb-developer-level-1/lessons/joins/
linkedin.com
Michaela Woods on LinkedIn: #kdb #dataanalytics #joinoperations #cheatsheet
Joining tables in kdb+/q is straightforward, but selecting the correct type of join can be tricky, especially for newcomers. 🧐 I've put together a quick…
-
That’s correct, there are no video lectures for the developer level 3 course
-
-
Hi Juanse, part indicates something is off with your directory structure. I logged into your environment as admin and using ls could check there was indeed an erroneous file “5457”. I removed this file and was able to load the database.
This should work for you now, trade should be available to query
Thanks,
Michaela
-
@Juanse I have rerun the setup script again for you, see below steps, navigate to directory on Termnial, run setup.sh and then relaunch Developer from Launcher window.
I am not sure of the cause of the error, perhaps something you are running is triggering it but this fix should unblock you at least.
