You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Miklos Gergely (Jira)" <ji...@apache.org> on 2020/04/11 10:02:00 UTC
[jira] [Commented] (HIVE-23179) Show create table is not showing
SerDe Properties in unicode
[ https://issues.apache.org/jira/browse/HIVE-23179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17081226#comment-17081226 ]
Miklos Gergely commented on HIVE-23179:
---------------------------------------
lgtm, but please use org.apache.commons.text.StringEscapeUtils as org.apache.commons.lang3.StringEscapeUtils is deprecated. Are we sure that serde property values may not contain ' or ; characters?
> Show create table is not showing SerDe Properties in unicode
> ------------------------------------------------------------
>
> Key: HIVE-23179
> URL: https://issues.apache.org/jira/browse/HIVE-23179
> Project: Hive
> Issue Type: Bug
> Reporter: Naresh P R
> Assignee: Naresh P R
> Priority: Minor
> Attachments: HIVE-23179.1.patch
>
>
> Table with special character delimiters are not shown in show create output
> eg.,
> create external table test(age int, name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' stored as textfile;
> Show create output
> +----------------------------------------------------+
> | createtab_stmt |
> +----------------------------------------------------+
> | CREATE EXTERNAL TABLE `test`( |
> | `age` int, |
> | `name` string) |
> | ROW FORMAT SERDE |
> | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
> | WITH SERDEPROPERTIES ( |
> | 'field.delim'='', |
> | 'serialization.format'='') |
> | STORED AS INPUTFORMAT |
> | 'org.apache.hadoop.mapred.TextInputFormat' |
> | OUTPUTFORMAT |
> | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
> | LOCATION |
> | 'hdfs://abcd:8020/warehouse/tablespace/external/hive/testca' |
> | TBLPROPERTIES ( |
> | 'bucketing_version'='2', |
> | 'discover.partitions'='true', |
> | 'transient_lastDdlTime'='1577162310') |
> +----------------------------------------------------+
> Few client console not able to show ^A (Ctrl + A) properly. It's better to show the output in unicode as shown in desc formatted.
> | Storage Desc Params: | NULL | NULL |
> | | field.delim | \u0001 |
> | | serialization.format | \u0001
--
This message was sent by Atlassian Jira
(v8.3.4#803005)