Naresh P R created HIVE-23179:
---------------------------------

             Summary: 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


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