Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Issue while quering Hive


+
Garg, Rinku 2013-09-16, 08:03
Copy link to this message
-
Re: Issue while quering Hive
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 <[EMAIL PROTECTED]>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

Nitin Pawar
+
Garg, Rinku 2013-09-16, 10:06
+
Nitin Pawar 2013-09-16, 10:26
+
Garg, Rinku 2013-09-16, 11:48
+
Nitin Pawar 2013-09-16, 12:07
+
Sanjay Subramanian 2013-09-16, 14:29