[Laura]

You might be better off with a p attribute

c          | t f a 
-----------| ----- 
date       | d 
sensorId   | s   p 
time       | t 
lapId      | j 
units      | s 
sensorValue| f 
session    | s

[Laura]

Looks like count and meta are different, they should be:

//"meta lap" 
c          | t f a 
-----------| ----- 
date       | d 
sensorId   | s   p 
session    | s 
lapId      | j 
time       | t 
endTime    | t 
sensorValue| f 

// "count lap" 
210 

//"lap" 
date sensorId session lapId time endTime sensorValue 
----------------------------------------------------------------------------- 
2020.01.02 tempBackLeft P3 1 12:00:42.329 12:01:14.042 20.61488 
2020.01.02 tempBackLeft P3 2 12:01:14.042 12:02:27.094 20.62392 
2020.01.02 tempBackLeft P3 3 12:02:27.094 12:02:54.318 20.61883 
2020.01.02 tempBackLeft P3 4 12:02:54.318 12:16:52.146 20.621

 

If still stuck can add your code with the spoiler feature (in toolbar – click three dots ) then I can better suggest where you might be going wrong.

[Laura]

Hi

The first few rows of edge15 look like :

minute| edge    qty numTrds 
------| ---------------------- 
09:30 | 2946.818 3193 58 
09:45 | 721.9481 905 21 
10:00 | 564.0584 499 11 
10:15 | 563.706 870 14 
10:30 | 670.9859 1222 21 
10:45 | 784.223 1002 21 
11:00 | 134.2699 957 17 
11:15 | 230.7435 728 14 
11:30 | 560.6381 528 11 
11:45 | 306.1817 769 14 
12:00 | 876.8397 765 17

so it does seem different to your results – if you can share you definition of edge15 I can better assist – you can use the spolier tag (expand three dots in toolbar to select).

[Laura]

Hi  the issue is related to how you are referencing user, you can use .z.u instead.

To help with testing locally you could:

 

// define 2 handles for 2 seperate users 
jmurphyHandle:hopen `::5099:jmurphy:bahrain22 
fiaHandle:hopen `::5099:fiauser:getmeallthedata 

// user name itself is returned using .z.u 
jmurphyHandle".z.u" 
fiaHandle".z.u" 

// can then check if specific users exist in your permissions table and what APIs they are allowed to call 
jmurphyHandle".perm.users[.z.u]" 
fiaHandle".perm.users[.z.u][`api]"

 

You can build up your function bit by bit calling over the handle.

Hope this helps, would recommend the Advanced IPC course for some more practice materials on interacting between multiple processes.

[Laura]

Hi Kevin,

Thanks for your comment.

You can raise a feature request for arrowkdb here: Issues KxSystems/arrowkdb GitHub

Hope this helps!

Laura

[Laura]

Hi ,

Can you tell me more about your set up? This is just your own personal system, and not a production instance correct? Do you have a backup sym file? Back up the sym file – Kdb+ and q documentation (kx.com)

For enumeration, I would recommend reading Working with sym files | White Papers | Kdb+ and q documentation (kx.com)

There is also a course on the KX Academy on Enumeration with examples and practical guidance: KX Academy

Hope this helps,

Laura

[Laura]

Hi ,

Have you installed everything in the dependencies listed at the bottom of the page?

If so, and you are still not able to see the images, what error messages are you seeing?

Thanks,

Laura

[Laura]

Hi  what is the issue you are having? Is it the same error that Ciaran had above?

[Laura]

Hi Ciaran,

I see that you’ve got your Advanced Certificate now, congratulations!

What ended up being the cause of the “sensor” error?

Laura

[Laura]

Hi  there is no need to clone the repo into Developer.

You should be able to follow the README.md instructions for Fundamentals Capstone that appear upon launch and the workspace should appear – this video may help.

 

[Laura]

When I try to run the above I get a `length error.

A few things I spotted:

• watch out when you specify endtime – it should be endTime. Otherwise windows is pair of list but only the first is populated and the second is null.windows:(crosspdt[`time];crosspdt[`endTime])?
• think you do not require function f, try with just with avg directly in the wj (avg;`sensorValue)?

 

[Laura]

Hi  , what error are you seeing? Can you provide some detail on what you have tried so far so I can better help? If you want to add your code for this solution you can use the spoiler tag when posting or feel free to IM it to me.

 

Thanks,

Michaela

[Laura]

Hi , can you share a screenshot of what you see please so our team can investigate?

 

In the interim as a workaround you try stopping and restarting your server by going to:

Please save and download your files before doing the below or you will lose your changes.

1. Shut down Developer browser windows

2. File -> Hub Control Panel -> Stop My Server

3. Start My Server
4. Retrying the steps in the README

 

If you still have issues after this let us know.

[Laura]

You can do it through qsql syntax:

 exec (string[player],'" from ",/:string[country],'" scored a goal in the ",/:string[minute],:"th minute") from data

Useful information for this can be found here:
https://subhabratachoudhury.com/p/2016/05/concatenating-kdb-columns/
If you want to display to console each of these you can put a 0N! each in front of the above exec state.

[Laura]

Thanks for the detail. The Memory Management and Parallelization courses provide content on KX Developer rather than Jupyter Notebooks. These do not auto launch upon clicking the ‘Launch KX Sandbox’ button – they require some additional manual steps by the user as documented in the README that opens.

 

I still would not expect to see the behaviour you described following these steps, so if it does appear again please let us know and some screenshots would be great.

Thanks,

Michaela