转发: clause "in" issue

[Alan <al...@outlook.com>]

 

 

发件人: 徐鹏 [mailto:xp19901010@outlook.com] 
发送时间: 2015年8月22日 20:15
收件人: alan_hadoop@outlook.com
主题: FW: clause "in" issue

 

 

  _____  

From: xp19901010@outlook.com <ma...@outlook.com> 
To: user@hive.apache.org <ma...@hive.apache.org> 
Subject: clause "in" issue
Date: Fri, 21 Aug 2015 09:36:51 +0000

Dear all:
I found a weird problem when using clause 'in' .

  



 

 

 

The digits in the brackets after 'in' clause is the day of the month.
it seems that single digits in the 'in' clause would not successfully get
the result. However the two digits number would get the right result.
Would it be a bug or some misunderstanding here?

The environment is showed below:


Hive version


0.13.1


Table structure


  



 

 


Table partition


  



 

 


Every partition has data