hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Santlal J Gupta <>
Subject Not able to use IN clause in multiple partition
Date Thu, 01 Sep 2016 11:54:24 GMT

I am trying to use multiple partition column in IN clause using struct. I am getting StandardStructObjectInspector

I have tried below query.

hive> create table partm(f1 int, f2 int) partitioned by (f3 int , f4 int) row format delimited
fields terminated by ','  stored as textfile location '/user/ojasd/warehouse/partm';
hive> insert into table partm partition (f3=2, f4=4) values(1,2);
hive> insert into table partm partition (f3=1, f4=3) values(2,4);
hive> insert into table partm partition (f3=6, f4=7) values(8,9);

hive> select * from partm;
partm.f1        partm.f2        partm.f3        partm.f4
2                                 4                    1                        3
1                                 2                    2                        4
8                                9                    6                          7

hive> select  * from partm where f3=1 and f4=3;
partm.f1  partm.f2  partm.f3  partm.f4
2                         4               1                   3

hive> select  * from partm where struct(f3,f4) IN (struct(1,3),struct(2,4));
FAILED: ClassCastException org.apache.hadoop.hive.serde2.objectinspector.StandardStructObjectInspector
cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.PrimitiveObjectInspector

Can you point out is there anything wrong in this query.
I am using  Hive 1.1.0-cdh5.5.4 version

Santlal J Gupta
This e-mail message and any attachments may contain confidential information and is for the
sole use of the intended recipient(s) only. Any views or opinions presented or implied are
solely those of the author and do not necessarily represent the views of BitWise. If you are
not the intended recipient(s), you are hereby notified that disclosure, printing, copying,
forwarding, distribution, or the taking of any action whatsoever in reliance on the contents
of this electronic information is strictly prohibited. If you have received this e-mail message
in error, please immediately notify the sender and delete the electronic message and any attachments.BitWise
does not accept liability for any virus introduced by this e-mail or any attachments. ********************************************************************************************

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message