I've updated the https://github.com/JohnOmernik/caraveldrill
At this point, adding a database with Drill works! You can now press test connection and we get a "Seems Ok" As we prune out old stuff, and add in Drill stuff, I am using comments to identify what we added and what has been there, if a class in the dialect has no comments, assume it's all MSAccess dialect code... (I know this is a horrible way to code, but I am learning and like sharing my learnings :) John On Mon, May 16, 2016 at 2: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)* >> > >
