[
https://issues.apache.org/jira/browse/HIVE-4659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
caofangkun updated HIVE-4659:
-----------------------------
Attachment: HIVE-4659-1.patch
https://reviews.apache.org/r/11652/
> 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
> Attachments: HIVE-4659-1.patch
>
>
> 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
