You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naresh P R (Jira)" <ji...@apache.org> on 2020/04/10 23:32:01 UTC

[jira] [Assigned] (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:all-tabpanel ]

Naresh P R reassigned HIVE-23179:
---------------------------------


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