FYI, the calcite branch of Phoenix supports the WITH clause. If you're just experimenting, you might give that a try, but I wouldn't recommend putting that in production yet.
Thanks, James On Mon, Jan 16, 2017 at 8:52 AM, Josh Elser <els...@apache.org> wrote: > Phoenix's grammar is documented at http://phoenix.apache.org/lang > uage/index.html > > > Cheyenne Forbes wrote: > >> Can I use the SQL WITH clause Phoenix instead of "untidy" sub queries? >> >