[DRILL-3544] Need better error messages when convert_to is given a bad type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Ted Dunning
• Created: 23/Jul/15 02:09
• Updated: 23/Jul/15 02:38
• Resolved: 23/Jul/15 02:38

Description

The first query below fails because I used UTF-8 instead of UTF8. This should have a decent error message.

0: jdbc:drill:zk=local> SELECT CONVERT_TO('[ [1, 2], [3, 4], [5]]' ,'UTF-8') AS MYCOL1 FROM sys.version;
Error: SYSTEM ERROR: org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: null

[Error Id: 899207da-2338-4b09-bdc8-8e12e320b661 on 172.16.0.61:31010] (state=,code=0)
0: jdbc:drill:zk=local> SELECT CONVERT_TO('[ [1, 2], [3, 4], [5]]' ,'UTF8') AS MYCOL1 FROM sys.version;
+-------------+
|   MYCOL1    |
+-------------+
| [B@71f3d3a  |
+-------------+
1 row selected (0.108 seconds)
0: jdbc:drill:zk=local> 

Issue Links

• duplicates: DRILL-2862 Convert_to/Convert_From throw assertion when an incorrect encoding type is specified