Member since
08-10-2018
21
Posts
0
Kudos Received
0
Solutions
02-07-2019
07:42 AM
Check your snapshot details
hdfs dfs -ls $DIR/.snapshot/
hdfs dfs -setrep -w 2 -R / then restart hdfs services
... View more
02-07-2019
06:36 AM
@ram sriram Changing replication will only apply to new files you need to run this Command to change replication factor
for files that already exist
hdfs dfs -setrep -w 1 -R /
... View more
02-06-2019
04:33 AM
@Siva A
@Geoffrey Shelton Okot
--fields-terminated-by "\020" is solved this issue and i shared this details under idea.find the link below! https://community.hortonworks.com/content/idea/236981/how-to-avoid-null-values-and-extra-columns-during.html
... View more
01-29-2019
07:55 AM
@Geoffrey Shelton Okot tried your answers --null-string and --null-non-string Still Facing Same Issues. we are using oracle11g type DB and tables as source to hive as destination .Is there any Datatype kinds of issue is there?
... View more
01-25-2019
04:02 AM
@Siva A Thankyou field delimiter (--fields-terminated-by | ) and field delimiter (--fields-terminated-by ~) used '\020' Solved my issue
... View more
01-24-2019
09:21 AM
Dear All,
I am using this sqoop command for importing Oracle Table into Hive Table
sqoop import --connect jdbc:oracle:thin:@123.123.123.112:1500:COL --username admin -P --table db.table1 --hive-import --hive-overwrite --create-hive-table --hive-database hive_db --hive-table table1 --split-by primary_Key
After Importing from oracle to Hive
Some rows and columns are entirely Showing 'NULL' .
ORACLE TABLE
HIVE TABLE -ISSUE
1. PRIMARY_KEY (NOT NULL COLUMN) 2. There is 0 'NULL' Value
1. SOME ROWS AND COLUMNS ARE NULL 2. 35 NULL (ROWS and COLUMS)
How to clear it?
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Sqoop
08-16-2018
12:30 PM
i too wanted it
... View more