Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-2118

error: package com.cloudera.sqoop.lib does not exist import com.cloudera.sqoop.lib.JdbcWritableBridge;

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • 1.4.4
    • no-release
    • sqoop2-api
    • Sqoop v1.4.4.2.1.5.0-695, vertica jdk5-6.1.3-0.jar, hortonworks sandbox 2.0, hive 0.13

    Description

      I am trying to write a simple sqoop import program through JAVA API, but it is throwing runtime error

      It is able to establish the connection

      Below is my program

      String driver="com.vertica.jdbc.Driver";
      Class.forName(driver);

      Configuration config=new Configuration();
      config.addResource(new Path("/.../.../.../core-site.xml"));
      config.addResource(new Path("/.../.../.../hdfs-site.xml"));
      config.addResource(new Path("/.../.../.../mapred-site.xml"));

      FileSystem dfs=FileSystem.get(config);

      SqoopOptions options=new SqoopOptions();
      options.setDriverClassName(driver);
      options.setConnectString(vertica connection string);
      options.setUsername("psha0pnlp");
      options.setPassword("xxxxxxxxxxxxx");
      options.setTargetDir("hdfs://../../123456/part-m-00000");
      options.setSqlQuery("SELECT * FROM db.table WHERE $CONDITIONS limit 10");
      options.setNumMappers(1);
      options.setConf(config);

      ImportTool tool=new ImportTool();

      int i=tool.run(options);

      Complete error log:

      15/02/19 06:45:37 WARN sqoop.ConnFactory: $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
      15/02/19 06:45:37 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.
      15/02/19 06:45:37 INFO manager.SqlManager: Using default fetchSize of 1000
      15/02/19 06:45:37 INFO tool.CodeGenTool: Beginning code generation
      15/02/19 06:45:37 INFO manager.SqlManager: Executing SQL statement: SELECT * FROM silverscreen_qa.SS_INSTRUMENT WHERE (1 = 0) limit 10
      15/02/19 06:45:37 INFO manager.SqlManager: Executing SQL statement: SELECT * FROM silverscreen_qa.SS_INSTRUMENT WHERE (1 = 0) limit 10
      15/02/19 06:45:37 INFO orm.CompilationManager: $HADOOP_MAPRED_HOME is not set
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:11: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.JdbcWritableBridge;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:12: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.DelimiterSet;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:13: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.FieldFormatter;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:14: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.RecordParser;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:15: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.BooleanParser;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:16: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.BlobRef;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:17: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.ClobRef;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:18: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.LargeObjectLoader;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:19: error: package com.cloudera.sqoop.lib does not exist
      import com.cloudera.sqoop.lib.SqoopRecord;
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:37: error: cannot find symbol
      public class QueryResult extends SqoopRecord implements DBWritable, Writable {
      ^
      symbol: class SqoopRecord
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:432: error: cannot find symbol
      public void loadLargeObjects(LargeObjectLoader __loader)
      ^
      symbol: class LargeObjectLoader
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:794: error: cannot find symbol
      private static final DelimiterSet __outputDelimiters = new DelimiterSet((char) 44, (char) 10, (char) 0, (char) 0, false);
      ^
      symbol: class DelimiterSet
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:798: error: cannot find symbol
      public String toString(DelimiterSet delimiters) {
      ^
      symbol: class DelimiterSet
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:804: error: cannot find symbol
      public String toString(DelimiterSet delimiters, boolean useRecordDelim) {
      ^
      symbol: class DelimiterSet
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:869: error: cannot find symbol
      private static final DelimiterSet __inputDelimiters = new DelimiterSet((char) 44, (char) 10, (char) 0, (char) 0, false);
      ^
      symbol: class DelimiterSet
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:870: error: cannot find symbol
      private RecordParser __parser;
      ^
      symbol: class RecordParser
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:871: error: package RecordParser does not exist
      public void parse(Text __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:879: error: package RecordParser does not exist
      public void parse(CharSequence __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:887: error: package RecordParser does not exist
      public void parse(byte [] __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:895: error: package RecordParser does not exist
      public void parse(char [] __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:903: error: package RecordParser does not exist
      public void parse(ByteBuffer __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:911: error: package RecordParser does not exist
      public void parse(CharBuffer __record) throws RecordParser.ParseError {
      ^
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:361: error: bad operand types for binary operator '=='
      if (this == o) {
      ^
      first type: QueryResult
      second type: Object
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:364: error: inconvertible types
      if (!(o instanceof QueryResult)) {
      ^
      required: QueryResult
      found: Object
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:367: error: inconvertible types
      QueryResult that = (QueryResult) o;
      ^
      required: QueryResult
      found: Object
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:402: error: cannot find symbol
      this.business_date = JdbcWritableBridge.readDate(1, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:403: error: cannot find symbol
      this.source_system = JdbcWritableBridge.readString(2, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:404: error: cannot find symbol
      this.business_unit = JdbcWritableBridge.readString(3, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:405: error: cannot find symbol
      this.region = JdbcWritableBridge.readString(4, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:406: error: cannot find symbol
      this.instrument_id = JdbcWritableBridge.readLong(5, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:407: error: cannot find symbol
      this.instrument_type = JdbcWritableBridge.readString(6, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:408: error: cannot find symbol
      this.currency = JdbcWritableBridge.readString(7, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:409: error: cannot find symbol
      this.issuer_id = JdbcWritableBridge.readString(8, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:410: error: cannot find symbol
      this.session_id = JdbcWritableBridge.readString(9, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:411: error: cannot find symbol
      this.instrument_name = JdbcWritableBridge.readString(10, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:412: error: cannot find symbol
      this.discount_curve_name = JdbcWritableBridge.readString(11, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:413: error: cannot find symbol
      this.notional = JdbcWritableBridge.readDouble(12, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:414: error: cannot find symbol
      this.maturity_date = JdbcWritableBridge.readDate(13, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:415: error: cannot find symbol
      this.contract_size = JdbcWritableBridge.readDouble(14, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:416: error: cannot find symbol
      this.strike_price = JdbcWritableBridge.readDouble(15, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:417: error: cannot find symbol
      this.underlying_instrument_id = JdbcWritableBridge.readLong(16, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:418: error: cannot find symbol
      this.assigned_rating = JdbcWritableBridge.readString(17, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:419: error: cannot find symbol
      this.rating_id = JdbcWritableBridge.readString(18, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:420: error: cannot find symbol
      this.cusip = JdbcWritableBridge.readString(19, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:421: error: cannot find symbol
      this.isin = JdbcWritableBridge.readString(20, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:422: error: cannot find symbol
      this.cds_curve_name = JdbcWritableBridge.readString(21, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:423: error: cannot find symbol
      this.refIndexCode = JdbcWritableBridge.readString(22, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:424: error: cannot find symbol
      this.feed_source = JdbcWritableBridge.readString(23, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:425: error: cannot find symbol
      this.currency_pair = JdbcWritableBridge.readString(24, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:426: error: cannot find symbol
      this.product_type_1 = JdbcWritableBridge.readString(25, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:427: error: cannot find symbol
      this.product_type_2 = JdbcWritableBridge.readString(26, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:428: error: cannot find symbol
      this.country_of_risk = JdbcWritableBridge.readString(27, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:429: error: cannot find symbol
      this.sector = JdbcWritableBridge.readString(28, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:430: error: cannot find symbol
      this.rating = JdbcWritableBridge.readString(29, __dbResults);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:440: error: cannot find symbol
      JdbcWritableBridge.writeDate(business_date, 1 + __off, 91, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:441: error: cannot find symbol
      JdbcWritableBridge.writeString(source_system, 2 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:442: error: cannot find symbol
      JdbcWritableBridge.writeString(business_unit, 3 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:443: error: cannot find symbol
      JdbcWritableBridge.writeString(region, 4 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:444: error: cannot find symbol
      JdbcWritableBridge.writeLong(instrument_id, 5 + __off, -5, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:445: error: cannot find symbol
      JdbcWritableBridge.writeString(instrument_type, 6 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:446: error: cannot find symbol
      JdbcWritableBridge.writeString(currency, 7 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:447: error: cannot find symbol
      JdbcWritableBridge.writeString(issuer_id, 8 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:448: error: cannot find symbol
      JdbcWritableBridge.writeString(session_id, 9 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:449: error: cannot find symbol
      JdbcWritableBridge.writeString(instrument_name, 10 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:450: error: cannot find symbol
      JdbcWritableBridge.writeString(discount_curve_name, 11 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:451: error: cannot find symbol
      JdbcWritableBridge.writeDouble(notional, 12 + __off, 8, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:452: error: cannot find symbol
      JdbcWritableBridge.writeDate(maturity_date, 13 + __off, 91, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:453: error: cannot find symbol
      JdbcWritableBridge.writeDouble(contract_size, 14 + __off, 8, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:454: error: cannot find symbol
      JdbcWritableBridge.writeDouble(strike_price, 15 + __off, 8, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:455: error: cannot find symbol
      JdbcWritableBridge.writeLong(underlying_instrument_id, 16 + __off, -5, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:456: error: cannot find symbol
      JdbcWritableBridge.writeString(assigned_rating, 17 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:457: error: cannot find symbol
      JdbcWritableBridge.writeString(rating_id, 18 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:458: error: cannot find symbol
      JdbcWritableBridge.writeString(cusip, 19 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:459: error: cannot find symbol
      JdbcWritableBridge.writeString(isin, 20 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:460: error: cannot find symbol
      JdbcWritableBridge.writeString(cds_curve_name, 21 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:461: error: cannot find symbol
      JdbcWritableBridge.writeString(refIndexCode, 22 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:462: error: cannot find symbol
      JdbcWritableBridge.writeString(feed_source, 23 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:463: error: cannot find symbol
      JdbcWritableBridge.writeString(currency_pair, 24 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:464: error: cannot find symbol
      JdbcWritableBridge.writeString(product_type_1, 25 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:465: error: cannot find symbol
      JdbcWritableBridge.writeString(product_type_2, 26 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:466: error: cannot find symbol
      JdbcWritableBridge.writeString(country_of_risk, 27 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:467: error: cannot find symbol
      JdbcWritableBridge.writeString(sector, 28 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:468: error: cannot find symbol
      JdbcWritableBridge.writeString(rating, 29 + __off, 12, __dbStmt);
      ^
      symbol: variable JdbcWritableBridge
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:794: error: cannot find symbol
      private static final DelimiterSet __outputDelimiters = new DelimiterSet((char) 44, (char) 10, (char) 0, (char) 0, false);
      ^
      symbol: class DelimiterSet
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:807: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(business_date==null?"null":"" + business_date, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:809: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(source_system==null?"null":source_system, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:811: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(business_unit==null?"null":business_unit, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:813: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(region==null?"null":region, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:815: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(instrument_id==null?"null":"" + instrument_id, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:817: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(instrument_type==null?"null":instrument_type, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:819: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(currency==null?"null":currency, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:821: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(issuer_id==null?"null":issuer_id, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:823: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(session_id==null?"null":session_id, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:825: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(instrument_name==null?"null":instrument_name, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:827: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(discount_curve_name==null?"null":discount_curve_name, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:829: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(notional==null?"null":"" + notional, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:831: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(maturity_date==null?"null":"" + maturity_date, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:833: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(contract_size==null?"null":"" + contract_size, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:835: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(strike_price==null?"null":"" + strike_price, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      /tmp/sqoop-tjk0_dev/compile/23bbee0358c55f870b414e729d0217ae/QueryResult.java:837: error: cannot find symbol
      __sb.append(FieldFormatter.escapeAndEnclose(underlying_instrument_id==null?"null":"" + underlying_instrument_id, delimiters));
      ^
      symbol: variable FieldFormatter
      location: class QueryResult
      100 errors
      15/02/19 06:45:38 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Error returned by javac
      at org.apache.sqoop.orm.CompilationManager.compile(CompilationManager.java:217)
      at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:97)
      at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396)
      at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:506)
      at FinalSqoop.main(FinalSqoop.java:52)
      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.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
      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.main(RunJar.java:212)

      Attachments

        Activity

          People

            Unassigned Unassigned
            rahulmsinghvi Rahul Mahendrakumar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 168h
                168h
                Remaining:
                Remaining Estimate - 168h
                168h
                Logged:
                Time Spent - Not Specified
                Not Specified