InputFormats need to be in auxlib. Add jar is not good enough. You can either edit your config file or create an auxlib folder and put these jars in that folder.
On Thu, Sep 20, 2012 at 11:25 AM, <richin.j...@nokia.com> wrote: > You can always use : ADD JAR <Path-to-your-jar-file> to your HQL file or run > this command on Hive shell. > > > > OR > > > > I found this in a previous thread > > > > Add following property to your hive-site.xml > > <property> > > <name>hive.aux.jars.path</name> > > <value>file:///home/me/my.jar,file:///home/you/your.jar,file:///home/us/our.jar</value> > > </property> > > Hope this helps. > > > > Richin > > > > From: ext Connell, Chuck [mailto:chuck.conn...@nuance.com] > Sent: Thursday, September 20, 2012 11:16 AM > To: user@hive.apache.org > Subject: RE: Hive custom inputfomat error. > > > > 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.
