John Great. Can we briefly look at this during hang out tomorrow. On Mon, May 16, 2016 at 12:26 PM, John Omernik <[email protected]> wrote:
> 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 < > [email protected]> 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 <[email protected]> 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 <[email protected]> > 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) [email protected] <[email protected]>* > > *(Mobile) 917 683 8116 - can text * > > *Timezone: ET (UTC -5:00 / -4:00)* > > >
