sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkat Ranganathan <vranganat...@hortonworks.com>
Subject Re: [jira] [Commented] (SQOOP-2779) Sqoop metastore doesn't seem to recognize --schema option
Date Sun, 07 Feb 2016 16:34:57 GMT
The failures reported are in avro tests which run locally after upgrade to 1.8.0 successfully.
 May be some caching issue.   I will file a test patch and commit and then go on to other
patches needing review and committing

Thanks

Venkat



On 1/31/16, 9:36 PM, "Hudson (JIRA)" <jira@apache.org> wrote:

>
>    [ https://issues.apache.org/jira/browse/SQOOP-2779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15125792#comment-15125792
] 
>
>Hudson commented on SQOOP-2779:
>-------------------------------
>
>FAILURE: Integrated in Sqoop-hadoop100 #1000 (See [https://builds.apache.org/job/Sqoop-hadoop100/1000/])
>SQOOP-2779: Sqoop metastore doesn't seem to recognize --schema option   (venkat: [https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=39feebff2a12bc9b7c903073c7be8b605baa9d48])
>* src/test/com/cloudera/sqoop/metastore/TestSavedJobs.java
>* src/java/org/apache/sqoop/tool/JobTool.java
>
>
>> Sqoop metastore doesn't seem to recognize --schema option
>> ---------------------------------------------------------
>>
>>                 Key: SQOOP-2779
>>                 URL: https://issues.apache.org/jira/browse/SQOOP-2779
>>             Project: Sqoop
>>          Issue Type: Bug
>>            Reporter: Sowmya Ramesh
>>            Assignee: Sowmya Ramesh
>>             Fix For: 1.4.7
>>
>>         Attachments: SQOOP-2779.V0.patch
>>
>>
>> PROBLEM:
>> When running sqoop job using sqoop metastore:
>> sqoop job --create 'globaldata.r.emaildomain' --meta-connect 'jdbc:hsqldb:hsql://da0shal203.match.corp:16000/sqoop'
--import --connect 'jdbc:sqlserver://MAREPORT\MAREPORT01;database=GlobalData;user=hdpreader;password=xxx'
--table EmailDomain --target-dir /hive/globaldatastaging/emaildomain --split-by 'DomainID'
--num-mappers 8 --columns 'DomainID, EmailDomain, InsertDate, EmailDomainGroupID, EmailDomainGroup'
--hive-drop-import-delims --fields-terminated-by '\001' --lines-terminated-by '\n' --null-string
'
>> N' --null-non-string '
>> N' – --schema lookup
>> It is throwing the error that it cannot find the table when executing the job:
>> 15/08/24 15:21:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM
EmailDomain AS t WHERE 1=0 
>> 15/08/24 15:21:18 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException:
Invalid object name 'EmailDomain'.
>
>
>
>--
>This message was sent by Atlassian JIRA
>(v6.3.4#6332)
>
Mime
View raw message