AnsweredAssumed Answered

org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR

Question asked by chris.crawford on Apr 3, 2018
Latest reply on Apr 7, 2018 by cathy
Branched from an earlier discussion

Thanks Sorabh Hamirwasia but I received the following error:

 

org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: Encountered "default" at line 1, column 15. Was expecting one of: <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "LATERAL" ... "(" ... "UNNEST" ... "TABLE" ... SQL Query SELECT * FROM default.`customers` ^ [Error Id: 6e5effed-24f6-4cc6-a48f-def8f6d4698d on

 

I have confirmed that the query works in HUE as "Select * from customers;" with default selected and that there is data in there.

Outcomes