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