

davidcrossey
Forum Replies Created
-
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
-
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
MemberMarch 21, 2022 at 12:00 am in reply to: How to write data into table from python to kdb+ on Refinery?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
MemberMarch 18, 2022 at 12:00 am in reply to: How to write data into table from python to kdb+ on Refinery?Hi Ori,
Please find some reference information here for writing a Python UDF for Refinery: Realtime UDF (kx.com).Kind regards,
David
-
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.
-
davidcrossey
MemberMarch 16, 2022 at 12:00 am in reply to: Link q console session to third-party spreadsheet software? -
Hi PTECH127,
Can you elaborate further on what you asking in this question?
Kind regards,
David
-
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!
-
I took a similar approach
@[;4 7;:;”-“] string `datetime$.z.p
-
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}
-
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
-
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
MemberFebruary 13, 2022 at 12:00 am in reply to: embedPy inside q (kdb+) process fails to import a moduleHi 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
-
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
-
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