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)*
