利用sqoop 从hive导数据到oracle可以分为两步:
—hive导出数据到hdfs
insert overwrite directory "/home/hadoop/data/"
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
select {
hive表字段} from stg.{
hive表名};
—hdfs to oracle
sqoop export --connect jdbc:oracle:thin:@{
ip