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:33:00 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-3440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

hile updated SQOOP-3440:
------------------------
    Priority: Blocker  (was: Major)

> 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:@//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)

Mime
View raw message