[HIVE-4659] while sql contains \t ， 'desc formatted view_name' and 'show create table view_name' statements will generate Incomplete results

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: Query Processor
• Assignee: caofangkun
• Reporter: caofangkun
• Created: 05/Jun/13 03:38
• Updated: 05/Jun/13 12:04

Description

drop view if exists v_test;
CREATE VIEW v_test AS select
key, – start by \t\t
value, – start by \t\t
dt from – start by \t\t
(
select key, value, dt from tmp_v_t1 where dt='20130122'
union all
select key,value, dt from tmp_v_t1 where dt='20130123'
) t;

$ hive -e "show create table v_test"

UT-One the three lines which started by \t lost in create statment !
Logging initialized using configuration in file:/home/zongren/hive-conf/hive-log4j.properties
Hive history file=/tmp/zongren/hive_job_log_zongren_24155@hd17-vm5_201306051125_94165790.txt
OK
CREATE VIEW v_test AS select

(
select `tmp_v_t1`.`key`, `tmp_v_t1`.`value`, `tmp_v_t1`.`dt` from `default`.`tmp_v_t1` where `tmp_v_t1`.`dt`='20130122'
union all
select `tmp_v_t1`.`key`,`tmp_v_t1`.`value`, `tmp_v_t1`.`dt` from `default`.`tmp_v_t1` where `tmp_v_t1`.`dt`='20130123'
) `t`
Time taken: 2.767 seconds, Fetched: 9 row(s)

UT-Two:

Issue Links

• is related to: HIVE-967 Implement "show create table"