[
https://issues.apache.org/jira/browse/DRILL-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744565#comment-14744565
]
Chun Chang commented on DRILL-2862:
-----------------------------------
verified fix.
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select t.last_name from
cp.`employee.json` t limit 1;
+------------+
| last_name |
+------------+
| Nowmer |
+------------+
1 row selected (0.244 seconds)
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select t.last_name from
cp.`employee.json` t limit 1;
+------------+
| last_name |
+------------+
| Nowmer |
+------------+
1 row selected (0.27 seconds)
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select
convert_from(t.last_name,'UTF-8') from cp.`employee.json` t limit 1;
Error: UNSUPPORTED_OPERATION ERROR: CONVERT_FROM does not support conversion
from type 'UTF-8'.
Did you mean UTF8?
[Error Id: 269ad71c-a39c-4976-8e72-276bf55e0b1f on 10.10.30.167:31010]
(state=,code=0)
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select
convert_from(t.last_name,'UTF8') from cp.`employee.json` t limit 1;
+---------+
| EXPR$0 |
+---------+
| Nowmer |
+---------+
1 row selected (0.289 seconds)
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select commit_id from
sys.version;
+-------------------------------------------+
| commit_id |
+-------------------------------------------+
| 0686bc23e8fbbd14fd3bf852893449ef8552439d |
+-------------------------------------------+
1 row selected (0.239 seconds)
> Convert_to/Convert_From throw assertion when an incorrect encoding type is
> specified
> ------------------------------------------------------------------------------------
>
> Key: DRILL-2862
> URL: https://issues.apache.org/jira/browse/DRILL-2862
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Reporter: Neeraja
> Assignee: Parth Chandra
> Fix For: 1.2.0
>
> Attachments: DRILL-2862.3.patch.txt
>
>
> Below is the error from SQLLine. Replacing UTF-8 to UTF8 works fine.
> The error message need to accurately represent the problem.
> 0: jdbc:drill:> select Convert_from(t.address.state,'UTF-8') from customers t
> limit 10;
> Query failed: AssertionError:
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
