[
https://issues.apache.org/jira/browse/SQOOP-2056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14297349#comment-14297349
]
Karthic Hariharan edited comment on SQOOP-2056 at 1/29/15 7:05 PM:
-------------------------------------------------------------------
No it does not. It still doesnt work for some things that are Hsqldb specific
like incremental load using lastModified timestamp. The problem is there isn't
a separate MysqlDbJobStorage which is specifically using mysql drivers.
I can definitely go into greater depth on these incompatibilities if you need
me to.
was (Author: khariharan):
No it does not. It still doesnt work for some things that are Hsqldb specific
like incremental load using lastModified timestamp. The problem is there isn't
a separate MysqlDbJobStorage which is specifically using mysql drivers.
> Support for Mysql Sqoop Metastore
> ---------------------------------
>
> Key: SQOOP-2056
> URL: https://issues.apache.org/jira/browse/SQOOP-2056
> Project: Sqoop
> Issue Type: New Feature
> Reporter: Karthic Hariharan
>
> We would love to see sqoop metastore supported for Mysql.
> At the moment sqoop metastore can be set up only with HSQLdb. Even though you
> can fake a mysql database to look like a HSQLdb (refer
> http://bit.ly/1tz2J5u), it does not translate to compatibility to all of
> sqoop's features.
> Some of the incompatibilities are:
> * Metastore client assumes all connections to the metastore is in
> serializable transaction isolation so when sqoop job is executed it never
> really finishes because it's trying to run a transaction within a transaction.
> * Incremental loads using last modified timestamp doesnt work because the
> sqoop job tries to get the current time on the database which is a different
> sql command for Hsqldb and mysql.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
