kdb+ and q
Q+A on all things kdb+ database and the q language
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

q() Tableau Query escape character

I'm looking for a way to escape certain queries in Tableau's q() function. Issues with ? and "Any help appreciated! Thanks!

Jean by New Contributor
  • 734 Views
  • 1 replies
  • 0 kudos

KDB q sql in Tableau

Hi, I managed to get connected from Tableau to KDB. However, there are certain characters that Tableau's SQL is having issues escaping (ex. ?) I need to use vector conditionals but I can't seem to get the query to work within the q() function. Anyone...

Jean by New Contributor
  • 461 Views
  • 0 replies
  • 0 kudos

xasc with duplicate cols => improve error message

Why does xasc fails in my example?Also it would be useful to put the carat(^) under `pe and not xasc if q knows p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Menlo; color: #d0d2da; background-color: #161821; background-color: rgba(22, 24, 33, 0...

ag1 by New Contributor
  • 830 Views
  • 2 replies
  • 0 kudos

.Q.hg limit?

What is the max url length accepted by .Q.hg (HTTP GET)?I looked in .q.k, it doesn't appear that .Q.hmb or Q.hg checks for a limit.Please update the documentation @ http://code.kx.com/q/ref/dotq/#qhg-http-get with the max length.https://stackoverflow...

ag1 by New Contributor
  • 1251 Views
  • 2 replies
  • 0 kudos

Higher-order arrays in q.

Why is q)(5 3 3)#1 displayed as follows?q)(5 3 3)#11 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 1Shouldn't it be as follows ?1 1 11 1 11 1 1 1 1 11 1 11 1 1 1 1 11 1 11 1 1 1 1 11 1 11 1 1 1 1 11 1 11 1 1How doe...

Krishna by New Contributor
  • 879 Views
  • 1 replies
  • 0 kudos