Resolved! Use .Q functions or not
in q.k, after .q.fmt, it says: /DO NOT USE ROUTINES PAST HERE. SUBJECT TO CHANGE I also noticed .Q.qm is removed from 3.6. So the question is: Shall users stay away from .Q functions?
Forum Posts
Resolved! KDB Geom/Trig
Hey All, How do you use KDB sin/cos/tan to solve for the angles of a triangle? Im not asking about SOHCAHTOA -- when I use the sin/cos/tan functions in KDB/q I get different results compared to other language's functions. Is there a conversion im mis...
retrieving values
I have a basic question: a['name] vs b[val;'name] Do I understand the first is a dictionary and I get the value that corresponds to a key "name"? But what data structure is the second? Is that a list? I am reading the code and trying to make sense of...
Resolved! Importing data from csv file
fileName:hsym `$"C:/users/data.csv" show t:("SSDD";enlist",") 0: fileName After running these two lines iam getting below error: OS reports no such file or directory. But data.csv is there in the above location.
Largest float value KDB can handle
Whats the largest decimal value KDB can handle. Im looking to deal with numbers that have over 17 decimal places
Resolved! Concatenation issue for atomic values
Hi guys, When i'm doing `$("1";"0") it is automatically showing as "10". Is there any way i can make it as `1`0
Resolved! C++ convert large decimal to KDB
I need help to find out if there is compatible function in c++ class used to connect to db that would convert the large(24) decimal place to datatype compatible to kdb
Resolved! Control system command directory used (instead of /tmp)
Hi all, Anyone know if there's any way to control which directory is used during system commands? We have run into issues where /tmp is full and would like to use a different directory to avoid processes crashing.
Resolved! insert into global table in peach
Suppose we have table tblAAPL, tblIBM already, can I insert data into each table by using peach to accelerate the process? If tables do not affect each other. for example: insert[; data] peach `tblAAPL`tblIBM I tested, got noupdate error.
Resolved! SQL query to Functional query[Parse Tree]
Hi Community, I have a dictionary of tables, so I want to convert them into functional queries but when I try to build it, it retrieves a type issue, Do you know if it is possible? Attached pic! Thanks, Richard
Resolved! Applying nested conditions in q
I want to add a column to an existing table based on nested conditions T:([]a:`F`R;b:10 20;c:9 21;d:10 22) Func:{[tab] If a=`F If bd new=`hi Else new='welcome } Please help.
Resolved! SQL call function with 2 args
I have a function which takes 2 arguments. Ill write some pseudo code for an idea f:{[x;y] $[x~`1;y;`0]} Then i have a table: t:([]a:`1`2`3;b:`4`5`6) Now i want to call that function and pass a and b to it from an update statement update c:f[a;b] fro...
Resolved! Building REST API KDB - Issues setting up SSL-TLS
Hi Community, I am trying to create a REST API that would have 2 method(get and post), and It would be initially an empty table tab:([] a:`$(); b:"i"$()) that would be filled out eventually. So I would be using .Q.hg(get) and .Q.hp(post) for it, my e...
Resolved! wavg implementation detail
Hi, everyone. I have some questions about wavg function. 0 wavg 5 / 5 5 wavg 5 / 5 2 wavg 2 3 7 / 4 5 2 3 wavg 3 / 3 According to the doc, the x and y of wavg[x;y] must both be numeric lists. But for these invalid inputs, wavg still yields some resul...
Resolved! Help Understanding Precision
Can you please help me understand the below and why that number is converting to 99999 at end q)\P 0q)79347181.7179347181.709999993 q)\P 16q)79347181.7179347181.70999999 q)\P 15q)79347181.7179347181.71
KDB+ and POWER BI connection
Hello, I need to connect POWER BI with KDB. i tried using simba ODBC but iam having problem with theconnection when i try to connect to a kdb server which has partition table it shows error while connecting. Is there any other way to connect kdb with...
Show or 0N!
Good morning everybody! How to display a string without the quotes? Example: q) show "string" "string" q) show "string" string
Fast Insert Line into Middle of An In-memory Table
Hi Community, We came across one issue in development. Say we've got an in-memory table "tbl", and want to insert "data" into this table regularly, not by appending, but inserting into specific row with "index". Currently we tried to do the following...
KX & kdb/q Search Engine Shortcut
Hey all, In any modern browser, you can define your own search engine under settings. One useful case here is to setup a shortcut to code.kx, so that you can type a keyword (e.g. "kx") in your browser address bar, press tab and enter a search term su...
PyQ Adding Columns To Table
Greetings all, Trying to get add a numpy array (as a column) to a table table in pyq. Any help greatly appreciated.
First day
Good Morning!I just got to know kdb + and the q language.I am reading and practicing based on the website https://code.kx.com/q4m3/.I just made several examples with lists.Now I'm in the dictionaries.Example:d1: `a`b`c! (1 2; 3 4 5; 6 7 8 9)Doubt:How...
How to get experience
Hi guy, I'm new to kdb and I just started to learn it. In my town (montreal) there are some hedge funds who are looking for kdb developer but all of them they are looking for +2 years of experience. I want to know, how did you land your first entry l...
