You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Eric Hwang (JIRA)" <ji...@apache.org> on 2009/08/06 03:15:14 UTC
[jira] Commented: (HIVE-671) getSchema() does not work properly
with select* queries on Hive Server
[ https://issues.apache.org/jira/browse/HIVE-671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739856#action_12739856 ]
Eric Hwang commented on HIVE-671:
---------------------------------
With regards to the select * on partitioned tables, I sometimes get this error:
FAILED: Error in semantic analysis: line 0:-1 No Partition Predicate Found TOK_ALLCOLREF: for Alias <partitioned_table> Table <partitioned_table>
09/08/05 18:11:42 ERROR ql.Driver: FAILED: Error in semantic analysis: line 0:-1 No Partition Predicate Found TOK_ALLCOLREF: for Alias <partitioned_table> Table <partitioned_table>
org.apache.hadoop.hive.ql.parse.SemanticException: line 0:-1 No Partition Predicate Found TOK_ALLCOLREF: for Alias <partitioned_table> Table <partitioned_table>
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPartitionPruners(SemanticAnalyzer.java:661)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:4219)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:76)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:249)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:281)
at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:108)
at org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:340)
at org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:328)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
> getSchema() does not work properly with select* queries on Hive Server
> ----------------------------------------------------------------------
>
> Key: HIVE-671
> URL: https://issues.apache.org/jira/browse/HIVE-671
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: Eric Hwang
>
> Running a select * query sometimes causes Null Pointer Exceptions in the Hive Server getSchema() method:
> This is the Hive Server Error:
> java.lang.NullPointerException
> at com.facebook.serde2.hive_context.contextSerDe.initialize(contextSerDe.java:35)
> at org.apache.hadoop.hive.ql.plan.tableDesc.getDeserializer(tableDesc.java:64)
> at org.apache.hadoop.hive.ql.Driver.getSchema(Driver.java:119)
> at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.getSchema(HiveServer.java:124)
> at org.apache.hadoop.hive.service.ThriftHive$Processor$getSchema.process(ThriftHive.java:376)
> at org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:252)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
> at java.lang.Thread.run(Thread.java:619)
> 09/07/21 22:58:53 ERROR service.HiveServer: java.lang.NullPointerException java.lang.NullPointerException
> at com.facebook.serde2.hive_context.contextSerDe.initialize(contextSerDe.java:35)
> at org.apache.hadoop.hive.ql.plan.tableDesc.getDeserializer(tableDesc.java:64)
> at org.apache.hadoop.hive.ql.Driver.getSchema(Driver.java:119)
> at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.getSchema(HiveServer.java:124)
> at org.apache.hadoop.hive.service.ThriftHive$Processor$getSchema.process(ThriftHive.java:376)
> at org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:252)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
> at java.lang.Thread.run(Thread.java:619)
> Also, select * queries sometimes cause the Hive Server getSchema() to omit the field used to partition the table.
> This directly impacts the Hive ODBC driver (JIRA-187) and other sections that exercise the Hive Server.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.