[HIVE-23179] Show create table is not showing SerDe Properties in unicode

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Naresh P R
• Reporter: Naresh P R
• Created: 10/Apr/20 23:31
• Updated: 17/Nov/22 08:50
• Resolved: 15/Apr/20 18:23

Description

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