java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '

sqoop-user | Foster, Craig | 10 months ago
  1. 0

    Re: Order by in query

    sqoop-user | 10 months ago | Foster, Craig
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '
  2. 0

    Order by in query

    sqoop-user | 10 months ago | Foster, Craig
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '
  3. 0

    Order by in query

    sqoop-user | 10 months ago | Foster, Craig
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Order by in query

    sqoop-user | 10 months ago | Foster, Craig
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '
  6. 0

    Order by in query

    sqoop-user | 10 months ago | Foster, Craig
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.mariadb.jdbc.internal.common.QueryException

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) '

      at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult()
    2. mariadb-java-client
      MySQLPreparedStatement.executeQuery
      1. org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:984)
      2. org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1038)
      3. org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1020)
      4. org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:271)
      5. org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:333)
      6. org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:104)
      6 frames
    3. org.apache.sqoop
      Sqoop.run
      1. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:758)
      2. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:767)
      3. org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:270)
      4. org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:241)
      5. org.apache.sqoop.manager.SqlManager.getColumnTypesForQuery(SqlManager.java:234)
      6. org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:304)
      7. org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833)
      8. org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645)
      9. org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
      10. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
      11. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
      12. org.apache.sqoop.Sqoop.run(Sqoop.java:143)
      12 frames
    4. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      1 frame
    5. org.apache.sqoop
      Sqoop.main
      1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
      2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
      3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
      4. org.apache.sqoop.Sqoop.main(Sqoop.java:236)
      4 frames