[SQOOP-1437] 'Text' reserved word in compliation

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.4.4, 1.4.5
• Fix Version/s: 1.4.6
• Component/s: codegen
• Assignee: Nick White
• Reporter: Charles Robertson
• Created: 14/Aug/14 20:27
• Updated: 07/Oct/14 02:08
• Resolved: 07/Oct/14 01:05

Description

Code generation failed because my destination table (in AWS RDS MySql) had a column named 'Text'. Changing this column solved the issue. This is the error output:

/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:197: error: cannot find symbol
    this.Text = Text.readString(__dataIn);
                    ^
  symbol:   method readString(DataInput)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:202: error: cannot find symbol
    this.ScreenName = Text.readString(__dataIn);
                          ^
  symbol:   method readString(DataInput)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:207: error: cannot find symbol
    this.Name = Text.readString(__dataIn);
                    ^
  symbol:   method readString(DataInput)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:217: error: cannot find symbol
    this.Sentiment = Text.readString(__dataIn);
                         ^
  symbol:   method readString(DataInput)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:244: error: cannot find symbol
    Text.writeString(__dataOut, Text);
        ^
  symbol:   method writeString(DataOutput,String)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:250: error: cannot find symbol
    Text.writeString(__dataOut, ScreenName);
        ^
  symbol:   method writeString(DataOutput,String)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:256: error: cannot find symbol
    Text.writeString(__dataOut, Name);
        ^
  symbol:   method writeString(DataOutput,String)
  location: variable Text of type String
/tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java:268: error: cannot find symbol
    Text.writeString(__dataOut, Sentiment);
        ^
  symbol:   method writeString(DataOutput,String)
  location: variable Text of type String
Note: /tmp/sqoop-root/compile/800bf97df684e2e48f096e96bd7a30c6/ScoredTweets.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
8 errors
14/08/13 19:25:08 ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: Error returned by javac