apache pig error in loading

somi — Sun, 15 Mar 2020 19:37:39 GMT

I am facing the following error on the cmd:

command:

grunt> A = LOAD 'C:\data\myfile.txt';

grunt> a = load 'c:\data\myfile.txt' using PigStorage(' ') as (f1:int,f2:int, f3:int);

error:
<line 1, column 14> Unexpected character 'D'
2020-03-15 20:56:50,153 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: <line 1, column 14> Unexpected character 'D'
Details at logfile: C:\deploy\logs\pig_1584281243336.log

the error trace is as follows-

Pig Stack Trace
---------------
ERROR 1200: <line 1, column 14> Unexpected character 'D'

Failed to parse: <line 1, column 14> Unexpected character 'D'
at org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:246)
at org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:182)
at org.apache.pig.PigServer$Graph.validateQuery(PigServer.java:1792)
at org.apache.pig.PigServer$Graph.registerQuery(PigServer.java:1765)
at org.apache.pig.PigServer.registerQuery(PigServer.java:708)
at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:1110)
at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:512)
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:564)
at org.apache.pig.Main.main(Main.java:175)

Re: apache pig error in loading

ask_bill_brooks — Sun, 15 Mar 2020 20:19:00 GMT

Hi @somi,

Just looking at the error message alone, it seems to me like the problem is with your data file. Can you post the first few lines of the input data file myfile.txt in this thread?

Re: apache pig error in loading

somi — Mon, 16 Mar 2020 06:32:58 GMT

sir myfile.txt contains simply the following trial data-

1 2 3

4 5 6

Re: apache pig error in loading

theKira — Wed, 13 Apr 2022 08:10:04 GMT

You should represent your data in this case: 'C:\\data\\myfile.txt'.

I had the same problem.

question Re: apache pig error in loading in Support Questions

apache pig error in loading

Re: apache pig error in loading

Re: apache pig error in loading

Re: apache pig error in loading