AWESOME! Yep, that works and I like it better than using sys.options. Now to dive in and play with the Dialect.
Note, I will be uploading an unfinished dialect in my caraveldrill repo... the goal isn't a production ready thing, but a skeleton (based on the access one) of what a dialect is... The purpose is to evolve things as put it all in one area for people to work with. As of now, I have no clue how to trap statements with no FROM, but that's my first thing to work on :) Thanks for the help Veera! John On Mon, May 16, 2016 at 2:20 PM, Veera Naranammalpuram < vnaranammalpu...@maprtech.com> wrote: > Does this work? > > 0: jdbc:drill:zk=local> SELECT 'x' AS some_label from (values(1)); > +-------------+ > | some_label | > +-------------+ > | x | > +-------------+ > 1 row selected (1.41 seconds) > 0: jdbc:drill:zk=local> > > -Veera > > On Mon, May 16, 2016 at 3:19 PM, John Omernik <j...@omernik.com> wrote: > > > I suppose I could do select 'x' AS some_label from sys.options limit 1; > > > > any reason not to? Any other options? > > > > On Mon, May 16, 2016 at 2:18 PM, John Omernik <j...@omernik.com> wrote: > > > > > Does Drill have a "dummy" table (like dual) that we could test against? > > If > > > we had that I could replace the that in a dialect (I think) > > > > > > SELECT 'test plain returns' AS anon_1 > > > > > > > > > SELECT 'x' AS some_label > > > > > > > > > SELECT 'test unicode returns' AS anon_1 > > > > > > > > > SELECT 'x' AS some_label > > > > > > > > > Drill is looking for a "FROM" :) > > > > > > > > > > > > > > > > > > -- > Veera Naranammalpuram > Product Specialist - SQL on Hadoop > *MapR Technologies (www.mapr.com <http://www.mapr.com>)* > *(Email) vnaranammalpu...@maprtech.com <naranammalpu...@maprtech.com>* > *(Mobile) 917 683 8116 - can text * > *Timezone: ET (UTC -5:00 / -4:00)* >