Review Board 1.7.22


sqoop list-tables isn't returning the tables that have custom schemas

Review Request #9273 - Created Feb. 2, 2013 and updated

Vasanth kumar RJ
sqoop-853
Reviewers
Sqoop
sqoop-trunk
Added extra argument to list table command. Initially it was getting only public schema. With --schema arugment will retrieve tables of given schema. Example:
sqoop list-tables --connect jdbc:postgresql://<host>/sqoop --username sqoop --password sqoop -- --schema foo

 
src/docs/user/list-tables.txt
Revision 2d00237 New Change
[20] 50 lines
[+20]
51
payroll_checks
51
payroll_checks
52
job_descriptions
52
job_descriptions
53
office_supplies
53
office_supplies
54
----
54
----
55

    
   
55

   

    
   
56
In case of postgresql, list tables command with common arguments fetches only "public" schema. For custom schema, use --schema argument to list tables of particular schema

    
   
57
Example

    
   
58
----

    
   
59
$ sqoop list-tables --connect jdbc:postgresql://localhost/corp  --username name -P -- --schema payrolldept

    
   
60
employees

    
   
61
expenses

    
   
62
----
src/java/org/apache/sqoop/tool/ListTablesTool.java
Revision 529df37 New Change
 
  1. src/docs/user/list-tables.txt: Loading...
  2. src/java/org/apache/sqoop/tool/ListTablesTool.java: Loading...