[davidcrossey]

Hi Neekan,

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

Kind regards,

David

[davidcrossey]

Hi aele,

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

• PostgreSQL setup – KX Insights
• PostgreSQL to kdb+ Extension | KX

Hope this helps.

David

[davidcrossey]

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]

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]

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]

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]

Hi cj,

Try this one:

select member by ugroup from .pm.getUserGroup[]

 

Regards,

David

 

[davidcrossey]

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]

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]

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]

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

[davidcrossey]

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

[davidcrossey]

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]

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]

Hi cyhuang,

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

Kind regards,

David