[davidcrossey]

Hi Simon,

Interesting question.

From looking over Analyst Visual – KX Dashboards I don’t think the internals of the GoG are exposed  such that they could be mapped to other viewstates, however hopefully the Community can clarify

Cheers,

David

[davidcrossey]

Hi Raj,

Please refer to Object storage | KX Insights Core on how to load a database table from an AWS S3 bucket.

Hope this helps.

Kind regards,

David

[davidcrossey]

Hi Ori,

I’m not too familiar with this use case, however I hope someone in the Community will be able to give some advice Best regards,
David

[davidcrossey]

Hi Ori,
Please find some reference information here for writing a Python UDF for Refinery: Realtime UDF (kx.com).

Kind regards,

David

[davidcrossey]

The best place to start would be code.kx.com where you will find a whole bunch of information on getting started with kdb+ and q; check out the ‘Intro Tour’ to get started.

Once familiar with the base language, you could then look into the Grammar of Graphics with KX Developer IDE to create some visualisations, then if you wanted to go a step further you could look at KX Dashboards Direct to create some dashboards for visualising the data.

Additional self-serve and on-demand training material can be found on the KX Academy and we also have a lot of useful threads across our various KX Community Discussion Boards.

Hope this helps.

[davidcrossey]

Hi PTECH127,

You could try using the Excel client for q.

Kind regards,

David

[davidcrossey]

Hi PTECH127,

Can you elaborate further on what you asking in this question?

Kind regards,

David

[davidcrossey]

Jazz and vector programming are both difficult skills to grasp but very rewarding when one does become somewhat proficient.

Fascinating application of q to clean up your music library, and a fantastic article & post demonstrating the strengths of the language – thanks for sharing with the community Stephen!

[davidcrossey]

I took a similar approach

@[;4 7;:;”-“] string `datetime$.z.p

 

[davidcrossey]

Here is my quick attempt for which I’m sure there is a much more elegant solution

.dt.fmtd:{(`iso`dmy`mdy!({ssr[string x;”.”;”-“]};{“/” sv string `dd`mm`year$x};{“/” sv string `mm`dd`year$x}))[x] `date$y}

 

[davidcrossey]

Hi leguan,

Below I have a q process that has loaded in a splayed table from disk, and when I attempt to upsert to it I receive the splay runtime error:

q) ls "sym" "trades" 
q) l . trades 
sym time price 
-------------------------------------------- 
hagl 2019.03.18D00:59:52.359311488 72.50709 
cokn 2011.09.16D13:20:44.392412288 48.1804 
ojeg 2001.06.09D22:38:22.583004264 93.51307 
ohbo 2002.08.03D15:00:12.478929184 70.93398 
caha 2012.02.12D05:29:19.432019136 94.52199 
q) upsert[`trades;flip (5?`4;5?.z.P;5?100f)] 
'2022.03.03T20:16:22.250 splay [0] upsert[`trades;flip (10?`4;10?.z.P;10?100f)]

Compare this with a table defined in-memory (such as an RDB schema):

q)trades:([]sym:`$();time:`timestamp$();price:`float$()) 
q)trades 
sym time price 
-------------- 
q)upsert[`trades;flip (5?`4;5?.z.P;5?100f)] 
`trades 
q)trades 
sym time price 
------------------------------------------- 
ncej 2010.12.07D17:24:19.578683840 39.27524 
jogn 2012.10.28D18:28:23.546450688 51.70911 
ciha 2001.11.10D07:36:32.747210000 51.59796 
hkpb 2004.05.06D02:28:38.944876960 40.66642 
aeaj 2008.04.29D20:37:48.030489920 17.80839

Has a process or a user loaded (or memory-mapped) the splayed table (or entire HDB) from disk into the RDB process?

Best regards,

David

[davidcrossey]

Very well gentlemen, I raze you a substitute for our departed  `datetime type with `date`time

raze (ssr[;”.”;”-“];”T”,)@’string `date`time$.z.p

/ or alternatively

“T” sv (ssr[;”.”;”-“];::)@’string `date`time$.z.p

 

 

[davidcrossey]

Hi Ori,

Interesting to see if anyone else in the Community has tried using this library who may be able to assist

Just in case anyone else is interesting in looking at this issue, can I check you are referring to these projects?

• michaelsimonelli/qoinbase-q: Q client for the Coinbase Pro API (github.com)
• michaelsimonelli/qoinbase-py: Python client for the Coinbase Pro API – integrates with qoinbase-q (github.com)

Thanks for sharing with the Community.

Kind regards,

David

[davidcrossey]

Hi neilusobrien,

Please find the below update from the support page regarding this vulnerability;

Advisory: Critical vulnerability CVE-2021-44228 affecting the Apache Log4J library

KX is aware of a widely reported critical vulnerability (CVE-2021-44228) affecting the Apache Log4j library, where attackers can leverage log message or log message parameters to perform remote code execution on vulnerable systems. It is recommended that customers who utilise Apache Log4j upgrade to version 2.15.0, which addresses this vulnerability.

Actions taken

As a critical vulnerability, we have reviewed the security of our platform. No vulnerable versions of the Log4j library have been uncovered within the KX software that has been shipped to customers. As always, the security of customers is of paramount importance. If and when further information becomes available, we will update this page accordingly. If you have concerns or questions please visit support.kx.com

Please see support page for further updates.

Kind regards,

David

[davidcrossey]

Hi neilusobrien,

Thanks for raising your concern here.

I will forward this on to our engineers and provide an update as soon as possible.

Kind regards,

David