Stack Overflow
Stack Overflow

Questions tagged [pyq]

PyQ provides seamless integration of Python and Q code.

PyQ brings the Python programming language to the kdb+ database. It allows developers to seamlessly integrate Python and q codes in one application. This is achieved by bringing the Python and q interpreters in the same process so that codes written in either of the languages operate on the same data. In PyQ, Python and q objects live in the same memory space and share the same data.

http://pyq.enlnt.com

27 questions
1
vote
1 answer

Retain KDB Long Epoch Time When Importing Into Pandas

I have epoch times from KDB e.g. 530782044475144833. But any data type I have used in Pandas e.g. int, float64 severely round it up to 5.31e+17, rendering it useless. How do I retain the entire length of the KDB epoch time when reading into Pandas?…
skafetaur
  • 143
  • 1
  • 1
  • 7
0
votes
0 answers

How do I install PYQ in Conda or Pycharm?

I follow this link Install into a virtual environment 01 I create venv /home/evol/pyq 02 source /home/evol/pyq/bin/active 03 Download l64.zip to /home/evol/pyq/q 04 Copy license to /home/evol/pyq/q 05 The q folder is 06 Set activate file add code…
evol
  • 1
  • 1
0
votes
3 answers

"ERROR: Could not build wheels for pyq which use PEP 517 and cannot be installed directly" when installing PyQ?

I'm wondering if anyone has encountered any similar errors when attempting to install PyQ for Windows? I've tried both Anaconda and the Windows prompt and there doesn't appear to be any difference in the errors produced. Any help is much…
StackPro_1111
  • 49
  • 5
0
votes
1 answer

Save KDB+/q table on a Mac

I'm new to q and I'm trying to save a file on my Mac. Currently using Jupyter Notebook if that makes a difference. A quick table: t:([] c1:`a`b`c; c2:1.1 2.2 3.3) I first extract my current location by using \cd and i get:…
Gorlomi
  • 515
  • 2
  • 11
0
votes
1 answer

Importing PyQ from within Spyder causes kernel to die

Have installed kdb+ 64-bit to a Windows 10 machine. Running within Anaconda/Spyder, when I import PyQ, I get an error message that the kernel died. No issues running q stand alone from the command line. Both of these import pyq from pyq import…
Chris
  • 1,401
  • 4
  • 17
  • 28
0
votes
1 answer

parallel processing in q function called from python

From q reference: In order to execute in parallel, q must be started with multiple slaves, using -s in the command line, and the \s system command. Is it possible to make use of peach in a q function which is called from pyq (python)? from…
Xpector
  • 639
  • 1
  • 5
  • 17
0
votes
1 answer

Notebook cells don't run after first error until PyQ kernel restart

I'm running a jupyter notebook with PyQ kernel and able to run both python and q code. BUT: whenever a cell produces an error (like calling a nonexisting_function()), no more cells are executed until I restart the kernel. In contrast, with Python…
Xpector
  • 639
  • 1
  • 5
  • 17
0
votes
1 answer

Open connection handle and update kdb table with hopen in PyQ

I'd like to use PyQ to parse a json object and then update a keyed kdb table running on a different port by pushing the parsed data through an open handle to the keyed table. To open a handle and update the kdb table in q would require the following…
marrowgari
  • 417
  • 3
  • 15
0
votes
1 answer

Upsert to a table in pyq

OS: Windows 10 Enterprise, Python: Python 3.6.4, PyQ: pyq (4.1.4). I'm pretty certain my data types are correct, though I keep receiving _k.error: type when I attempt to upsert to my table. First I initialize the table with the following…
marrowgari
  • 417
  • 3
  • 15
0
votes
1 answer

PyQ - q.upsert and q.set append to splayed kdb database

When I run the following code in pyq... from bittrex.bittrex import Bittrex, API_V2_0 import time, json from pyq import q, K get_bittrex = Bittrex(None, None) starttime = time.time() market_result =…
marrowgari
  • 417
  • 3
  • 15
0
votes
1 answer

PYQ ImportError: No module named pyq

I am trying to install pyq on 64 bit Ubuntu. I have a 64 bit KDB+ license. I followed the steps given in Pyq Installation for installing in a licensed Kdb+. I created a virtual environment. pip install virtualenv mkdir python-virtual-environments…
Abhinav Choudhury
  • 319
  • 2
  • 3
  • 15
0
votes
2 answers

"No such file or directory" error while running pyq in Ubuntu with 32 bit kdb+

I have installed pyq by following the instruction from https://pyq.enlnt.com/install/install.html#install. I created a virtualenv py2 and downloaded kdb+ from https://kx.com/download/software-download.L.php?agree=willa382*-fyeERA332880aa2013 and…
Abhinav Choudhury
  • 319
  • 2
  • 3
  • 15
1
2