Hao, I have been using sys.version for typical queries 'dual’ would be used for, as it is a simple 1 row table that is always present.
select 1 from sys.version; is a pretty simple DB “ping”. Likely not be ideal, but something you can use in the meantime. —Andries On Feb 17, 2015, at 11:28 AM, Hao Zhu <[email protected]> wrote: > Two thoughts: > 1. Can we have error message saying something like : > "This is a reserved word, please add back-ticks around if needed." > > 2. Can we have a "dual" table like oracle? > > Thanks, > Hao > > > On Sun, Feb 15, 2015 at 3:54 PM, Minnow Noir <[email protected]> wrote: > >> Using the backticks worked. Thanks for the tip. >> >> +------------+ >> | EXPR$0 | >> +------------+ >> | ah | >> +------------+ >> 1 row selected (1.448 seconds) >> >> The docs ["right(str text, n int)"] don't mention anything about using >> backticks? >> >> On Sat, Feb 14, 2015 at 4:26 AM, Abhishek Girish <[email protected]> wrote: >> >>> Hi Minnow, >>> >>> Can you try this: >>> >>>> select *`right`*('blahblah',2) from sys.options limit 1; >>> >>> +------------+ >>> | EXPR$0 | >>> +------------+ >>> | ah | >>> +------------+ >>> 1 row selected (0.046 seconds) >>> >>>> select *`left`*('blahblah',2) from sys.options limit 1; >>> +------------+ >>> | EXPR$0 | >>> +------------+ >>> | bl | >>> +------------+ >>> 1 row selected (0.039 seconds) >>> >>> Regards, >>> Abhishek >>> >>> On Fri, Feb 13, 2015 at 6:59 PM, Minnow Noir <[email protected]> >> wrote: >>> >>>> right() is documented on the wiki ( >>>> https://cwiki.apache.org/confluence/display/DRILL/SQL+Functions, last >>>> edited 6 weeks ago), but doesn't seem to be a valid function: >>>> >>>> use sys; >>>> 0: jdbc:drill:zk=local> select right("blahblah",2) from version; >>>> Query failed: Query failed: Failure parsing SQL. Encountered "right" at >>>> line 1, column 8. >>>> >>>> It doesn't show up in the list of expected functions: >>>> >>>> "POWER" ... >>>> "RANK" ... >>>> "ROW_NUMBER" ... >>>> "SQRT" ... >>>> "STDDEV_POP" ... >>>> >>>> What am I missing? >>>> >>> >>
