http://www.datastax.com/support-forums/topic/strange-error-with-hive-queries Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 08:52:37 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/strange-error-with-hive-queries#post-7496 Wed, 14 Nov 2012 10:36:04 +0000 pierantonio.merlino 7496@http://www.datastax.com/support-forums/ <p>Thank you for the answer.<br /> I tried with <code>SELECT * FROM MyTable WHERE col1.a = cast(&quot;XXX&quot; as binary);</code> but the result is:</p> <pre><code>FAILED: Hive Internal Error: java.lang.RuntimeException(Internal error: Cannot find ConstantObjectInspector for BINARY) java.lang.RuntimeException: Internal error: Cannot find ConstantObjectInspector for BINARY at org.apache.hadoop.hive.serde2.objectinspector.primitive. PrimitiveObjectInspectorFactory.getPrimitiveWritableConstantObjectInspector (PrimitiveObjectInspectorFactory.java:196)</code></pre> http://www.datastax.com/support-forums/topic/strange-error-with-hive-queries#post-7494 Wed, 14 Nov 2012 09:49:45 +0000 sam 7494@http://www.datastax.com/support-forums/ <p>when I've come across that error its been because the Hive query parser can't determine the Hive type of the operand in the comparision. So, for in this case it can't infer that XXX needs to be of type binary even though col1.a is binary. Does casting the value to Binary help at all? </p> http://www.datastax.com/support-forums/topic/strange-error-with-hive-queries#post-7469 Mon, 12 Nov 2012 14:20:41 +0000 pierantonio.merlino 7469@http://www.datastax.com/support-forums/ <p>Hi,<br /> I wrote a custom serde for Hive in order to manage the column composite types in my application.<br /> Some fields in the composite are binary types.</p> <p>All works, but when I perform queries with a WHERE clause like <code>SELECT * FROM MyTable WHERE col1.a = XXX;</code> where <code>col1.a</code> is a binary field, I get the following error:</p> <pre><code>2012-11-12 15:14:38,008 FATAL ExecMapper: org.apache.hadoop.hive.ql.metadata. HiveException: Hive Runtime Error while processing row {... ... Caused by: java.lang.RuntimeException: Hive 2 Internal error: unknown type: binary at org.apache.hadoop.hive.serde2.objectinspector.primitive. PrimitiveObjectInspectorUtils.getDouble(PrimitiveObjectInspectorUtils.java:651) at org.apache.hadoop.hive.serde2.objectinspector.primitive. PrimitiveObjectInspectorConverter$DoubleConverter.convert (PrimitiveObjectInspectorConverter.java:232) at org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPEqual.evaluate (GenericUDFOPEqual.java:73) at org.apache.hadoop.hive.ql.exec.ExprNodeGenericFuncEvaluator.evaluate (ExprNodeGenericFuncEvaluator.java:163) at org.apache.hadoop.hive.ql.exec.FilterOperator.processOp (FilterOperator.java:118) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:471) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:762) at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp (TableScanOperator.java:83) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:471) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:762) at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:531) ... 9 more</code></pre> <p>The method <code>org.apache.hadoop.hive.serde2.objectinspector.primitive.</code><br /> <code>PrimitiveObjectInspectorUtils.getDouble</code> indeed does not support binary types, but I don't understand how to solve the problem.</p> <p>Can someone help me?<br /> Thank you in advance </p>