hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6559) sourcing txn-script from schema script results in failure for mysql & oracle
Date Sun, 09 Mar 2014 02:20:43 GMT

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

Ashutosh Chauhan commented on HIVE-6559:
----------------------------------------

Although, HIVE-6583 will help one get past problem I pasted above, that doesn't help completely.
New requirement because of sourcing another script leads one into a situation that you need
to be in same dir to perform this sourcing correctly. Otherwise, you will get 
{code}
ERROR: 
Failed to open file 'hive-txn-schema-0.13.0.mysql.sql', error: 2
{code}
This is inconvenience for user, but real problems is for tools because they now need to cd
into correct dir to invoke this script.
I believe we should not source another script, but inline all sql statements in existing script.

> sourcing txn-script from schema script results in failure for mysql & oracle
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-6559
>                 URL: https://issues.apache.org/jira/browse/HIVE-6559
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.13.0
>            Reporter: Ashutosh Chauhan
>            Assignee: Alan Gates
>             Fix For: 0.13.0
>
>
> On mysql, I got:
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '----------------------------
> ----------------------------
> SOURCE hive-txn-schem' at line 1
> On Oracle, I got:
> SP2-0310: unable to open file "hive-txn-schema-0.13.0.oracle.sql" 



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

Mime
View raw message