Look at the error message Caused by: java.io.IOException: hdfs://localhost:54310/user/ hive/warehouse/cpj_tbl/cpj.csv.gz not a SequenceFile
Did you create table with sequencefile ? On Mon, Sep 16, 2013 at 1:33 PM, Garg, Rinku <rinku.g...@fisglobal.com>wrote: > Hi All,**** > > ** ** > > I have setup Hadoop, hive setup and trying to load gzip file in hadoop > cluster. Files are loaded successfully and can be view on web UI. While > executing Select query it gives me the below mentioned error.**** > > ** ** > > ERROR org.apache.hadoop.security.UserGroupInformation: > PriviledgedActionException as:nxtbig (auth:SIMPLE) > cause:java.io.IOException: java.lang.reflect.InvocationTargetException**** > > 2013-09-16 09:11:18,971 WARN org.apache.hadoop.mapred.Child: Error running > child**** > > java.io.IOException: java.lang.reflect.InvocationTargetException**** > > at > org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97) > **** > > at > org.apache.hadoop.hive.io.HiveIOExceptionHandlerUtil.handleRecordReaderCreationException(HiveIOExceptionHandlerUtil.java:57) > **** > > at > org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.initNextRecordReader(HadoopShimsSecure.java:369) > **** > > at > org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.<init>(HadoopShimsSecure.java:316) > **** > > at > org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileInputFormatShim.getRecordReader(HadoopShimsSecure.java:430) > **** > > at > org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getRecordReader(CombineHiveInputFormat.java:540) > **** > > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:395) > **** > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:333)**** > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268)**** > > at java.security.AccessController.doPrivileged(Native Method)**** > > at javax.security.auth.Subject.doAs(Subject.java:396)**** > > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1407) > **** > > at org.apache.hadoop.mapred.Child.main(Child.java:262)**** > > Caused by: java.lang.reflect.InvocationTargetException**** > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method)**** > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > **** > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > **** > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > **** > > at > org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.initNextRecordReader(HadoopShimsSecure.java:355) > **** > > ... 10 more**** > > Caused by: java.io.IOException: > hdfs://localhost:54310/user/hive/warehouse/cpj_tbl/cpj.csv.gz not a > SequenceFile**** > > at > org.apache.hadoop.io.SequenceFile$Reader.init(SequenceFile.java:1805)**** > > at > org.apache.hadoop.io.SequenceFile$Reader.initialize(SequenceFile.java:1765) > **** > > at > org.apache.hadoop.io.SequenceFile$Reader.<init>(SequenceFile.java:1714)*** > * > > at > org.apache.hadoop.io.SequenceFile$Reader.<init>(SequenceFile.java:1728)*** > * > > at > org.apache.hadoop.mapred.SequenceFileRecordReader.<init>(SequenceFileRecordReader.java:43) > **** > > at > org.apache.hadoop.mapred.SequenceFileInputFormat.getRecordReader(SequenceFileInputFormat.java:59) > **** > > at > org.apache.hadoop.hive.ql.io.CombineHiveRecordReader.<init>(CombineHiveRecordReader.java:65) > **** > > ... 15 more**** > > ** ** > > Can anybody help me on this.**** > > ** ** > > Thanks & Regards,**** > > *Rinku Garg* > > **** > > ** ** > > ** ** > _____________ > The information contained in this message is proprietary and/or > confidential. If you are not the intended recipient, please: (i) delete the > message and all copies; (ii) do not disclose, distribute or use the message > in any manner; and (iii) notify the sender immediately. In addition, please > be aware that any message addressed to our domain is subject to archiving > and review by persons other than the intended recipient. Thank you. > -- Nitin Pawar