| |
| //// |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| //// |
| |
| |
| +sqoop-list-tables+ |
| ------------------- |
| |
| Purpose |
| ~~~~~~~ |
| |
| List tables present in a database. |
| |
| Syntax |
| ~~~~~~ |
| |
| ---- |
| $ sqoop list-tables (generic-args) (list-tables-args) |
| $ sqoop-list-tables (generic-args) (list-tables-args) |
| ---- |
| |
| Although the Hadoop generic arguments must preceed any list-tables |
| arguments, the list-tables arguments can be entered in any order |
| with respect to one another. |
| |
| include::common-args.txt[] |
| |
| Example Invocations |
| ~~~~~~~~~~~~~~~~~~~ |
| |
| List tables available in the "corp" database: |
| |
| ---- |
| $ sqoop list-tables --connect jdbc:mysql://database.example.com/corp |
| employees |
| payroll_checks |
| job_descriptions |
| office_supplies |
| ---- |
| |
| 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 |
| Example |
| ---- |
| $ sqoop list-tables --connect jdbc:postgresql://localhost/corp --username name -P -- --schema payrolldept |
| employees |
| expenses |
| ---- |