That is because null is not a datatype in Pig. http://pig.apache.org/docs/r0.12.1/basic.html#data-types
If fact, you don't need to specify a type at all for aliases. Try, (key, value: chararray). On Wed, May 21, 2014 at 2:21 PM, abhishek dodda <[email protected]>wrote: > Hi, > > REGISTER /home/xyz/elephant-bird-pig-4.5.jar; > REGISTER /home/xyz/elephant-bird-pig-4.5-sources.jar; > REGISTER /home/xyz/elephant-bird-pig-4.5-tests.jar; > > > A = load '/etl/table=04' using > com.twitter.elephantbird.pig.load.SequenceFileLoader > ('-c com.twitter.elephantbird.pig.util.TextConverter','-c > com.twitter.elephantbird.pig.util.TextConverter') > AS (key:chararray,value:chararray); > > > 2014-05-21 18:10:53,391 [main] ERROR org.apache.pig.tools.grunt.Grunt - > ERROR 2998: Unhandled internal error. > com/twitter/elephantbird/mapreduce/input/RawSequenceFileInputFormat > Details at logfile: /home/xyz/pig_1400694772994.log > > A = load '/etl/table=04' using > com.twitter.elephantbird.pig.load.SequenceFileLoader > ('-c com.twitter.elephantbird.pig.util.NullWritableConverter','-c > com.twitter.elephantbird.pig.util.TextConverter') > AS (key:null,value:chararray); > > Also tried NullWritable as key > > 2014-05-21 18:11:58,554 [main] ERROR org.apache.pig.tools.grunt.Grunt - > ERROR 1200: <line 11, column 9> Syntax error, unexpected symbol at or near > 'null' > Details at logfile: /home/xyz/pig_1400694772994.log > > None of them worked. I am something missing here ? > > > > > On Tue, May 20, 2014 at 9:12 PM, Pradeep Gollakota > <[email protected]>wrote: > >> Sorry, >> >> Missed the part about loading custom types from SequenceFiles. The >> LoadFunc from piggybank will only load pig types. However, (as you already >> know), you can use elephant-bird. Not sure why you need to build it. The >> artifact exists in maven central. >> >> >> http://search.maven.org/#artifactdetails%7Ccom.twitter.elephantbird%7Celephant-bird-pig%7C4.5%7Cjar >> >> Hope this helps. >> >> >> On Tue, May 20, 2014 at 1:44 PM, abhishek dodda < >> [email protected]> wrote: >> >>> Iam getting this error >>> >>> A = load '/a/part-m-0000' using >>> org.apache.pig.piggybank.storage.SequenceFileLoader(); >>> >>> >>> >>> >>> org.apache.pig.backend.BackendException: ERROR 0: Unable to translate >>> class org.apache.hadoop.io.NullWritable to a Pig datatype >>> >>> >>> >>> at >>> org.apache.pig.piggybank.storage.SequenceFileLoader.setKeyType(SequenceFileLoader.java:81) >>> at >>> org.apache.pig.piggybank.storage.SequenceFileLoader.getNext(SequenceFileLoader.java:138) >>> at >>> org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.PigRecordReader.nextKeyValue(PigRecordReader.java:211) >>> at >>> org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:484) >>> at >>> org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76) >>> at >>> org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85) >>> at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139) >>> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:673) >>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:331) >>> at org.apache.hadoop.mapred.Child$4.run(Child.java:268) >>> at java.security.AccessController.doPrivileged(Native Method) >>> >>> >>> >>> On Tue, May 20, 2014 at 5:41 AM, Pradeep Gollakota <[email protected] >>> > wrote: >>> >>>> You can use the SequenceFileLoader from the piggybank. >>>> >>>> >>>> http://pig.apache.org/docs/r0.12.0/api/org/apache/pig/piggybank/storage/SequenceFileLoader.html >>>> >>>> >>>> On Tue, May 20, 2014 at 2:46 AM, abhishek dodda >>>> <[email protected]>wrote: >>>> >>>> > Hi All, >>>> > >>>> > I have trouble building code for this project. >>>> > >>>> > https://github.com/kevinweil/elephant-bird >>>> > >>>> > can some one tell how to read sequence files in pig. >>>> > >>>> > -- >>>> > Thanks, >>>> > Abhishek >>>> > >>>> >>> >>> >>> >>> -- >>> Thanks, >>> Abhishek >>> 2018509769 >>> >> >> > > > -- > Thanks, > Abhishek > 2018509769 >
