[jira] [Commented] (SQOOP-1278) Allow use of uncommitted isolation for databases that support it as an import option

["Ryan Wieber (JIRA)" <ji...@apache.org>]

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

Ryan Wieber commented on SQOOP-1278:
------------------------------------

I'm also still getting the "SQLite supports only TRANSACTION_SERIALIZABLE and TRANSACTION_READ_UNCOMMITTED" error even with --relaxed-isolation.

sqoop 1.4.5

Command line:
sqoop import-all-tables --connect jdbc:sqlite:/tmp/PRIVATE.db --m 1 --warehouse-dir /data/PRIVATE  --driver org.sqlite.JDBC  --relaxed-isolation

> Allow use of uncommitted isolation for databases that support it as an import option
> ------------------------------------------------------------------------------------
>
>                 Key: SQOOP-1278
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1278
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.3, 1.4.4
>         Environment: All DBs that support uncommitted read transaction isolation
>            Reporter: Venkat Ranganathan
>            Assignee: Venkat Ranganathan
>             Fix For: 1.4.5
>
>         Attachments: SQOOP-1278-3.diff, SQOOP-1278.diff
>
>
> Some customers might have ETL workflows  that depend on data to be imported while the table is otherwise available for the regular data processing.    The current read committed isolation can cause failure because of locking semantics used in the database systems used also.
> So, this is to provide a relaxation of the connection isolation used by the mappers to be read uncommitted using a sqoop option.   Note that read uncommitted is not a valid option for Oracle so it is not supported with the database and will be ignored for Oracle



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)