[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13806888#comment-13806888 ] Ashutosh Chauhan commented on HIVE-5648: +1 error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13807273#comment-13807273 ] Hudson commented on HIVE-5648: -- ABORTED: Integrated in Hive-trunk-hadoop2 #526 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/526/]) HIVE-5648 : error when casting partition column to varchar in where clause (Jason Dere via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1536471) * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeConstantDesc.java * /hive/trunk/ql/src/test/queries/clientpositive/partition_varchar2.q * /hive/trunk/ql/src/test/results/clientpositive/partition_varchar2.q.out * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorFactory.java * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoFactory.java * /hive/trunk/serde/src/test/org/apache/hadoop/hive/serde2/objectinspector/primitive/TestPrimitiveObjectInspectorFactory.java error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Fix For: 0.13.0 Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13807407#comment-13807407 ] Hudson commented on HIVE-5648: -- SUCCESS: Integrated in Hive-trunk-hadoop1-ptest #217 (See [https://builds.apache.org/job/Hive-trunk-hadoop1-ptest/217/]) HIVE-5648 : error when casting partition column to varchar in where clause (Jason Dere via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1536471) * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeConstantDesc.java * /hive/trunk/ql/src/test/queries/clientpositive/partition_varchar2.q * /hive/trunk/ql/src/test/results/clientpositive/partition_varchar2.q.out * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorFactory.java * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoFactory.java * /hive/trunk/serde/src/test/org/apache/hadoop/hive/serde2/objectinspector/primitive/TestPrimitiveObjectInspectorFactory.java error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Fix For: 0.13.0 Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13807434#comment-13807434 ] Hudson commented on HIVE-5648: -- ABORTED: Integrated in Hive-trunk-h0.21 #2427 (See [https://builds.apache.org/job/Hive-trunk-h0.21/2427/]) HIVE-5648 : error when casting partition column to varchar in where clause (Jason Dere via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1536471) * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeConstantDesc.java * /hive/trunk/ql/src/test/queries/clientpositive/partition_varchar2.q * /hive/trunk/ql/src/test/results/clientpositive/partition_varchar2.q.out * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorFactory.java * /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoFactory.java * /hive/trunk/serde/src/test/org/apache/hadoop/hive/serde2/objectinspector/primitive/TestPrimitiveObjectInspectorFactory.java error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Fix For: 0.13.0 Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[
https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13806050#comment-13806050
]
Hive QA commented on HIVE-5648:
---
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12610292/HIVE-5648.2.patch
{color:green}SUCCESS:{color} +1 4486 tests passed
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1244/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1244/console
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
error when casting partition column to varchar in where clause
---
Key: HIVE-5648
URL: https://issues.apache.org/jira/browse/HIVE-5648
Project: Hive
Issue Type: Bug
Reporter: Jason Dere
Assignee: Jason Dere
Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch
hive select * from partition_varchar_2 where cast(dt as varchar(10)) =
'2000-01-01';
FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for
VARCHAR
--
This message was sent by Atlassian JIRA
(v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13805080#comment-13805080 ] Jason Dere commented on HIVE-5648: -- ExprNodeConstantDesc should be changed here, for qualified types (varchar, and soon decimal with Xuefu's changes), we should be passing along the type qualifiers whenever possible, and this requires the PrimitiveTypeInfo. PrimitiveCategory, being just an enum, wouldn't provide be able to provide varchar length or precision/scale. We could change getPrimitiveJavaObjectInspector(PrimitiveCategory) to return a default varchar object inspector for PrimitiveCategory.VARCHAR. I'll add that to the patch. error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Attachments: HIVE-5648.1.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13805163#comment-13805163 ] Jason Dere commented on HIVE-5648: -- However, returning the default OI for qualified types is not desirable and should be avoided whenever possible, thus fix in the v1 patch is still included. error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Attachments: HIVE-5648.1.patch, HIVE-5648.2.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13804932#comment-13804932 ] Jason Dere commented on HIVE-5648: -- Looks like ExprNodeConstantDesc.getWritableObjectInspector() should have been using the TypeInfo to get the object inspector, rather than using PrimitiveCategory. 2013-10-24 18:38:37,527 ERROR ql.Driver (SessionState.java:printError(435)) - FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR at org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:86) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:492) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:351) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1004) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:915) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:422) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:790) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:623) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:212) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR at org.apache.hadoop.hive.ql.exec.FilterOperator.initializeOp(FilterOperator.java:81) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:377) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:453) at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:409) at org.apache.hadoop.hive.ql.exec.TableScanOperator.initializeOp(TableScanOperator.java:188) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:377) at org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:80) ... 15 more Caused by: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR at org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorFactory.getPrimitiveJavaObjectInspector(PrimitiveObjectInspectorFactory.java:310) at org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc.getWritableObjectInspector(ExprNodeConstantDesc.java:65) at org.apache.hadoop.hive.ql.exec.ExprNodeConstantEvaluator.init(ExprNodeConstantEvaluator.java:36) at org.apache.hadoop.hive.ql.exec.ExprNodeEvaluatorFactory.get(ExprNodeEvaluatorFactory.java:44) at org.apache.hadoop.hive.ql.exec.ExprNodeGenericFuncEvaluator.init(ExprNodeGenericFuncEvaluator.java:90) at org.apache.hadoop.hive.ql.exec.ExprNodeEvaluatorFactory.get(ExprNodeEvaluatorFactory.java:52) at org.apache.hadoop.hive.ql.exec.FilterOperator.initializeOp(FilterOperator.java:71) ... 21 more error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5648) error when casting partition column to varchar in where clause
[ https://issues.apache.org/jira/browse/HIVE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13804945#comment-13804945 ] Navis commented on HIVE-5648: - I think getPrimitiveJavaObjectInspector(PrimitiveCategory) should return proper ObjectInspector like getPrimitiveJavaObjectInspector(PrimitiveTypeInfo) rather than changing ExprNodeConstantDesc. error when casting partition column to varchar in where clause --- Key: HIVE-5648 URL: https://issues.apache.org/jira/browse/HIVE-5648 Project: Hive Issue Type: Bug Reporter: Jason Dere Assignee: Jason Dere Attachments: HIVE-5648.1.patch hive select * from partition_varchar_2 where cast(dt as varchar(10)) = '2000-01-01'; FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VARCHAR -- This message was sent by Atlassian JIRA (v6.1#6144)
