About hariprasanthmad

hariprasanthmad · ‎05-20-2019

@fnu rasool 1.Try to run the Sqoop job as a non-root user. 2.Check if your JDK is properly installed on the host and your JAVA_HOME is set properly. 3.Check if you have granted the right permissions to the Databases you're using. i think there must be a configuration error !

hariprasanthmad · ‎02-07-2019

Check your snapshot details hdfs dfs -ls $DIR/.snapshot/ hdfs dfs -setrep -w 2 -R / then restart hdfs services

hariprasanthmad · ‎02-07-2019

Refer this link for more information https://community.hortonworks.com/questions/212100/timeline-service-v20-reader-not-starting.html

hariprasanthmad · ‎02-07-2019

@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 /

hariprasanthmad · ‎02-06-2019

@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

hariprasanthmad · ‎01-29-2019

@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?

hariprasanthmad · ‎01-25-2019

@Siva A Thankyou field delimiter (--fields-terminated-by | ) and field delimiter (--fields-terminated-by ~) used '\020' Solved my issue

hariprasanthmad · ‎01-24-2019

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?

hariprasanthmad · ‎12-07-2018

@Saurav Ranjit Steps!!!! 1.Need to enable ACID Property 2. table need to be in ORC format and bucket enabled. Check table definition using "SHOW CREATE TABLE", to know if it satisfies above conditions. then delete.

hariprasanthmad · ‎09-28-2018

hdfs Avro formatted file insert into HiveORC formatted table

Online	Offline
Last Visited	‎09-16-2019 06:01 AM

Member Since	‎08-10-2018 12:59 PM
Last Visited	‎09-16-2019 06:01 AM
Posts	21

Cloudera Community

Re: SQOOP - Connecting to ORACLE with direct optio...

Re: HDFS data is not decreasing after reducing the...

Re: Timeline Service V2.0 Reader failed with NoAut...

Re: HDFS data is not decreasing after reducing the...

Re: Sqoop from Oracle to Hive table

Re: Sqoop from Oracle to Hive table

Re: Sqoop from Oracle to Hive table

Sqoop from Oracle to Hive table

Re: delete query from hive table (with partition) ...

hdfs Avro format file need to insert into Hive ORC...