[
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)
