How can you avoid importing tables one-by-one when importing a large number of tables from a database?
Answer / Poornima Yadav
To import multiple tables in one go, you can use the --tables option followed by a comma-separated list of table names. For example: sqoop import --connect jdbc:mysql://localhost/mydb --username myuser --password password --table table1,table2,table3
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Sqoop Validation?
How Sqoop can be used in a Java program?
How can I import large objects (BLOB and CLOB objects) in Apache Sqoop?
How many default mappers in sqoop ?
What is the importance of — the split-by clause in running parallel import tasks in sqoop?
How will you update the rows that are already exported?
What is the purpose of sqoop-merge?
What is Sqoop Job?
Hadoop sqoop word came from?
What is the primary purpose of sqoop in the hadoop architecture?
Can free form SQL queries be used with Sqoop import command?
How we can check hadoop sqoop installed or not in a system?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)