ParseException in Hive

Question

I am trying to use a UDF in hive. But when I try to create a temporary function using  userdate as 'unixtimeToDate', I get this exception

hive> create temporary function userdate1 as 'unixtimeToDate';
FAILED: ParseException line 1:25 character ' ' not supported here
line 1:35 character ' ' not supported here

I am not sure why the character is not supported. Could I get some guidance on this please.

Answer 1

The exception is clear enough here, you have an error in your SQL. You have a full width space in your SQL. More about Halfwidth_and_fullwidth_forms

hive> create temporary function userdate1 as 'unixtimeToDate';
                                        ^^^here, you have a full width space