Forum Replies Created

Page 7 of 8
  • davidcrossey

    Member
    March 28, 2022 at 12:00 am in reply to: Analyst widget in Dash

    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

    Member
    March 23, 2022 at 12:00 am in reply to: How to load the table from aws s3

    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

    Member
    March 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

    Member
    March 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

  • davidcrossey

    Member
    March 16, 2022 at 12:00 am in reply to: Financial Charting

    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

    Member
    March 16, 2022 at 12:00 am in reply to: Link q console session to third-party spreadsheet software?

    Hi PTECH127,

    You could try using the Excel client for q.

    Kind regards,

    David

  • davidcrossey

    Member
    March 15, 2022 at 12:00 am in reply to: Financial Charting

    Hi PTECH127,

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

    Kind regards,

    David

  • davidcrossey

    Member
    March 5, 2022 at 12:00 am in reply to: All that jazz: The librarians song

    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

    Member
    March 3, 2022 at 12:00 am in reply to: Five easy pieces

    I took a similar approach

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

     

  • davidcrossey

    Member
    March 3, 2022 at 12:00 am in reply to: Five easy pieces

    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

    Member
    March 3, 2022 at 12:00 am in reply to: RDB upd "splay" error

    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

    Member
    March 3, 2022 at 12:00 am in reply to: Five easy pieces

    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

    Member
    February 13, 2022 at 12:00 am in reply to: embedPy inside q (kdb+) process fails to import a module

    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?

    Thanks for sharing with the Community.

    Kind regards,

    David

  • davidcrossey

    Member
    December 13, 2021 at 12:00 am in reply to: Apache Log4j vulnerability

    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

    Member
    December 12, 2021 at 12:00 am in reply to: Apache Log4j vulnerability

    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

Page 7 of 8