sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hile (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-3440) OraOopConnManager BoundingValsQuery has a bug if RMDB is oracle
Date Fri, 17 May 2019 03:42:00 GMT

     [ 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.oracle.OraOopConnManager   \
 --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:@//database \
 --connection-manager org.apache.sqoop.manager.oracle.OraOopConnManager   \
 --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.


> 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
>    Affects Versions: 1.4.7
>            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.oracle.OraOopConnManager   \
>  --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)

Mime
View raw message