[jira] [Created] (SQOOP-3440) OraOopConnManager BoundingValsQuery has a bug if RMDB is oracle

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

hile created SQOOP-3440:
---------------------------

             Summary: 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
         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:@//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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)