mwoods
Forum Replies Created
-
@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.
-
Hi @Nicky this error can be ignored – you can open KX Developer now from the Launcher window.
-
Hi @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
-
Hi @carlsun1999 you can download from here https://code.kx.com/developer/getting-started/
-
Suggestions 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/
-
You 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 !
-
Hi @fionan I had a look and reset your workspace for you by redoing the steps in the original README i.e. rerunning setup.sh before opening KX developer. Can you try now? Thanks
-
Hi @natasha-lakhpaty the indexing approach taken in the exercise solution returns the value at the index that is halfway between the sorted list.
The med function doesn’t have to return an actual distinct value that exists in the list, but instead the arithmetic middle value. Have added a simpler example here – hope this helps!
-
@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?
