Start a new topic

Hive - Error while compiling character ' ' not supported here

Hello


I am new to DbViz. I am connected to a Hive DB. Every simple query that I want to submit produce an error telling that "ParseException line 2:26 character ' ' not supported here". 


A snapshot of the error and the code is attached.


Is there a way to format my SQL code so that writing space and tabs in the editor become understandable in compilation?


Appreciate any words of wisdom anyone could share.


 

Capture.PNG
(41.5 KB)

Hi Isaac,


This Stackoverflow post seems to describe the problem:


https://stackoverflow.com/questions/33230159/parseexception-in-hive


You probably have full width space characters in your script, maybe from copying code from a word processor. Replace them with regular space to fix the issue.


Best Regards

Hans


1 person likes this

Thanks it works!

Login or Signup to post a comment