Top "Sqoop" questions

Delta/Incremental Load in Hive

I have the use case below : My application has a table having multiyear data in RDBMS DB. We have used …

hadoop hive sqoop hiveql

Where do I install a jdbc driver on ubuntu?

I'm trying to install the MS SQL JDBC driver on ubuntu to be used with sqoop for Hadoop. I'm totally …

java jdbc installation hadoop sqoop

How to use sqoop to export the default hive delimited output?

I have a hive query: insert override directory /x select ... Then I'm try to export the data with sqoop sqoop …

hadoop hive sqoop

Sqoop import without primary key in RDBMS

Can I import RDBMS table data (table doesn't have a primary key) to hive using sqoop? If yes, then can …

import sqoop

How to use a specified Hive database when using Sqoop import

sqoop import --connect jdbc:mysql://remote-ip/db --username xxx --password xxx --table tb --hive-import The above command imports table tb …

hadoop hive sqoop

When to use Sqoop --create-hive-table

Can anyone tell the difference between create-hive-table & hive-import method? Both will create a hive table, but still what is …

hive sqoop

Sqoop import Null string

The Null values are displayed as '\N' when a hive external table is queried. Below is the sqoop import …

hadoop null hive teradata sqoop

Sqoop Hive table import, Table dataType doesn't match with database

Using Sqoop to import data from oracle to hive, its working fine but it create table in hive with only 2 …

hadoop hive hdfs sqoop

What is the difference between --split-by and --boundary-query in SQOOP?

Assuming we don't have a column where values are equally distributed, let's say we have a command like this: sqoop …

split sqoop boundary

What is --direct mode in sqoop?

As per my understanding sqoop is used to import or export table/data from the Database to HDFS or Hive …

hadoop hadoop2 sqoop sqoop2