

mwoods
Forum Replies Created
-
mwoods
AdministratorAugust 19, 2024 at 8:36 am in reply to: help to re install a cmd line to download data from tables on workshop session 1@kokuyo you can restore your file by doing a git checkout on a terminal window:
– Open a new Launcher (+ in top navigation) window and select Terminal
– Run git status to see files that have changed and git diff to see code changes
– You can see the deleted code here and run git checkout on the file you wish to restore
-
mwoods
AdministratorAugust 13, 2024 at 8:29 am in reply to: getOptionRef API is giving empty resultsWhat does uniqueOpts variable return in the console? Would you be able to share a screen shot of this with your code and result instead of code snippet too please?
I will be better able to assist if I can see your code and output example as we have some issues with code formatting on the forums due to be resolved soon https://learninghub.kx.com/forums/topic/known-forum-ux-issues-and-resolutions/
-
@jpandza The Blocked message is correct, the capstone has been setup such that process 5010 is restricted in that it only allowes calls to 2 APIs as detailed in the instructions.
-
mwoods
AdministratorJuly 18, 2024 at 10:51 am in reply to: Can’t setup for fundamentals capstone (git symbol lookup error)Hi @Nicky this error can be ignored – you can open KX Developer now from the Launcher window.
-
mwoods
AdministratorJuly 18, 2024 at 8:19 am in reply to: fundamental capstone error – Loading dataHi @Hizmy
part error indicates an something wrong with the partitions in the HDB.
I had a look at your instance and see a rogue file in the HDB directory called csvOutputPath. I removed this file.
Can you please try again?
-
@jeanluck to get you unblocked quickly it will be best if you can share your answers file with me in a DM or to evangelism@kx.com. Then I can better investigate what is going wrong for you as is hard to diagnose without seeing what you have ran.
-
@rlakkireddy Have you got kdb installed and the alias set so you can run q to invoke kdb+?
https://code.kx.com/q/learn/install/#step-5-edit-your-profile- What OS are you on?
- How was kc.lic created?
- Is QHOME set?
- Can you share screenshots of the above path and variable definition?
Also FYI you can run this application on the free KX Academy sandbox – no need for you to install anything locally.
code.kx.com
Installing kdb+ | Learn | kdb+ and q documentation - kdb+ and q documentation
How to install kdb+ on Linux, macOS, or Windows
-
@jeanluck is your issue on 1.4/2.2 solved now? Or are you still stuck?
Thanks for letting us know and we will clarify that question by specifying we want a date partitioned table in the question.
Re. 3.5 I am not following, can you send a screenshot of the discrepancy please and we will have a look and update if needed.
Your feedback is appreciated as we aim to continuously improve the course materials. 🙂
-
After writing table to disk using .Q.dpft and loading into memory you should see the date column on your table. You do not need to pass the column name date as in your example, the third parameter should be the column to key on, in this case sensorId. See an example here of what that looks like: https://code.kx.com/q/ref/dotq/#dpft-save-table
Note in that example the table in memory is first deleted and then the table on disk is reloaded – only after loading from disk does date then appear when calling the table or using meta. So for exercise 2.2 you should see date appear without needing to do anything other load table into memory as long as your .Q.dpft worked correctly.
If you can get all your exercise 1 passing thats a good sign .Q.dpft worked correctly. Then use \l to load into memory.code.kx.com
The .Q namespace – tools | Reference | kdb+ and q documentation - kdb+ and q documentation
The .Q namespace contains utility objects for q programming
-
@jeanluck watch the order of your columns as per the sample table, date should be out in front. Another way to load in partitioned data WITH date column already added so you dont have to add it in manually using update and then reordering columns is using select from statement instead of get
-
mwoods
AdministratorApril 19, 2024 at 4:39 pm in reply to: Level 2 capstone project kx developer not openingSuggestions on these links may help
https://learninghub.kx.com/forums/topic/complete-reset-of-workspace/#post-33769
https://learninghub.kx.com/forums/topic/kx-developer-broken/
-
mwoods
AdministratorApril 4, 2024 at 12:16 pm in reply to: How to reset/reinitialise the sandbox in a topicYou can revert to the original using git to discard your changes, making sure you shut down your notebook first.
Steps:
1. Shut down notebook kernal and the notebook tab – either by right clicking or in the second icon in left hand menu (see image)
2. Open a terminal – click the + symbol, select Terminal and run git status and git restore on any notebooks that have changes you wish to revert
3. Reopen notebook – should no longer see your changes
-
Hi @lestat-jin thanks for flagging this.
Upon review I agree it is confusing and badly worded, in fact there are a number of small changes I have made to make to make this example clearer including:
- changing the direction from > to <
- asking for longitude rather than latitude as this is what we are outputting to console with 0N! so we can better see if it is meeting the checks
- adding a missing semicolon at then end of the second if statement
I have attached the updated example with fixes above.
If you want to get the notebook with these changes you can delete your current directory from the terminal and relaunch the sandbox from the course.
Thanks for your feedback and helping us to improve the materials !
-
@Mohamed This is very odd and something we haven’t been able to recreate.
What should happen upon clicking the “Launch KX Sandbox” link is a new tab will open with this link below, this link has a redirect to pull a git repo into a fully cloud hosted (on our side) environment so wouldn’t expect it to cause much load on your side.
Can you let us know what happens when you try open this link below so we can better assist?