You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org> on 2011/12/15 00:23:32 UTC

[jira] [Commented] (HIVE-727) Hive Server getSchema() returns wrong schema for "Explain" queries

    [ https://issues.apache.org/jira/browse/HIVE-727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13169796#comment-13169796 ] 

jiraposter@reviews.apache.org commented on HIVE-727:
----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/2517/
-----------------------------------------------------------

(Updated 2011-12-14 23:21:30.477384)


Review request for hive and Carl Steinbach.


Changes
-------

Rebased the patch and reran the TestJdbcDriver test.


Summary
-------

Added a method to get result schema from a Task. The ExplainSemanticAnalyzer invokes this to get the schema for explain statement which is a single string column.


This addresses bug Hive-727.
    https://issues.apache.org/jira/browse/Hive-727


Diffs (updated)
-----

  jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java 4972754 
  ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java 7e5f645 
  ql/src/java/org/apache/hadoop/hive/ql/exec/Task.java a4e59ca 
  ql/src/java/org/apache/hadoop/hive/ql/parse/ExplainSemanticAnalyzer.java 9dc6f87 

Diff: https://reviews.apache.org/r/2517/diff


Testing
-------

Added  a new test case in TestJdbcDriver to run  explain statement and verify resultset metadata 


Thanks,

Prasad


                
> Hive Server getSchema() returns wrong schema for "Explain" queries
> ------------------------------------------------------------------
>
>                 Key: HIVE-727
>                 URL: https://issues.apache.org/jira/browse/HIVE-727
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Eric Hwang
>            Assignee: Prasad Mujumdar
>         Attachments: Hive-727.patch
>
>
> The Hive Server's getSchema() function will return a schema with zero fields when executing an "Explain..." query. A quick fix might be to set the default schema to be exactly one column of type string.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira