Skip to main content

Sqoop


For Sqoop with MySQL, It requires MySQL connector jar in Sqoop binary location.

Sqoop binary location: usr/hdp/current/sqoop

Sqoop Commands:

#List Databases
> sqoop list-databases --connect jdbc:mysql://<mysql-URL>:<port> --username <USERNAME> --password <PASSWORD>

#List Table from database
> sqoop list-tables --connect jdbc:mysql://<mysql-URL>:<port>/<DBName> --username <USERNAME> --password <PASSWORD>

#Evaluate sql query
For evaluate sql query
> sqoop eval --connect jdbc:mysql://<mysql-URL>:<port>/<DBName> --username <USERNAME> --password <PASSWORD> --query “<SQL QUERY>”


Comments

Post a Comment

Popular posts from this blog

AWS Kinesis - Stream, Firehose, Analytics Overview

AWS Kinesis: AWS Kinesis is managed alternative of Apache Kafka. It can be used for big data real-time stream processing. It can be used for applications logs, metrics, forecast data, IoT. It can be used for streaming processing framework like Spark, NiFi, etc.   Kinesis Capabilities: Kinesis Streams : Streaming data ingest at scale with low latency. It is a data stream. Kinesis Analytics : To perform analytics on real-time streaming data using SQL. You can filter or aggregate data in real time. Kinesis Firehose : To load streams of data into S3, Redshift, Splunk or Elastic Search. It is a delivery stream. Kinesis Data Streams : Streams are divided into shards. To scale up application we can update shard configuration by increasing number of shards. By default shard's data can be retained for 1 Day but you can extend it for 7 days. Multiple application can use same stream. Real-time processing of data with a scale of throughput. Record size shoul...
3 comments
Read more

CCA 175 Preparation with this 6 practice questions- Try to solve it in 1 hour

As I found very few practice questions available on the internet for CCA 175 - Hadoop & spark developer exam. I set 6 questions exam with the solution provided in the comment section.  If you complete it in less than 1 hour then and then think to apply CCA 175 exam else you need more practice. Question's prerequisites : import data from orders table with parquet file format and save data to hdfs path: /user/rj_example/parquet_data/orders import data from customers table and save data to hdfs path: /user/rj_example/data/customers import data from customers table with avro file format and save data to hdfs path: /user/rj_example/avro_data/customers import data from customers table and save data to hdfs path: /user/rj_example/data/categories import data from products table and save data to hdfs path: /user/rj_example/data/products with '\t' as fields seperator create local dir 'rj_example' copy data from /user/rj_example/data/products to local dir ...
3 comments
Read more

Get Free Voucher for Azure Certification

If you wanted to measure/prove your skill for Microsoft Azure cloud free of cost then this blog is for you. How to get Azure Free voucher code   Microsoft is giving opportunity to prove your skill for azure cloud free of cost. You just need to follow below steps and you will get your unique free voucher, then you can schedule certification exam free of cost. Please note that this is limited time offer and voucher will be valid for 3 months. Go to Microsoft Azure events website:  click here List of event will display, among them click on Microsoft Azure Virtual Training Day: Fundamentals Slot may be full for particular day, need to traverse all the date to find available slot. Once you find available slot, then register. You need to attend that virtual event for selected slot, then you will get voucher code in 7 days in your email. You can use this code to schedule exam free of cost. My Exam Experience: I have cleared  AZ-204: Developing Solutions ...
1 comment
Read more