How to import data to HBase from SQL server

0 votes

I have used Sqoop for importing data from SQL to HDFS. Does Sqoop also has the functionality of dumping data directly into HBase from SQL server?

Apr 20, 2018 in Big Data Hadoop by Shubham
• 13,490 points
1,645 views

1 answer to this question.

0 votes

You can easily import the data from SQL server to HDFS by following the below steps:

  • Download the SQL Server JDBC driver on to your machine.
  • Copy the JDBC driver into thelib directory present in Sqoop root directory:
cp sqljdbc.jar /usr/local/sqoop/lib
  • Import the tables from SQL Server to HDFS
sqoop import --hbase-create-table --hbase-table HBase_table --column-family cf1 --hbase-row-key id --connect "jdbc:sqlserver://hostname:port;database=dbName;username=uname;password=pass" --table sql_tablename -m 1

answered Apr 20, 2018 by kurt_cobain
• 9,350 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to import PIG data into HBase?

Follow the below steps to do it: # ...READ MORE

answered Feb 15, 2019 in Big Data Hadoop by Omkar
• 69,220 points
1,912 views
0 votes
1 answer

How to fetch more data from database while using Sqoop import?

Hey. You guessed it right. The max ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Gani
2,600 views
0 votes
1 answer

How to import data to hbase database?

There are 3 Ways to Load Data ...READ MORE

answered Jul 10, 2019 in Big Data Hadoop by Karan Reddy
5,432 views
0 votes
1 answer

How to import data to hbase database?

First you have to have the file ...READ MORE

answered Jul 23, 2019 in Big Data Hadoop by Kiran
2,946 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
11,070 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,569 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
109,022 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,350 points
4,635 views
0 votes
1 answer

How to transfer data from Netezza to HDFS using Apache Sqoop?

Remove the --direct option. It gives issue ...READ MORE

answered Apr 23, 2018 in Big Data Hadoop by kurt_cobain
• 9,350 points
1,770 views
0 votes
1 answer

How to learn Big Data and Ecosystem ?

First understand Big Data and challenges associated ...READ MORE

answered Mar 27, 2018 in Big Data Hadoop by kurt_cobain
• 9,350 points
1,003 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP