drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2862) Convert_to/Convert_From throw assertion when an incorrect encoding type is specified
Date Tue, 15 Sep 2015 00:24:46 GMT

    [ 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)

Mime
View raw message