Thanks. Got the solution, i was copying my jar in wrong folder. I should have copied in /usr/lib/hive/lib folder.
Thank You, Manish On Thu, 2012-09-20 at 15:15 +0000, Connell, Chuck wrote: > You might try adding “ --auxpath /path/to/jar/dir “ to the Hive > command line. > > > > > Chuck Connell > > Nuance R&D Data Team > > Burlington, MA > > > > > > > From: Manish [mailto:manishbh...@rocketmail.com] > Sent: Thursday, September 20, 2012 11:10 AM > To: user > Cc: u...@hadoop.apache.org > Subject: Hive custom inputfomat error. > > > > > > I have created custom input format in java. Now I want to use that > input format when creating table in Hive. > > Here are my steps: > 1. Created jar file of the program. > 2. Copied jar in /usr/lib/hadoop. > 3. Added the path in CLASSPATH. > > now here is my code: > > Create table hitdata_fnl > ( > col_0 string, > col_1 string, > col_2 string, > col_3 string, > col_4 string, > col_5 string, > col_6 string, > col_7 string, > col_8 string, > col_9 string, > col_10 string > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' > STORED AS INPUTFORMAT > 'com.tgam.hadoop.mapreduce.inputfilerecordreader' OUTPUTFORMAT > 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'; > > Error : > FAILED: Error in metadata: Class not found: > com.tgam.hadoop.mapreduce.inputfilerecordreader > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > Please help on this error. > > Thank You, > Manish. > >
