caofangkun created HIVE-4659:
--------------------------------
Summary: while sql contains \t ， 'desc formatted view_name' and
'show create table view_name' statements will generate Incomplete results
Key: HIVE-4659
URL: https://issues.apache.org/jira/browse/HIVE-4659
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.12.0
Reporter: caofangkun
Assignee: caofangkun
Priority: Minor
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:
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
