#!/bin/sh
export SQOOP_HOME=/opt/install/sqoop-1.4.7.bin__hadoop-2.6.0
export HIVE_HOME=/opt/install/hive-1.2.2-bin
hostname="..."
user=“root”
password="******"
database=“populcationcensus”
table=“AntiepidemicDataIncrement”
table1=""
curr_max=0

function db_to_hive(){

$HIVE_HOME/bin/hive -e “use default;select max(id) from antiepidemicdatatest;” >/opt/install/c.txt

dataline=$(cat /opt/install/c.txt)

testArr=(echo ${dataline}|awk '{len=split($0,a,",");for(i=1;i<=len;i++) print a[i]}')

echo ${testArr[0]}

echo ${testArr[1]}

curr_max=${testArr[1]}

KaTeX parse error: Undefined control sequence: \at position 31: …n/sqoop import \̲ ̲-Dhadoop.securi…{hostname}:3306/${database}
–username ${user}
–password-alias mysql.pwd.alias
–table AntiepidemicDataIncrement
–split-by id
–hive-import
–incremental append
–check-column id
–hive-database default
–hive-table AntiepidemicDatatest
–fields-terminated-by “\t”
–last-value ${curr_max}
}

  db_to_hive