[ 
https://issues.apache.org/jira/browse/HIVE-23179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Naresh P R updated HIVE-23179:
------------------------------
    Attachment: HIVE-23179.3.patch

> 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, HIVE-23179.2.patch, 
> HIVE-23179.3.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)

Reply via email to