Re: hive2.1.0 one partition has two locations

Hi Elliot： I raised a new issue :https://issues.apache.org/jira/browse/HIVE-15512 在 2016年12月22日，下午5:05，Elliot West > 写道： rais

hive2.1.0 one partition has two locations

Hi all: HQL： Alter table OperatingStat_R_View Add IF NOT EXISTS partition(YEAR=2016,MONTH=12,DAY=04) LOCATION '/data/ApplicationDep/TCRecSys_ApplyData/OperatingStat/Report/View/2016/12/04'; INSERT OVERWRITE TABLE TCRecSys_ApplyData.OperatingStat_R_View PARTITION (YEAR=2016,MONTH=12,DAY=04)

hive 2.1.0 Comparison of timestamp fails if empty string is provided.

Dear all: version :2.1.0 (fixed issue:HIVE-15291) query:select cast("2016-12-31 12:00:00" as timestamp) <> ‘' expected result:true actual result:NULL

Re: hive union all

could you please explain the sql 在 2016年11月24日，下午1:01，C R > 写道： hi all, all I want to say is here: it is ok. I feel a little embarrassed According to my test,the same hive ql will be executed well in CDH version.