0 votes
I read the http://www.ivoa.net/documents/latest/ADQL.html standard, and ampersand ('&') is an allowed operator, but it's not clear what it does.  When I try to use it for bitwise operations (which it is used for in standard SQL), my queries fail.
asked Jun 22, 2017 by Benjamin Weaver | 165 views

1 Answer

0 votes
Hi Benjamin!

Thank you for your question.  I can confirm your experience.  The parser emits an error similar to:

"java.io.IOException: IllegalArgumentException: net.sf.jsqlparser.JSQLParserException JSQLParserException:" ... Encountered: "&" (38), after : "

So this operator looks like it is not implemented yet.   We will let the team know.

In the meantime, maybe try the query through our datalab command line client, or the API?  For the filters it's convenient to have bitwise logic available, but a workaround sometimes is easy just using decimal ranges.
answered Jul 6, 2017 by Adam Scott

252 questions

254 answers


1,716 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.