Grokbase Groups Hive dev October 2013
FAQ
Prasad Mujumdar created HIVE-5449:
-------------------------------------

              Summary: Hive schematool info option incorrectly reports error for Postgres metastore
                  Key: HIVE-5449
                  URL: https://issues.apache.org/jira/browse/HIVE-5449
              Project: Hive
           Issue Type: Bug
           Components: Metastore
     Affects Versions: 0.12.0, 0.13.0
             Reporter: Prasad Mujumdar
             Assignee: Prasad Mujumdar


The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).




--
This message was sent by Atlassian JIRA
(v6.1#6144)

Search Discussions

  • Prasad Mujumdar (JIRA) at Oct 4, 2013 at 10:52 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Prasad Mujumdar updated HIVE-5449:
    ----------------------------------

         Attachment: HIVE-5449.1.patch

    Patch attached
    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Prasad Mujumdar (JIRA) at Oct 4, 2013 at 10:52 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Prasad Mujumdar updated HIVE-5449:
    ----------------------------------

         Status: Patch Available (was: Open)

    Review request on https://reviews.apache.org/r/14500/
    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Prasad Mujumdar (JIRA) at Oct 4, 2013 at 10:54 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13786717#comment-13786717 ]

    Prasad Mujumdar commented on HIVE-5449:
    ---------------------------------------

    * Without the patch
    {noformat}
    $ build/dist/bin/schematool -dbType postgres -info
    Metastore connection URL: jdbc:postgresql://localhost/metastore
    Metastore Connection Driver : org.postgresql.Driver
    Metastore connection User: hive
    Hive distribution version: 0.13.0
    org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
    *** schemaTool failed ***
    {noformat}

    * With the patch
    {noformat}
    ]$ build/dist/bin/schematool -dbType postgres -info
    Metastore connection URL: jdbc:postgresql://localhost/metastore
    Metastore Connection Driver : org.postgresql.Driver
    Metastore connection User: hive
    Hive distribution version: 0.13.0
    Metastore schema version: 0.13.0
    schemaTool completeted
    {noformat}
    ~

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Ashutosh Chauhan (JIRA) at Oct 4, 2013 at 11:10 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13786730#comment-13786730 ]

    Ashutosh Chauhan commented on HIVE-5449:
    ----------------------------------------

    +1
    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hive QA (JIRA) at Oct 5, 2013 at 11:11 am
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787178#comment-13787178 ]

    Hive QA commented on HIVE-5449:
    -------------------------------



    {color:green}Overall{color}: +1 all checks pass

    Here are the results of testing the latest attachment:
    https://issues.apache.org/jira/secure/attachment/12606920/HIVE-5449.1.patch

    {color:green}SUCCESS:{color} +1 4052 tests passed

    Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1043/testReport
    Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1043/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.
    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Ashutosh Chauhan (JIRA) at Oct 5, 2013 at 4:26 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Ashutosh Chauhan updated HIVE-5449:
    -----------------------------------

            Resolution: Fixed
         Fix Version/s: 0.13.0
                Status: Resolved (was: Patch Available)

    Committed to trunk. Thanks, Prasad!
    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 5, 2013 at 4:49 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787263#comment-13787263 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    FAILURE: Integrated in Hive-trunk-hadoop2 #482 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/482/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1529476)
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 5, 2013 at 8:44 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787326#comment-13787326 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    FAILURE: Integrated in Hive-trunk-hadoop2-ptest #125 (See [https://builds.apache.org/job/Hive-trunk-hadoop2-ptest/125/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1529476)
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 5, 2013 at 9:34 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787351#comment-13787351 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    FAILURE: Integrated in Hive-trunk-hadoop1-ptest #191 (See [https://builds.apache.org/job/Hive-trunk-hadoop1-ptest/191/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1529476)
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 6, 2013 at 3:36 am
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787469#comment-13787469 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    FAILURE: Integrated in Hive-trunk-h0.21 #2382 (See [https://builds.apache.org/job/Hive-trunk-h0.21/2382/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1529476)
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/trunk/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 9, 2013 at 9:54 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13790892#comment-13790892 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    FAILURE: Integrated in Hive-branch-0.12-hadoop1 #20 (See [https://builds.apache.org/job/Hive-branch-0.12-hadoop1/20/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Thejas Nair) (thejas: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1530466)
    * /hive/branches/branch-0.12/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/branches/branch-0.12/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)
  • Hudson (JIRA) at Oct 10, 2013 at 12:10 pm
    [ https://issues.apache.org/jira/browse/HIVE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13791420#comment-13791420 ]

    Hudson commented on HIVE-5449:
    ------------------------------

    ABORTED: Integrated in Hive-branch-0.12-hadoop2 #13 (See [https://builds.apache.org/job/Hive-branch-0.12-hadoop2/13/])
    HIVE-5449 : Hive schematool info option incorrectly reports error for Postgres metastore (Prasad Mujumdar via Thejas Nair) (thejas: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1530466)
    * /hive/branches/branch-0.12/beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
    * /hive/branches/branch-0.12/beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java

    Hive schematool info option incorrectly reports error for Postgres metastore
    ----------------------------------------------------------------------------

    Key: HIVE-5449
    URL: https://issues.apache.org/jira/browse/HIVE-5449
    Project: Hive
    Issue Type: Bug
    Components: Metastore
    Affects Versions: 0.12.0, 0.13.0
    Reporter: Prasad Mujumdar
    Assignee: Prasad Mujumdar
    Fix For: 0.13.0

    Attachments: HIVE-5449.1.patch


    The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).


    --
    This message was sent by Atlassian JIRA
    (v6.1#6144)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categorieshive, hadoop
postedOct 4, '13 at 10:34p
activeOct 10, '13 at 12:10p
posts13
users1
websitehive.apache.org

1 user in discussion

Hudson (JIRA): 13 posts

People

Translate

site design / logo © 2022 Grokbase