Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on 01-18-2016 07:26 PM - edited 09-16-2022 02:58 AM
Pig Stack Trace --------------- ERROR 1200: can't convert optional int96 uploadTime Failed to parse: can't convert optional int96 uploadTime at org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:201) at org.apache.pig.PigServer$Graph.validateQuery(PigServer.java:1707) at org.apache.pig.PigServer$Graph.registerQuery(PigServer.java:1680) at org.apache.pig.PigServer.registerQuery(PigServer.java:623) at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:1061) at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:501) at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:230) at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:205) at org.apache.pig.tools.grunt.Grunt.run(Grunt.java:66) at org.apache.pig.Main.run(Main.java:560) at org.apache.pig.Main.main(Main.java:170) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: parquet.pig.SchemaConversionException: can't convert optional int96 uploadTime at parquet.pig.PigSchemaConverter.convertFields(PigSchemaConverter.java:108) at parquet.pig.PigSchemaConverter.convert(PigSchemaConverter.java:84) at parquet.pig.TupleReadSupport.getPigSchemaFromMultipleFiles(TupleReadSupport.java:70) at parquet.pig.ParquetLoader.initSchema(ParquetLoader.java:204) at parquet.pig.ParquetLoader.setInput(ParquetLoader.java:108) at parquet.pig.ParquetLoader.getSchema(ParquetLoader.java:188) at org.apache.pig.newplan.logical.relational.LOLoad.getSchemaFromMetaData(LOLoad.java:175) at org.apache.pig.newplan.logical.relational.LOLoad.<init>(LOLoad.java:89) at org.apache.pig.parser.LogicalPlanBuilder.buildLoadOp(LogicalPlanBuilder.java:901) at org.apache.pig.parser.LogicalPlanGenerator.load_clause(LogicalPlanGenerator.java:3568) at org.apache.pig.parser.LogicalPlanGenerator.op_clause(LogicalPlanGenerator.java:1625) at org.apache.pig.parser.LogicalPlanGenerator.general_statement(LogicalPlanGenerator.java:1102) at org.apache.pig.parser.LogicalPlanGenerator.statement(LogicalPlanGenerator.java:560) at org.apache.pig.parser.LogicalPlanGenerator.query(LogicalPlanGenerator.java:421) at org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:191) ... 16 more Caused by: org.apache.pig.impl.logicalLayer.FrontendException: ERROR 0: NYI at parquet.pig.PigSchemaConverter$1.convertINT96(PigSchemaConverter.java:148) at parquet.pig.PigSchemaConverter$1.convertINT96(PigSchemaConverter.java:120) at parquet.schema.PrimitiveType$PrimitiveTypeName$7.convert(PrimitiveType.java:219) at parquet.pig.PigSchemaConverter.getSimpleFieldSchema(PigSchemaConverter.java:119) at parquet.pig.PigSchemaConverter.getFieldSchema(PigSchemaConverter.java:222) at parquet.pig.PigSchemaConverter.convertFields(PigSchemaConverter.java:99) ... 30 more ================================================================================
Created 01-19-2016 07:31 PM
Actually they gave me a corrupted file which was causing the issue...between i have another question can i store the output from parquet as csv ?
Created 01-19-2016 07:33 PM
HI @Pradeep Allu please post your other question as a new question