Grokbase Groups Hive dev May 2014
FAQ
Deepesh Khandelwal created HIVE-7118:
----------------------------------------

              Summary: Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables
                  Key: HIVE-7118
                  URL: https://issues.apache.org/jira/browse/HIVE-7118
              Project: Hive
           Issue Type: Bug
           Components: Database/Schema
     Affects Versions: 0.14.0
          Environment: Oracle DB
             Reporter: Deepesh Khandelwal
             Assignee: Deepesh Khandelwal


In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
{noformat}
ORA-01438: value larger than specified precision allowed for this column
{noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Search Discussions

  • Deepesh Khandelwal (JIRA) at May 23, 2014 at 4:00 am
    [ https://issues.apache.org/jira/browse/HIVE-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Deepesh Khandelwal updated HIVE-7118:
    -------------------------------------

         Description:
    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}
    NO PRECOMMIT TESTS

       was:
    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}

    Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables
    ------------------------------------------------------------------------------------------------------------

    Key: HIVE-7118
    URL: https://issues.apache.org/jira/browse/HIVE-7118
    Project: Hive
    Issue Type: Bug
    Components: Database/Schema
    Affects Versions: 0.14.0
    Environment: Oracle DB
    Reporter: Deepesh Khandelwal
    Assignee: Deepesh Khandelwal
    Attachments: HIVE-7118.1.patch


    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}
    NO PRECOMMIT TESTS


    --
    This message was sent by Atlassian JIRA
    (v6.2#6252)
  • Deepesh Khandelwal (JIRA) at May 23, 2014 at 4:00 am
    [ https://issues.apache.org/jira/browse/HIVE-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Deepesh Khandelwal updated HIVE-7118:
    -------------------------------------

         Attachment: HIVE-7118.1.patch

    Attaching a patch that changes NUMBER(10) to NUMBER(19) datatype for long columns for Oracle metastore schema upgrade scripts.
    Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables
    ------------------------------------------------------------------------------------------------------------

    Key: HIVE-7118
    URL: https://issues.apache.org/jira/browse/HIVE-7118
    Project: Hive
    Issue Type: Bug
    Components: Database/Schema
    Affects Versions: 0.14.0
    Environment: Oracle DB
    Reporter: Deepesh Khandelwal
    Assignee: Deepesh Khandelwal
    Attachments: HIVE-7118.1.patch


    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}


    --
    This message was sent by Atlassian JIRA
    (v6.2#6252)
  • Deepesh Khandelwal (JIRA) at May 23, 2014 at 4:02 am
    [ https://issues.apache.org/jira/browse/HIVE-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Deepesh Khandelwal updated HIVE-7118:
    -------------------------------------

         Fix Version/s: 0.14.0
                Status: Patch Available (was: Open)
    Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables
    ------------------------------------------------------------------------------------------------------------

    Key: HIVE-7118
    URL: https://issues.apache.org/jira/browse/HIVE-7118
    Project: Hive
    Issue Type: Bug
    Components: Database/Schema
    Affects Versions: 0.14.0
    Environment: Oracle DB
    Reporter: Deepesh Khandelwal
    Assignee: Deepesh Khandelwal
    Fix For: 0.14.0

    Attachments: HIVE-7118.1.patch


    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}
    NO PRECOMMIT TESTS


    --
    This message was sent by Atlassian JIRA
    (v6.2#6252)
  • Alan Gates (JIRA) at May 23, 2014 at 5:13 pm
    [ https://issues.apache.org/jira/browse/HIVE-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Alan Gates updated HIVE-7118:
    -----------------------------

         Status: Open (was: Patch Available)

    We haven't built install scripts for 14 yet as Ashutosh and I were discussing if there was a better method than creating the tables directly in the scripts. So we can't apply this patch until we make a decision on that.
    Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables
    ------------------------------------------------------------------------------------------------------------

    Key: HIVE-7118
    URL: https://issues.apache.org/jira/browse/HIVE-7118
    Project: Hive
    Issue Type: Bug
    Components: Database/Schema
    Affects Versions: 0.14.0
    Environment: Oracle DB
    Reporter: Deepesh Khandelwal
    Assignee: Deepesh Khandelwal
    Fix For: 0.14.0

    Attachments: HIVE-7118.1.patch


    In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:
    {noformat}
    ORA-01438: value larger than specified precision allowed for this column
    {noformat}
    NO PRECOMMIT TESTS


    --
    This message was sent by Atlassian JIRA
    (v6.2#6252)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categorieshive, hadoop
postedMay 23, '14 at 2:37a
activeMay 23, '14 at 5:13p
posts5
users1
websitehive.apache.org

1 user in discussion

Alan Gates (JIRA): 5 posts

People

Translate

site design / logo © 2021 Grokbase