rocuinneagain
Forum Replies Created
-
What is the definition of handle_close?
Trying to close a handle which is already closed will throw that error.
Since you call exit 0 above the handle will be closed by the process exiting.
q)hclose 5 //Success first time
q)hclose 5 //Fails as 5 no longer exists, was closed above
'close. OS reports: Bad file descriptor
[0] hclose 5
-
Here are some links and resources. What changes you may make depend heavily on your data and use-case:
- Whitepaper: https://code.kx.com/q/wp/rt-tick/
- Tick configuration: https://code.kx.com/q/kb/kdb-tick/
- Tick architecture: https://www.defconq.tech/docs/architecture/plain
- Tick source code: https://github.com/KxSystems/kdb-tick/blob/master/tick.q
- Similar recent question: https://stackoverflow.com/questions/78278007/problems-and-solutions-for-an-increased-amount-of-tick-data-in-kdb-q
- Custom tick partitioning: https://kx.com/blog/partitioning-data-in-kdb/
- TorQ tickerplant modes: https://dataintellecttech.github.io/TorQ/Processes/#tickerplant
-
q)type"t" // t is a character atom - 'like' expects a character vector -10h q)type"IBM" // IBM is a character vector 10h q)type enlist "t" // You can enlist an atom to be a single item vector 10h q)type (),"t" // (), is useful as a conditional enlist. It enlists the atom 10h q)type (),"IBM" // It does not enlist the vector 10h
-
- The sym file in root of the partitioned database is an enumeration file.
- Each date does not have it’s own enumeration file.
- The sym files inside the date/table folders are columns of name sym.
These names are not enforced but it is a common practice that ticker symbols are stored in a column named ‘sym’ of type symbol and are enumerated against a file called ‘sym’.
-
Hi
- What problem/error do you see?
- Can you share the text or a screenshot?
- What operating system are you installing on?
-
Related thread: embedPy installation: os error with kdb and python – Stack Overflow
I would try:
python -m pip install libpython
If still failing see output from https://pypi.org/project/find-libpython/
pip install find_libpython
>>> from find_libpython import find_libpython
>>> find_libpython() -
Can you include some more code to explain what the issue is?
To create a symbol vector you are using:
`symbol$()
but you should use:
`$()
.i.e
q)order_histories:([]time:`timespan$();sym:`$();user_uuid:`$();order_id:`long$();instrument:`$())
q)order_histories
time sym user_uuid order_id instrument
--------------------------------------Insert some data and set a port:
q)order_histories insert (2?.z.N;2?`6;2?`6;2?100000;2?`6)
0 1
q)order_histories
time sym user_uuid order_id instrument
---------------------------------------------------------0D09:21:01.649029855 kfmohp kfhogj 81418 milgli
0D05:24:41.981647398 lkklco jecpae 75009 igfbag
q)\p 5000Query from PyKX
>>> import pykx as kx
>>> conn('order_histories')
pykx.Table(pykx.q('
time sym user_uuid order_id instrument
---------------------------------------------------------
0D09:21:01.649029855 kfmohp kfhogj 81418 milgli
0D05:24:41.981647398 lkklco jecpae 75009 igfbag
'))
>>> conn('order_histories').pd()
time sym user_uuid order_id instrument
0 0 days 09:21:01.649029855 kfmohp kfhogj 81418 milgli
1 0 days 05:24:41.981647398 lkklco jecpae 75009 igfbag -
A few different variations:
-1 {i:where ""~/:x;raze "<html><body><p>",@[x;i;:;count[i]#enlist "</p><p>"],"</p></body></html>"} read0 `:smile.txt -1"<html><body><p>",,[;"</p></body></html>"] ssr[;"n";""] "</p><p>" sv "nn" vs`char$read1`:smile.txt -1"<html><body><p>",ssr["</p><p>"sv"nn"vs`char$read1`:smile.txt;"n";""],"</p></body></html>" -1{.h.htc[y;x]}over(ssr["</p><p>"sv"nn"vs`char$read1`:smile.txt;"n";""];`p;`body;`html) -1({.h.htc[y;x]})(ssr["</p><p>"sv"nn"vs`char$read1`:smile.txt;"n";""];`p;`body;`html) -
kdb+ 4.1 has been released with some interesting improvements for
peachwhich changes some of my answers as nesting is now supportedhttps://code.kx.com/q//releases/ChangesIn4.1/#peachparallel-processing-enhancements
-
Or if you only use PyKX for querying then you can use in unlicensed mode
https://code.kx.com/pykx/2.3/user-guide/advanced/modes.html#operating-in-the-absence-of-a-kx-license
from flask import Flask import os os.environ['PYKX_UNLICENSED']='true' import pykx as kx import json as j app = Flask(__name__) @app.route("/") def hello_kx(): #import pykx as kx qcon=kx.QConnection(host='localhost', port=5000) tables=qcon("tables[]").py() #import json as j #print(j.dumps(ports)) return tables if __name__ == '__main__': app.run(host='127.0.0.1', debug=True, port=8100) -
You example will run if you wait and only import pykx within the app
from flask import Flask #import pykx as kx <-- remove this import json as j app = Flask(__name__) @app.route("/") def hello_kx(): import pykx as kx qcon=kx.QConnection(host='localhost', port=5000) tables=qcon("tables[]").py() import json as j print(j.dumps(ports)) return tables if __name__ == '__main__': app.run(host='127.0.0.1', debug=True, port=8100) -
The first example line you show is creating parse trees and then evaluating them with
valuehttps://code.kx.com/q/basics/parsetrees/
You then replace the parse tree with a qsql statement which evaluates, this means you no longer need value:
tables[]!{count select from x} each tables[]The debugger uses
^to show you exactly where the error is thrown// ^ tells us the error happened when value was run
q)tables[] ! ( { count value ( select from x ) } each tables [] ) 'type [2] { count value ( select from x ) } ^ q))select from x // select from x returns a table a - 1 2 3 q))value select from x //Running value on a table is not a valid command 'type [4] value select from x ^ q))count select from x //We should run count directly on the returned table 3 -
Pass your license through and this should run:
docker run -it –name myjupyterq -v $QHOME/kc.lic:/home/kx/kc.lic -p 8888:8888 kxsys/jupyterq
- Replace kc.lic with k4.lic if that is your license type
- You can use /a/path/to/kc.lic if you have not set QHOME
-
Can you try https://pypi.org/project/find-libpython/
pip install find_libpython
>>> from find_libpython import find_libpython
>>> find_libpython()What is the output?
-
Can you share a small sample of your PyKX code which shows the issue?