andyturk
New Contributor
since ‎2009.08.03
‎2021.06.14

User Statistics

  • 47 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

I'm puzzled about how kdb performs grouped queries. When a query has no explicit results, but does have a grouping (e.g., "select by ... from ...") kdb seems to implicitly return only the last element of each grouped column. When the result columns a...
It appears that queries that have a "group by" clause always return aresult that's sorted on the grouped columns. Why is that?q)t:([]a:10?100;b:10?100;c:10?8)q)ta b c-------2 84 439 63 064 93 249 54 182 38 240 97 188 88 277 58 330 68 217 45 5q)select...
Should the presence of a "where" clause in a query change the columnnames of the result?Consider the two queries below. Each is run against the same table andproduces the same rows. The first query produces columns named "x" and"w", which makes sense...
In a traditional ACID database, when an error occurs inside atransaction, any updates made previously in the transaction are eitherrolled back or simply thrown away.I expected q's table operations to behave the same way. However, thisappears not to b...
The cookbook wiki says that floating point comparison tolerance ishardwired at 2^-43 times the magnitude of the larger of the twonumbers being compared. That makes sense for 8-byte floats (with 53-bit mantissas) but is beyond the resolution of 4-byte...