Forum Replies Created

Page 4 of 8
  • Hi Neekan,

    Make sure you source your config file before running developer as per notes on Getting started – KX Developer

    Kind regards,

    David

  • davidcrossey

    Member
    October 26, 2022 at 12:00 am in reply to: Connect to postgreSQL from q

    Hi aele,

    A couple of alternatives that might be of use to you:

    Hope this helps.

    David

  • davidcrossey

    Member
    October 25, 2022 at 12:00 am in reply to: KX Developer on Macbook M1 or M2

    Hi mhickman,

    I don’t believe ARM64 is officially supported at this time, however you could try using Rosetta to run Intel based applications on your ARM64 based mac: If you need to install Rosetta on your Mac Apple Support (UK)

    You will also need to install Developer’s dependencies via the Rosetta terminal i.e. brew install [x]

    Kind regards,
    David

  • davidcrossey

    Member
    October 10, 2022 at 12:00 am in reply to: parse tree not working for simple select

    As you’ve mentioned parse trees in your post title, I’ll limit the scope of the following examples here using parse on a select statement*;

    If you want to carry out of a functional select for both of the queries above, I suggest using the parse keyword to determine the components of the phrase:

    // c2>16 example 
    q)parse "select from tab where c2>16" 
    ? 
    `tab 
    ,,(>;`c2;16) 
    0b
    () 
    
    q)?[tab;enlist (>;`c2;16);0b;()] 
    c1 c2 
    ----- 
    7 17 
    8 18 
    9 19 
    
    // last c2 example 
    q)parse "select last c2 from tab" 
    ? 
    `tab 
    () 
    0b 
    (,`c2)!
    ,(last;`c2) 
    
    q)?[tab;();0b;enlist[`c2]!enlist (last;`c2)] 
    c2 
    -- 
    19

    You can read more about parse here and parse trees here

    *There are other ways of retrieving specific values for the queries you’ve listed. For example, you could also write last tab[`c2] to fetch the last value in the c2 column

    Hope this helps.

  • davidcrossey

    Member
    September 26, 2022 at 12:00 am in reply to: Lint option availability in Kx Control 4.6.0

    Hi Aishwarya,

    As per Linting – KX Developer you can run the linter at the workspace, module and file levels in a repository. You can’t run the linter arbitrarily against a scratchpad.

    Can you confirm that you’ve created a workspace/module/files in your Analyst session similar to the following?

     

    Kind regards,

    David

  • davidcrossey

    Member
    September 12, 2022 at 12:00 am in reply to: How do I get the .s.e sql interface on the command line?

    Hi Ali99947,

    The SQL module does not ship with standard version of KDB, such as 64 bit On-Demand.

    It’ part of the KX Insights family of products. Please find more information here: About – KX Insights

    Kind regards,

    David

  • davidcrossey

    Member
    August 30, 2022 at 12:00 am in reply to: Fetch a user list from a user group

    Hi cj,

    Try this one:

    select member by ugroup from .pm.getUserGroup[]

     

    Regards,

    David

     

  • davidcrossey

    Member
    August 25, 2022 at 12:00 am in reply to: JupyterQ(Docker) fails to get license

    Hi Jackie,

    Thanks for raising this.

    I can also see the same error. I will pass this along internally and get back to you as soon as we have an update.

    Kind regards,

    David

  • davidcrossey

    Member
    August 23, 2022 at 12:00 am in reply to: Dashboards Direct TLS Connection

    Unfortunately I’m not aware of any Windows tools similar to strace that might help, and I’ve not see this issue before.

    Just to confirm, when you manually opened the TLS connection, that was on the dash.q process?

  • davidcrossey

    Member
    August 12, 2022 at 12:00 am in reply to: Dashboards Direct TLS Connection

    Hey Dunny,

    Could you try stracing the dashboards process to see if it tries opening with tcps? E.g.

    strace -tty -p {dash_pid}.

    You should see something like the following:

     

    02:24:46.784671 read(0</dev/pts/17>, "h:hopen `:tcps://localhost:10001"..., 4080) = 33 ... 
    02:24:47.306400 setsockopt(10<socket:[4120184947]>, SOL_TCP, TCP_NODELAY, [1], 4) = 0 
    02:24:47.306473 setsockopt(10<socket:[4120184947]>, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 
    02:24:47.306541 setsockopt(10<socket:[4120184947]>, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0

    Cheers,

    David

  • davidcrossey

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

    I would love to know how / why this period to dash conversion is happening if anyone can shed some light?

  • davidcrossey

    Member
    July 31, 2022 at 12:00 am in reply to: Error with sum

    Hi navdithya,

    Your query is selecting the value (.:) function by mid. You need to apply sum on a column by mid to get an aggregation e.g.

     

    show t:select sum column by mid from readings

     

    Kind regards,

    David

  • Hi vivo,

    To load a q script it needs to be loaded from the local disk.

    You could also use .Q.hg to download the file directly into your process with either of the following as examples:

    q)"rn" vs .Q.hg `:https://raw.githubusercontent.com/KxSystems/kdb/master/sp.q 
    /or 
    q)ssr[;"rn";""] .Q.hg `:https://raw.githubusercontent.com/KxSystems/kdb/master/sp.q

    However with this approach you’d need a lot of customization per code block to execute it locally.

    If you are downloading the script to the local q process, why would you not store it on disk anyway? For example, re-loading later instead of multiple downloads.

    Kind regards,

    David

  • davidcrossey

    Member
    July 30, 2022 at 12:00 am in reply to: server options

    Hi mumfordg,

    The underlying versions of standalone KDB and KX Insights are essentially the same, with additional modules as per licencing.  Assuming all other things being equal, you should see similar results between a 4.1 test server and 4.1 on Insights.

    Hope this helps.

    David

  • davidcrossey

    Member
    July 6, 2022 at 12:00 am in reply to: Could not load list columns from S3

    Hi cyhuang,

    I’ve raised this internally and get back to you as soon as possible.

    Kind regards,

    David

Page 4 of 8