08-18-2017 05:15 AM
I am running sqoop import on the CLI unix, it gets the data from source database table and creates exact structure in target and loads data. but one issue causing due to comma, if there is a comma within a column value then it is automatically assuming ghe string after comma is of next column, how to contain all text for a column if there is comma also to take care.
Thanks a lot for the helpful info.
the below statement is creating a table on hadoop hive with exact structure and loading data to target.
sqoop import --connect jdbc:oracle:thin:@SVRDEVWHSEDB:1521:edw2dev --username hadooppsvc --P --query "SELECT * FROM edw2_stage.wh_cln_procedure WHERE \$CONDITIONS" --target-dir /user/hive/warehouse/research_stage.db/st_wh_cln_procedure --hive-import --hive-database research_stage --hive-table st_wh_cln_procedure --split-by procedure_key