You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Giovanni Ruggiero (JIRA)" <ji...@apache.org> on 2012/08/06 16:27:02 UTC
[jira] [Created] (SQOOP-540) Sqoop doesn't manage custom schemas
Giovanni Ruggiero created SQOOP-540:
---------------------------------------
Summary: Sqoop doesn't manage custom schemas
Key: SQOOP-540
URL: https://issues.apache.org/jira/browse/SQOOP-540
Project: Sqoop
Issue Type: Bug
Components: connectors/sqlserver
Affects Versions: 1.4.1-incubating
Reporter: Giovanni Ruggiero
Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-540) Sqoop doesn't manage custom schemas
Posted by "Giovanni Ruggiero (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13459722#comment-13459722 ]
Giovanni Ruggiero commented on SQOOP-540:
-----------------------------------------
This issue happens also in the 1.4.2 version.
There are any plans to check this bug?
Thank you
> Sqoop doesn't manage custom schemas
> -----------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13467410#comment-13467410 ]
Hudson commented on SQOOP-540:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop20 #139 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/139/])
SQOOP-540 Microsoft SQL Connector doesn't support custom schemas (Revision 4a26d0905ce58e97a35494dbd425f768b34abe28)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=4a26d0905ce58e97a35494dbd425f768b34abe28
Files :
* src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerExportManualTest.java
* src/java/org/apache/sqoop/mapreduce/db/DataDrivenDBRecordReader.java
* src/java/org/apache/sqoop/mapreduce/HBaseImportJob.java
* src/java/org/apache/sqoop/manager/SQLServerManager.java
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-540:
-------------------------------------
Attachment: (was: SQOOP-540.patch)
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-540:
-------------------------------------
Summary: Microsoft SQL Connector doesn't support custom schemas (was: Sqoop doesn't manage custom schemas)
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Sqoop doesn't manage custom schemas
Posted by "Giovanni Ruggiero (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Giovanni Ruggiero updated SQOOP-540:
------------------------------------
Affects Version/s: 1.4.2
> Sqoop doesn't manage custom schemas
> -----------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-540:
-------------------------------------
Attachment: SQOOP-540.patch
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13467416#comment-13467416 ]
Hudson commented on SQOOP-540:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop100 #145 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/145/])
SQOOP-540 Microsoft SQL Connector doesn't support custom schemas (Revision 4a26d0905ce58e97a35494dbd425f768b34abe28)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=4a26d0905ce58e97a35494dbd425f768b34abe28
Files :
* src/test/com/cloudera/sqoop/manager/SQLServerManagerExportManualTest.java
* src/java/org/apache/sqoop/mapreduce/db/DataDrivenDBRecordReader.java
* src/java/org/apache/sqoop/manager/SQLServerManager.java
* src/java/org/apache/sqoop/mapreduce/HBaseImportJob.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-540:
-------------------------------------
Attachment: SQOOP-540.patch
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13467413#comment-13467413 ]
Hudson commented on SQOOP-540:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop23 #280 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/280/])
SQOOP-540 Microsoft SQL Connector doesn't support custom schemas (Revision 4a26d0905ce58e97a35494dbd425f768b34abe28)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=4a26d0905ce58e97a35494dbd425f768b34abe28
Files :
* src/java/org/apache/sqoop/mapreduce/HBaseImportJob.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerExportManualTest.java
* src/java/org/apache/sqoop/mapreduce/db/DataDrivenDBRecordReader.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java
* src/java/org/apache/sqoop/manager/SQLServerManager.java
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13467405#comment-13467405 ]
Hudson commented on SQOOP-540:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop200 #138 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/138/])
SQOOP-540 Microsoft SQL Connector doesn't support custom schemas (Revision 4a26d0905ce58e97a35494dbd425f768b34abe28)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=4a26d0905ce58e97a35494dbd425f768b34abe28
Files :
* src/java/org/apache/sqoop/manager/SQLServerManager.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java
* src/test/com/cloudera/sqoop/manager/SQLServerManagerExportManualTest.java
* src/java/org/apache/sqoop/mapreduce/HBaseImportJob.java
* src/java/org/apache/sqoop/mapreduce/db/DataDrivenDBRecordReader.java
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Cheolsoo Park (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cheolsoo Park updated SQOOP-540:
--------------------------------
Fix Version/s: 1.4.3
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-540) Microsoft SQL Connector doesn't
support custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-540:
-------------------------------------
Issue Type: New Feature (was: Bug)
> Microsoft SQL Connector doesn't support custom schemas
> ------------------------------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
> Attachments: SQOOP-540.patch
>
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (SQOOP-540) Sqoop doesn't manage custom schemas
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho reassigned SQOOP-540:
----------------------------------------
Assignee: Jarek Jarcec Cecho
Hi Giovanni,
I've recently added support for schemas into PostgreSQL connector, so I'll take a look on this issue as well.
Jarcec
> Sqoop doesn't manage custom schemas
> -----------------------------------
>
> Key: SQOOP-540
> URL: https://issues.apache.org/jira/browse/SQOOP-540
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/sqlserver
> Affects Versions: 1.4.1-incubating, 1.4.2
> Reporter: Giovanni Ruggiero
> Assignee: Jarek Jarcec Cecho
>
> Trying list-tables on the Microsoft test db AdventureWorks2008R2, Sqoop lists only the tables of the dbo (default) schema.
> Trying to import a table which belongs to a schema different from dbo, it fails with the message Invalid object name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira