describe escape_column_comments; Beeline original +--------------------------+------------+--------------+ | col_name | data_type | comment | +--------------------------+------------+--------------+ | col1 | string | test\tcol1 | | col2 | string | col2 | | col3 | string | | | part1 | string | test\tpart1 | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | part1 | string | test\tpart1 | +--------------------------+------------+--------------+ Beeline patch +--------------------------+------------+---------------+ | col_name | data_type | comment | +--------------------------+------------+---------------+ | col1 | string | test\\tcol1 | | col2 | string | col2 | | col3 | string | | | part1 | string | test\\tpart1 | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | part1 | string | test\\tpart1 | +--------------------------+------------+---------------+ Cli original col1 string test col2 string col2 col3 string part1 string test # Partition Information # col_name data_type comment part1 string test Cli patch col1 string test\tcol1 col2 string col2 col3 string part1 string test\tpart1 # Partition Information # col_name data_type comment part1 string test\tpart1 describe formatted escape_column_comments; Beeline original +-------------------------------+----------------------------------------------------+-----------------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------------+ | # col_name | data_type | comment | | col1 | string | test\tcol1 | | col2 | string | col2 | | col3 | string | | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | part1 | string | test\tpart1 | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | default | NULL | | Owner: | hive3 | NULL | | CreateTime: | Wed Mar 07 19:16:21 CST 2018 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Location: | hdfs://ns2/tmp/escape_column_comments | NULL | | Table Type: | MANAGED_TABLE | NULL | | Table Parameters: | NULL | NULL | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\"} | | | numFiles | 0 | | | numPartitions | 0 | | | numRows | 0 | | | rawDataSize | 0 | | | totalSize | 0 | | | transient_lastDdlTime | 1520421381 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | +-------------------------------+----------------------------------------------------+-----------------------------+ Beeline patch +-------------------------------+----------------------------------------------------+-----------------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------------+ | # col_name | data_type | comment | | col1 | string | test\\tcol1 | | col2 | string | col2 | | col3 | string | | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | part1 | string | test\\tpart1 | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | default | NULL | | Owner: | hive3 | NULL | | CreateTime: | Wed Mar 07 19:16:21 CST 2018 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Location: | hdfs://ns2/tmp/escape_column_comments | NULL | | Table Type: | MANAGED_TABLE | NULL | | Table Parameters: | NULL | NULL | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\"} | | | numFiles | 0 | | | numPartitions | 0 | | | numRows | 0 | | | rawDataSize | 0 | | | totalSize | 0 | | | transient_lastDdlTime | 1520421381 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | +-------------------------------+----------------------------------------------------+-----------------------------+ Cli original # col_name data_type comment col1 string test col2 string col2 col3 string # Partition Information # col_name data_type comment part1 string test # Detailed Table Information Database: default Owner: hive3 CreateTime: Wed Mar 07 19:16:21 CST 2018 LastAccessTime: UNKNOWN Retention: 0 Location: hdfs://ns2/tmp/escape_column_comments Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles 0 numPartitions 0 numRows 0 rawDataSize 0 totalSize 0 transient_lastDdlTime 1520421381 # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 Cli patch # col_name data_type comment col1 string test\tcol1 col2 string col2 col3 string # Partition Information # col_name data_type comment part1 string test\tpart1 # Detailed Table Information Database: default Owner: hive3 CreateTime: Wed Mar 07 19:16:21 CST 2018 LastAccessTime: UNKNOWN Retention: 0 Location: hdfs://ns2/tmp/escape_column_comments Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles 0 numPartitions 0 numRows 0 rawDataSize 0 totalSize 0 transient_lastDdlTime 1520421381 # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1