[ https://issues.apache.org/jira/browse/SQOOP-3440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hile updated SQOOP-3440:
------------------------
Description:
sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true -Doraoop.chunk.method=ROWID
-Doraoop.timestamp.string=true " \
--connect jdbc:oracle:thin:@//database \
--connection-manager org.apache.sqoop.manager.OracleManager \
--username top_dev \
--password top_dev \
--query 'select * from table WHERE $CONDITIONS' \
--target-dir /user/hive/warehouse/top_dev.db/ \
--split-by rownum -m 4 \
--as-parquetfile \
--hive-import \
--hive-overwrite \
--hive-database top_dev \
--hive-table table \
--null-string '
N' --null-non-string '
N' \
when i set connection-manager is OraOopConnManager and there is a bug when excute BoundingValsQuery in
oracle because of appending 'as t1' in the end .
why OraOopConnManager don't override
public String getInputBoundsQuery(String splitByCol, String sanitizedQuery)
like OracleManager has done.
was:
sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true -Doraoop.chunk.method=ROWID
-Doraoop.timestamp.string=true " \
--connect jdbc:oracle:thin:@//10.60.44.54:1521/EE.oracle.docker \
--connection-manager org.apache.sqoop.manager.OracleManager \
--username top_dev \
--password top_dev \
--query 'select * from CUX_GL_DETAILS WHERE $CONDITIONS' \
--target-dir /user/hive/warehouse/top_dev.db/ \
--split-by rownum -m 4 \
--as-parquetfile \
--hive-import \
--hive-overwrite \
--hive-database top_dev \
--hive-table CUX_GL_DETAILS \
--null-string '\\N' --null-non-string '\\N' \
when i set connection-manager is OraOopConnManager and there is a bug when excute BoundingValsQuery in
oracle because of appending 'as t1' in the end .
why OraOopConnManager don't override
public String getInputBoundsQuery(String splitByCol, String sanitizedQuery)
like OracleManager has done.
> OraOopConnManager BoundingValsQuery has a bug if RMDB is oracle
> -----------------------------------------------------------------
>
> Key: SQOOP-3440
> URL: https://issues.apache.org/jira/browse/SQOOP-3440
> Project: Sqoop
> Issue Type: Bug
> Reporter: hile
> Priority: Blocker
> Attachments: image-2019-05-17-11-30-30-534.png, image-2019-05-17-11-30-51-968.png
>
>
> sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true -Doraoop.chunk.method=ROWID
-Doraoop.timestamp.string=true " \
> --connect jdbc:oracle:thin:@//database \
> --connection-manager org.apache.sqoop.manager.OracleManager \
> --username top_dev \
> --password top_dev \
> --query 'select * from table WHERE $CONDITIONS' \
> --target-dir /user/hive/warehouse/top_dev.db/ \
> --split-by rownum -m 4 \
> --as-parquetfile \
> --hive-import \
> --hive-overwrite \
> --hive-database top_dev \
> --hive-table table \
> --null-string '
> N' --null-non-string '
> N' \
>
> when i set connection-manager is OraOopConnManager and there is a bug when excute
BoundingValsQuery in oracle because of appending 'as t1' in the end .
> why OraOopConnManager don't override
> public String getInputBoundsQuery(String splitByCol, String sanitizedQuery)
> like OracleManager has done.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
|