Looks like Calcite, the SQL parser that Drill uses, treats translate as a build-in function : translate( expression USING identifier). That's why you saw the Parser error.
[1] https://github.com/apache/calcite/blob/master/core/src/main/codegen/templates/Parser.jj#L3987-L4005 On Wed, Feb 24, 2016 at 1:23 PM, Arina Yelchiyeva <arina.yelchiy...@gmail.com> wrote: > Hi all! > > Does all Hive functions work in Drill? > > I have faced the issue with translate function. > In Hive "select translate(name, 'A', 'B') from users" works fine. > But in Drill "select translate(name, 'A', 'B') from hive.`users`" return > the following error: > > org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: > Encountered "," at line 1, column 22. Was expecting one of: "USING" ... > "NOT" ... "IN" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "=" ... ">" ... > "<" ... "<=" ... ">=" ... "<>" ... "+" ... "-" ... "*" ... "/" ... "||" ... > "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... "MULTISET" ... > "[" ... "." ... "(" ... while parsing SQL query: select translate(name, > 'A', 'B') from hive.users ^ [Error Id: ba21956b-3285-4544-b3b2-fab68b95be1f > on localhost:31010] > > Am I missing something? Or I should create jira to fix for bug fix? > > Kind regards > Arina
