Have folder structure: C:/dir/2014.01.01/exampleTable
C:/dir/2014.01.01/sym ... do \cd dir/2014.01.01
exampleTable:get:`exampleTable If folder less than 38 GB typing
exapleTable or a more specific query will work, else get +.... error. Is
there a way...
Loading a number of *.mat files into Kdb. Some of the files load with no
problems, some (probably less than a half) frow a bunch of 'type 'rank
errors and leave consistently four columns in the table blank. The
failed *.mat files seem OK.
How to perform a pattern matching operation on a long data type in
Kdb?All of the following give me a `type error:select instrument from
Table where time=14201%select instrument from Table where
time=14201*select instrument from Table where time=`142...
Say I want to retrieve all price data for times starting with 1420*
(e.g. time=1418234533892319745).I (unsuccessfully) tried:select price
from Table where time=`14201%select price from Table where
time=`14201*select price from Table where time=14201%...
The error appears sporadically, whilst loading *.mat files into the
database; could have loaded 500 GB of data, could have just 100 MB:Error
using kx/exec (line 69)Java exception occurred:java.net.SocketException:
Connection reset at java.net.SocketO...
double and int64. Some double variables actually could be int, as they
contain no decimal places.Is there an alternative syntax I could try?
The thing that worries me that this problem only occurs when I append
the table; it does not happen for loadi...
It is more to do with the q syntax I am using:exec(q, ['tempTable:(
name; number1; number2;'... 'number3; number4; number5; number6;
number7; number8l)']);exec(q,'`:Table/ upsert .Q.en[`:.; tempTable]');I
have a temp table for memory management pur...