hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4659) while sql contains \t , 'desc formatted view_name' and 'show create table view_name' statements will generate Incomplete results
Date Wed, 05 Jun 2013 12:05:20 GMT

     [ 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

Mime
View raw message