-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/11652/
-----------------------------------------------------------

Review request for hive.


Description
-------

https://issues.apache.org/jira/browse/HIVE-4659


This addresses bug HIVE-4659.
    https://issues.apache.org/jira/browse/HIVE-4659


Diffs
-----

  
http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
 1489269 
  
http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
 1489269 

Diff: https://reviews.apache.org/r/11652/diff/


Testing
-------

$ hive -e "show create table  v_test_1"
CREATE VIEW v_test_1 AS select 
      key,
    value, 
    dt from 
(
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`, split(`tmp_v_t1`.`value`,'\\\t')[0] as `value`, 
`tmp_v_t1`.`dt` from `default`.`tmp_v_t1` where `tmp_v_t1`.`dt`='20130123'
) `t` ;


Screenshots
-----------

Example View 
  https://reviews.apache.org/r/11652/s/27/


Thanks,

fangkun cao

Reply via email to