Replies – Forums – k2q – KX Learning Hub

Forum Replies Created

k2q

Member
January 3, 2025 at 1:04 pm in reply to: Query does not return row count from trade pipeline
Just try this one.
```
select count i from trade
```
Refer q4m3: https://code.kx.com/q4m3/9_Queries_q-sql/#9133-basic-queries

k2q

Member

January 10, 2025 at 8:13 am in reply to: PyKXException – Valid KDB+/Q License

Thanks for your response, please see below.

q shell output

KDB+ 4.1 2024.10.16 Copyright (C) 1993-2024 Kx Systems
l64/ 4(24)core 7461MB rr rkr 127.0.1.1 EXPIRE 2026.01.04 @gmail.com KDB INSIGHTS #xxxx593
q)`insights.lib.embedq`insights.lib.pykx in `$" " vs .z.l 4 // Should return 11b
11b
q)\\

pykx import error snapshot

Python 3.10.12 (main, Nov  6 2024, 20:22:13) [GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import pykx as kx
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/rr/.local/lib/python3.10/site-packages/pykx/__init__.py", line 32, in <module>
    from . import core
  File "pykx/core.pyx", line 394, in init pykx.core
pykx.exceptions.PyKXException: Early garbage collection requires a valid q license.
>>> quit()

pip installation output

$ pip3.10 install pykx
Defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: pykx in /home/rr/.local/lib/python3.10/site-packages (3.0.1)
Requirement already satisfied: dill>=0.2.0 in /home/rr/.local/lib/python3.10/site-packages (from pykx) (0.3.9)
Requirement already satisfied: pandas<=2.2.3,>=1.2 in /home/rr/.local/lib/python3.10/site-packages (from pykx) (2.2.3)
Requirement already satisfied: toml~=0.10.2 in /home/rr/.local/lib/python3.10/site-packages (from pykx) (0.10.2)
Requirement already satisfied: numpy<2.0,~=1.22 in /home/rr/.local/lib/python3.10/site-packages (from pykx) (1.26.4)
Requirement already satisfied: pytz>=2022.1 in /usr/lib/python3/dist-packages (from pykx) (2022.1)
Requirement already satisfied: requests>=2.25.0 in /home/rr/.local/lib/python3.10/site-packages (from pykx) (2.32.3)
Requirement already satisfied: tzdata>=2022.7 in /home/rr/.local/lib/python3.10/site-packages (from pandas<=2.2.3,>=1.2->pykx) (2024.2)
Requirement already satisfied: python-dateutil>=2.8.2 in /home/rr/.local/lib/python3.10/site-packages (from pandas<=2.2.3,>=1.2->pykx) (2.9.0.post0)
Requirement already satisfied: charset-normalizer<4,>=2 in /home/rr/.local/lib/python3.10/site-packages (from requests>=2.25.0->pykx) (3.4.1)
Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/lib/python3/dist-packages (from requests>=2.25.0->pykx) (1.26.5)
Requirement already satisfied: certifi>=2017.4.17 in /usr/lib/python3/dist-packages (from requests>=2.25.0->pykx) (2020.6.20)
Requirement already satisfied: idna<4,>=2.5 in /usr/lib/python3/dist-packages (from requests>=2.25.0->pykx) (3.3)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas<=2.2.3,>=1.2->pykx) (1.16.0)