You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Dan Fan <df...@appnexus.com> on 2014/09/23 00:28:36 UTC
Unxpected exception: Unxpected exception:
org.apache.hadoop.io.LongWritable cannot be cast to java.lang.Long
Dear hive users:
Quick question about hive longwritable convert to long.
I have a generic udf called protected_column, which works well as following:
Select protect_column(auction_id_64, ‘auction_id_64’, vp_bitmap) from table ;
And works well when I run
Select * from ( select protect_column(auction_id_64, ‘auction_id_64', vp_bitmap) from tableA union all select protect_column(auction_id_64, ‘auction_id_64', vp_bitmap) from tableB) tmp ;
However, the generic udf would fail if I use it in the join.
SELECT *
FROM (SELECT Protect_column(auction_id_64, 'auction_id_64', vp_bitmap)
FROM view_agg_dw_impressions_tmp t
LEFT OUTER JOIN table_A pub
ON ( pub.id = t.publisher_id )
LEFT OUTER JOIN table_B inv
ON ( inv.id = t.inventory_source_id )
WHERE t.buyer_member_id = 1541
AND dh = '2014-09-19 12') feed;
... 8 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unxpected exception: Unxpected exception: org.apache.hadoop.io.LongWritable cannot be cast to java.lang.Long
at org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:234)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:87)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
at org.apache.hadoop.hive.ql.exec.FilterOperator.processOp(FilterOperator.java:136)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:91)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:519)
It fails if I run the following too.
SELECT Protect_column(auction_id_64, 'auction_id_64', vp_bitmap)
FROM (SELECT auction_id_64, vp_bitmap
FROM view_agg_dw_impressions_tmp t
LEFT OUTER JOIN table_A pub
ON ( pub.id = t.publisher_id )
LEFT OUTER JOIN table_B inv
ON ( inv.id = t.inventory_source_id )
WHERE t.buyer_member_id = 1541
AND dh = '2014-09-19 12') feed;
Any one can help explaining why hive wanna convert longwritable to long and why the udf works fine on select query and union all query but not join queries ?
Thanks
Dan
Re: Unxpected exception: Unxpected exception: org.apache.hadoop.io.LongWritable cannot be cast to java.lang.Long
Posted by Jason Dere <jd...@hortonworks.com>.
What does your GenericUDF look like?
What version of Hive? Does the query work without the UDF?
On Sep 22, 2014, at 3:28 PM, Dan Fan <df...@appnexus.com> wrote:
> Dear hive users:
>
> Quick question about hive longwritable convert to long.
> I have a generic udf called protected_column, which works well as following:
>
> Select protect_column(auction_id_64, ‘auction_id_64’, vp_bitmap) from table ;
> And works well when I run
> Select * from ( select protect_column(auction_id_64, ‘auction_id_64', vp_bitmap) from tableA union all select protect_column(auction_id_64, ‘auction_id_64', vp_bitmap) from tableB) tmp ;
>
> However, the generic udf would fail if I use it in the join.
>
>
>
> SELECT *
> FROM (SELECT Protect_column(auction_id_64, 'auction_id_64', vp_bitmap)
> FROM view_agg_dw_impressions_tmp t
> LEFT OUTER JOIN table_A pub
> ON ( pub.id = t.publisher_id )
> LEFT OUTER JOIN table_B inv
> ON ( inv.id = t.inventory_source_id )
> WHERE t.buyer_member_id = 1541
> AND dh = '2014-09-19 12') feed;
>
>
> ... 8 more
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unxpected exception: Unxpected exception: org.apache.hadoop.io.LongWritable cannot be cast to java.lang.Long
> at org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:234)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
> at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:87)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
> at org.apache.hadoop.hive.ql.exec.FilterOperator.processOp(FilterOperator.java:136)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
> at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:91)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:504)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:847)
> at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:519)
>
> It fails if I run the following too.
>
>
> SELECT Protect_column(auction_id_64, 'auction_id_64', vp_bitmap)
> FROM (SELECT auction_id_64, vp_bitmap
> FROM view_agg_dw_impressions_tmp t
> LEFT OUTER JOIN table_A pub
> ON ( pub.id = t.publisher_id )
> LEFT OUTER JOIN table_B inv
> ON ( inv.id = t.inventory_source_id )
> WHERE t.buyer_member_id = 1541
> AND dh = '2014-09-19 12') feed;
>
> Any one can help explaining why hive wanna convert longwritable to long and why the udf works fine on select query and union all query but not join queries ?
>
> Thanks
>
> Dan
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.