# \#pykx **URL:** https://forum.kx.com/tag/pykx/31.md [Latest](https://forum.kx.com/latest.md) · [Categories](https://forum.kx.com/categories.md) · [Tags](https://forum.kx.com/tags.md) --- ## [Stale PyKx License - Signed up today](https://forum.kx.com/t/stale-pykx-license-signed-up-today/15398)
**Author:** [@matthew\_power](https://forum.kx.com/u/matthew_power)\ **Replies:** 1\ **Last updated:** [January 28, 2026, 2:43pm UTC](https://forum.kx.com/t/stale-pykx-license-signed-up-today/15398 "2026-01-28T14:43:54Z")
Hi, I recently started getting license errors while importing pykx. I downloaded a fresh version from Insights which is the link that the error message led me towards. I got the welcome email today but it is either not … --- ## [Need Help with JSON to KDB Table Conversion (Type Casting Issues)](https://forum.kx.com/t/need-help-with-json-to-kdb-table-conversion-type-casting-issues/15356)
**Author:** [@smithalaone](https://forum.kx.com/u/smithalaone)\ **Replies:** 1\ **Last updated:** [January 5, 2026, 9:53am UTC](https://forum.kx.com/t/need-help-with-json-to-kdb-table-conversion-type-casting-issues/15356 "2026-01-05T09:53:37Z")
Need Help with JSON to KDB Table Conversion (Type Casting Issues) Hi everyone! I’m relatively new to kdb+/q and currently stuck on JSON decoding. I’m trying to convert arbitrary JSON data into KDB tables, but I’m runni… --- ## [Assigning the output of function to a variable when querying connection](https://forum.kx.com/t/assigning-the-output-of-function-to-a-variable-when-querying-connection/14511)
**Author:** [@sm1121](https://forum.kx.com/u/sm1121)\ **Replies:** 3\ **Last updated:** [July 18, 2025, 2:38pm UTC](https://forum.kx.com/t/assigning-the-output-of-function-to-a-variable-when-querying-connection/14511 "2025-07-18T14:38:09Z")
Example: result = conn(‘Multiply’, 6, 3) (Multiply function defined as conn('Multiply: {x\*y}) I want to be able to assign the result (pykx.LongAtom(pykx.q(‘18’))) to a variable e.g. ‘results\_value’ which I can then ac… --- ## [How to load python files as modules in Analyst?](https://forum.kx.com/t/how-to-load-python-files-as-modules-in-analyst/14389)
**Author:** [@Allen\_K](https://forum.kx.com/u/Allen_K)\ **Replies:** 7\ **Last updated:** [July 18, 2025, 12:01pm UTC](https://forum.kx.com/t/how-to-load-python-files-as-modules-in-analyst/14389 "2025-07-18T12:01:12Z")
Hi, is there a documented method of loading modules from python files in Analyst. Thanks, Allen --- ## [Is there a way to limit the number of rows in the output from IPC query](https://forum.kx.com/t/is-there-a-way-to-limit-the-number-of-rows-in-the-output-from-ipc-query/14431)
**Author:** [@sm1121](https://forum.kx.com/u/sm1121)\ **Replies:** 2\ **Last updated:** [July 8, 2025, 9:55am UTC](https://forum.kx.com/t/is-there-a-way-to-limit-the-number-of-rows-in-the-output-from-ipc-query/14431 "2025-07-08T09:55:53Z")
I want to find a way to crop/limit the number of rows in the output when querying my IPC connection using a namespace function. Using pykx, I am calling result = connection(\*params) with example usage connection(‘getTr… --- ## [Using PYKX for cloud connection (no username/password)](https://forum.kx.com/t/using-pykx-for-cloud-connection-no-username-password/14243)
**Author:** [@chetchet](https://forum.kx.com/u/chetchet)\ **Replies:** 0\ **Last updated:** [June 5, 2025, 2:31pm UTC](https://forum.kx.com/t/using-pykx-for-cloud-connection-no-username-password/14243 "2025-06-05T14:31:41Z")
https://learninghub.kx.com/forums/topic/using-pykx-for-cloud-connection-no-username-password Can we use PYKX to connect to an azure server that uses client secret and ID instead of username and password? I can do it wit… --- ## [PYKX not allowing to change Python attribute of Q Object](https://forum.kx.com/t/pykx-not-allowing-to-change-python-attribute-of-q-object/14220)
**Author:** [@Nachofest](https://forum.kx.com/u/Nachofest)\ **Replies:** 1\ **Last updated:** [May 19, 2025, 9:04am UTC](https://forum.kx.com/t/pykx-not-allowing-to-change-python-attribute-of-q-object/14220 "2025-05-19T09:04:00Z")
https://learninghub.kx.com/forums/topic/pykx-not-allowing-to-change-python-attribute-of-q-object I am trying to do the following: \`\`\` import pykx old=":host:Port:user:old" pykx.q.my\_handle=old new=":host:Port:user:new" p… --- ## [loading multiple partitiioned db's](https://forum.kx.com/t/loading-multiple-partitiioned-dbs/14216)
**Author:** [@milk](https://forum.kx.com/u/milk)\ **Replies:** 1\ **Last updated:** [May 13, 2025, 7:14pm UTC](https://forum.kx.com/t/loading-multiple-partitiioned-dbs/14216 "2025-05-13T19:14:54Z")
https://learninghub.kx.com/forums/topic/loading-multiple-partitiioned-dbs Hi, I'm trying to be able to load multiple partitioned db's. In KDB, this typically requires you to de-enumerate the symbols before combining da… --- ## [PyKX could not establish an IPC connection in the Flask app](https://forum.kx.com/t/pykx-could-not-establish-an-ipc-connection-in-the-flask-app/13184)
**Author:** [@rajrs.ece](https://forum.kx.com/u/rajrs.ece)\ **Replies:** 2\ **Last updated:** [May 2, 2025, 1:31pm UTC](https://forum.kx.com/t/pykx-could-not-establish-an-ipc-connection-in-the-flask-app/13184 "2025-05-02T13:31:39Z")
https://learninghub.kx.com/forums/topic/pykx-could-not-establish-an-ipc-connection-in-the-flask-app I'm trying to make a connection from a Flask app, but it shows a QError: .pykx.i.isw. I tried the same function withou… --- ## [Loading python library (embedPy) without restarting kdb/q](https://forum.kx.com/t/loading-python-library-embedpy-without-restarting-kdb-q/14192)
**Author:** [@catch22](https://forum.kx.com/u/catch22)\ **Replies:** 1\ **Last updated:** [April 17, 2025, 1:43pm UTC](https://forum.kx.com/t/loading-python-library-embedpy-without-restarting-kdb-q/14192 "2025-04-17T13:43:31Z")
https://learninghub.kx.com/forums/topic/loading-python-library-embedpy-without-restarting-kdb-q Hi guys, I have one question. I am using embedPy to call python library (user written) in kdb. Is there way to reload the p… --- ## [pykx install lic error](https://forum.kx.com/t/pykx-install-lic-error/14164)
**Author:** [@hiuq](https://forum.kx.com/u/hiuq)\ **Replies:** 9\ **Last updated:** [March 23, 2025, 1:12am UTC](https://forum.kx.com/t/pykx-install-lic-error/14164 "2025-03-23T01:12:31Z")
https://learninghub.kx.com/forums/topic/pykx-install-lic-error Hi, I am new to pykx. What license do I need to install pykx . At the moment I only have q license Error: shutil.SameFileError: '/home/xxx/q/kc.lic' and… --- ## [library error on register licence and connecting on external port in azure](https://forum.kx.com/t/library-error-on-register-licence-and-connecting-on-external-port-in-azure/14158)
**Author:** [@Juanse](https://forum.kx.com/u/Juanse)\ **Replies:** 1\ **Last updated:** [March 7, 2025, 9:25pm UTC](https://forum.kx.com/t/library-error-on-register-licence-and-connecting-on-external-port-in-azure/14158 "2025-03-07T21:25:27Z")
https://learninghub.kx.com/forums/topic/library-error-on-register-licence-and-connecting-on-external-port-in-azure at first i can , but later when i tried again because a wrong path it showed this error saying that i ca… --- ## [pykx DatetimeAtom,DateTimeVector how to create it ?](https://forum.kx.com/t/pykx-datetimeatom-datetimevector-how-to-create-it/14147)
**Author:** [@dmitriyv](https://forum.kx.com/u/dmitriyv)\ **Replies:** 1\ **Last updated:** [February 20, 2025, 9:35am UTC](https://forum.kx.com/t/pykx-datetimeatom-datetimevector-how-to-create-it/14147 "2025-02-20T09:35:27Z")
https://learninghub.kx.com/forums/topic/pykx-datetimeatomdatetimevector-how-to-create-it it seems DatetimeAtom is depreciated. However, is there a way to create it for backward compatibility ? Documentation mentions … --- ## [Error when using in Jupyter : ''licence error: embedq''](https://forum.kx.com/t/error-when-using-in-jupyter-licence-error-embedq/13925)
**Author:** [@fav\_pa](https://forum.kx.com/u/fav_pa)\ **Replies:** 1\ **Last updated:** [January 10, 2025, 10:35am UTC](https://forum.kx.com/t/error-when-using-in-jupyter-licence-error-embedq/13925 "2025-01-10T10:35:10Z")
https://learninghub.kx.com/forums/topic/error-when-using-in-jupyter-licence-error-embedq Hi, when trying to run pykx in a jupyter env, it first doesn’t recognize the fact that i have a valid license on my computer. It … --- ## [PyKXException - Valid KDB+/Q License](https://forum.kx.com/t/pykxexception-valid-kdb-q-license/14111)
**Author:** [@k2q](https://forum.kx.com/u/k2q)\ **Replies:** 3\ **Last updated:** [January 10, 2025, 10:23am UTC](https://forum.kx.com/t/pykxexception-valid-kdb-q-license/14111 "2025-01-10T10:23:10Z")
https://learninghub.kx.com/forums/topic/pykxexception-valid-kdb-q-license Hello, Currently using trial kdb version, it's working well. \`\`\` KDB+ 4.1 2024.10.16 Copyright (C) 1993-2024 Kx Systems l64/ 4(24)core 7461MB rr … --- ## [Error with installing PYKX](https://forum.kx.com/t/error-with-installing-pykx/14115)
**Author:** [@Anthony](https://forum.kx.com/u/Anthony)\ **Replies:** 4\ **Last updated:** [January 9, 2025, 8:53am UTC](https://forum.kx.com/t/error-with-installing-pykx/14115 "2025-01-09T08:53:18Z")
https://learninghub.kx.com/forums/topic/error-with-installing-pykx I am following the installation for PYKX. When I run "import pykx as kx" and then follow the prompts. After I provide the base64 code, I get: PyKX lic… --- ## [Multiprocessing with pykx hanging on trying to load db from disk](https://forum.kx.com/t/multiprocessing-with-pykx-hanging-on-trying-to-load-db-from-disk/14112)
**Author:** [@milk](https://forum.kx.com/u/milk)\ **Replies:** 2\ **Last updated:** [January 6, 2025, 6:11pm UTC](https://forum.kx.com/t/multiprocessing-with-pykx-hanging-on-trying-to-load-db-from-disk/14112 "2025-01-06T18:11:34Z")
https://learninghub.kx.com/forums/topic/multiprocessing-kdb Hi, I'm starting up a new process using multiprocess in python, where I feed in multithreading.queue into a custom function p = multithreading.Process(targe… --- ## [issue with select, update, exec...](https://forum.kx.com/t/issue-with-select-update-exec/14103)
**Author:** [@MohammedDrici](https://forum.kx.com/u/MohammedDrici)\ **Replies:** 3\ **Last updated:** [December 9, 2024, 11:16am UTC](https://forum.kx.com/t/issue-with-select-update-exec/14103 "2024-12-09T11:16:28Z")
https://learninghub.kx.com/forums/topic/issue-with-select-update-exec Hi can you explain to me why request as select are not working plz ? :) the error is :AttributeError: 'Table' object has no attribute 'select' --- ## [PyKX 3.0 is Released!](https://forum.kx.com/t/pykx-3-0-is-released/14093)
**Author:** [@mmcparland](https://forum.kx.com/u/mmcparland)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 6:26pm UTC](https://forum.kx.com/t/pykx-3-0-is-released/14093 "2024-11-12T18:26:29Z")
https://learninghub.kx.com/forums/topic/pykx-3-0-is-released We are thrilled to announce a huge milestone in the development of PyKX - version 3.0. The PyKX team has been working hard to deliver a new and improved user … --- ## [xgroup error in taxi and weather analysis](https://forum.kx.com/t/xgroup-error-in-taxi-and-weather-analysis/14036)
**Author:** [@lestat-jin](https://forum.kx.com/u/lestat-jin)\ **Replies:** 4\ **Last updated:** [August 28, 2024, 11:30am UTC](https://forum.kx.com/t/xgroup-error-in-taxi-and-weather-analysis/14036 "2024-08-28T11:30:39Z")
https://learninghub.kx.com/forums/topic/xgroup-error-in-taxi-and-weather-analysis followed steps until calling xgroup to creat keyed table: grouped\_taxi\_dates, grouped\_taxi\_days,grouped\_taxi\_hours, which are running fin… --- ## [Numpy 2.0](https://forum.kx.com/t/numpy-2-0/14038)
**Author:** [@jroche](https://forum.kx.com/u/jroche)\ **Replies:** 1\ **Last updated:** [August 26, 2024, 8:26am UTC](https://forum.kx.com/t/numpy-2-0/14038 "2024-08-26T08:26:28Z")
https://learninghub.kx.com/forums/topic/numpy-2-0 It looks like pykx is currently not compatible with numpy \>= 2.0, is there any plan in the near future to support it? --- ## [Unable to install the pykx in DataBricks. Got PyKXException: Failed to initializ](https://forum.kx.com/t/unable-to-install-the-pykx-in-databricks-got-pykxexception-failed-to-initializ/14023)
**Author:** [@senthil](https://forum.kx.com/u/senthil)\ **Replies:** 2\ **Last updated:** [August 19, 2024, 4:34pm UTC](https://forum.kx.com/t/unable-to-install-the-pykx-in-databricks-got-pykxexception-failed-to-initializ/14023 "2024-08-19T16:34:39Z")
https://learninghub.kx.com/forums/topic/unable-to-install-the-pykx-in-databricks-got-pykxexception-failed-to-initializ I try to install pykx on my databricks environment. The pip install was done. When I try to import t… --- ## [pykx is returning different output compared to embedQ](https://forum.kx.com/t/pykx-is-returning-different-output-compared-to-embedq/13985)
**Author:** [@jameswatt995](https://forum.kx.com/u/jameswatt995)\ **Replies:** 2\ **Last updated:** [July 11, 2024, 1:48pm UTC](https://forum.kx.com/t/pykx-is-returning-different-output-compared-to-embedq/13985 "2024-07-11T13:48:09Z")
https://learninghub.kx.com/forums/topic/pykx-is-returning-different-output-compared-to-embedq I have recently switched from embedPyb to PyKX. I had a function called decodeBuffer which was outputing colls like in image… --- ## [PyKX 2.5.1 Released!](https://forum.kx.com/t/pykx-2-5-1-released/13951)
**Author:** [@cmccarthy1](https://forum.kx.com/u/cmccarthy1)\ **Replies:** 0\ **Last updated:** [June 11, 2024, 3:06pm UTC](https://forum.kx.com/t/pykx-2-5-1-released/13951 "2024-06-11T15:06:01Z")
https://learninghub.kx.com/forums/topic/pykx-2-5-1-released Hi All, PyKX 2.5.1 has now been released ? Full release notes can be found here. This release contains a number of additions and fixes as highlighted below - P… --- ## [PyKx transaction cost analysis](https://forum.kx.com/t/pykx-transaction-cost-analysis/13933)
**Author:** [@hiuq](https://forum.kx.com/u/hiuq)\ **Replies:** 1\ **Last updated:** [June 11, 2024, 11:17am UTC](https://forum.kx.com/t/pykx-transaction-cost-analysis/13933 "2024-06-11T11:17:58Z")
https://learninghub.kx.com/forums/topic/pykx-transaction-cost-analysis In Transaction Cost Analysis session : If it is "BUY" and execution price is lower than mid price, isn't it in favour of clients because clients can… --- ## [Failed to Load KX Insights Core Library error when using pykx in q](https://forum.kx.com/t/failed-to-load-kx-insights-core-library-error-when-using-pykx-in-q/13897)
**Author:** [@jameswatt995](https://forum.kx.com/u/jameswatt995)\ **Replies:** 11\ **Last updated:** [June 5, 2024, 2:32pm UTC](https://forum.kx.com/t/failed-to-load-kx-insights-core-library-error-when-using-pykx-in-q/13897 "2024-06-05T14:32:26Z")
https://learninghub.kx.com/forums/topic/failed-to-load-kx-insights-core-library-error-when-using-pykx-in-q I have installed pykx it seems to work, but I get this error when I load the pykx.q library After I run \\l pyk… --- ## [transaction cost analysis project](https://forum.kx.com/t/transaction-cost-analysis-project/13932)
**Author:** [@hiuq](https://forum.kx.com/u/hiuq)\ **Replies:** 0\ **Last updated:** [May 22, 2024, 4:50am UTC](https://forum.kx.com/t/transaction-cost-analysis-project/13932 "2024-05-22T04:50:31Z")
https://learninghub.kx.com/forums/topic/transaction-cost-analysis-project In Transaction Cost Analysis session : If it's "BUY" and execution price is lower than mid price, isn't it in favour of clients because clients c… --- ## [PyKX 2.5.0 released](https://forum.kx.com/t/pykx-2-5-0-released/13929)
**Author:** [@rocuinneagain](https://forum.kx.com/u/rocuinneagain)\ **Replies:** 0\ **Last updated:** [May 21, 2024, 1:22pm UTC](https://forum.kx.com/t/pykx-2-5-0-released/13929 "2024-05-21T13:22:20Z")
https://learninghub.kx.com/forums/topic/pykx-2-5-0-released PyKX 2.5.0 has been released. Full release notes for can be found here. Highlights: table.xbar , table.window\_join , table.replace Added as\_arrow keyword to th… --- ## [pykx pandas.read\_html() fails to convert string to html table](https://forum.kx.com/t/pykx-pandas-read-html-fails-to-convert-string-to-html-table/13927)
**Author:** [@jameswatt995](https://forum.kx.com/u/jameswatt995)\ **Replies:** 1\ **Last updated:** [May 21, 2024, 9:12am UTC](https://forum.kx.com/t/pykx-pandas-read-html-fails-to-convert-string-to-html-table/13927 "2024-05-21T09:12:31Z")
https://learninghub.kx.com/forums/topic/pykx-pandas-read\_html-fails-to-convert-string-to-html-table Hi I have started using pykx within my kdb system . Here's the issue: (see the photo. something went wrong with th… --- ## [PyKX IPC work with multithreading?](https://forum.kx.com/t/pykx-ipc-work-with-multithreading/13194)
**Author:** [@cleung](https://forum.kx.com/u/cleung)\ **Replies:** 3\ **Last updated:** [April 19, 2024, 12:13pm UTC](https://forum.kx.com/t/pykx-ipc-work-with-multithreading/13194 "2024-04-19T12:13:38Z")
https://learninghub.kx.com/forums/topic/pykx-ipc-work-with-multithreading Hi there, I have a PyKx process that uses IPC to connect to a port, and we're running some KDB functions that involve multithreading (cutPea… [Next page](https://forum.kx.com/tag/pykx/31.md?match_all_tags=true&page=1&tags%5B%5D=pykx)