[
https://issues.apache.org/jira/browse/HIVE-18112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16262099#comment-16262099
]
Naresh P R commented on HIVE-18112:
-----------------------------------
Thanks for the help [~ashutoshc]
>From current master branch code, i could see as part of HIVE-14013, along with
>describe issue, show create issue is also fixed in 2.2.1 & higher versions.
I want this fix in 2.1.0 & 1.2.0
> show create for view having special char in where clause is not showing
> properly
> --------------------------------------------------------------------------------
>
> Key: HIVE-18112
> URL: https://issues.apache.org/jira/browse/HIVE-18112
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.0
> Reporter: Naresh P R
> Assignee: Naresh P R
> Priority: Minor
> Fix For: 2.1.0
>
> Attachments: HIVE-18112.patch
>
>
> e.g.,
> CREATE VIEW `v2` AS select `evil_byte1`.`a` from `default`.`EVIL_BYTE1` where
> `evil_byte1`.`a` = 'abcÖdefÖgh';
> Output:
> ======
> 0: jdbc:hive2://172.26.122.227:10000> show create table v2;
> +----------------------------------------------------------------------------------------------------------------+--+
> | createtab_stmt
> |
> +----------------------------------------------------------------------------------------------------------------+--+
> | CREATE VIEW `v2` AS select `evil_byte1`.`a` from `default`.`EVIL_BYTE1`
> where `evil_byte1`.`a` = 'abc�def�gh' |
> +----------------------------------------------------------------------------------------------------------------+--+
> Only show create output is having invalid characters, actual source table
> content is displayed properly in the console.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
