Hive
  1. Hive
  2. HIVE-7127

Handover more details on exception in hiveserver2

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.14.0
    • Component/s: JDBC
    • Labels:
      None

      Description

      Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.

      org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
      	at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
      	at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
      	at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
      	at org.apache.hive.beeline.Commands.execute(Commands.java:736)
      	at org.apache.hive.beeline.Commands.sql(Commands.java:657)
      	at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
      	at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
      	at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
      	at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
      	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:160)
      

      With this patch, JDBC client can get more details on hiveserver2.

      Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
      	at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
      	at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
      	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
      	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
      	at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
      	at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
      	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
      	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
      	at org.apache.thrift.ProcessFunction.process(Unknown Source)
      	at org.apache.thrift.TBaseProcessor.process(Unknown Source)
      	at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
      	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      
      1. HIVE-7127.5.patch.txt
        18 kB
        Navis
      2. HIVE-7127.4.patch.txt
        18 kB
        Navis
      3. HIVE-7127.2.patch.txt
        8 kB
        Navis
      4. HIVE-7127.1.patch.txt
        11 kB
        Navis

        Issue Links

          Activity

          Navis created issue -
          Navis made changes -
          Field Original Value New Value
          Description Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          NO_PRECOMMIT_TEST

          Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          Navis made changes -
          Attachment HIVE-7127.1.patch.txt [ 12646847 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Remote Link This issue links to "review board (Web Link)" [ 15224 ]
          Navis made changes -
          Attachment HIVE-7127.2.patch.txt [ 12647053 ]
          Szehon Ho made changes -
          Description NO_PRECOMMIT_TEST

          Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          NO PRECOMMIT TESTS

          Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          Navis made changes -
          Attachment HIVE-7127.4.patch.txt [ 12647288 ]
          Navis made changes -
          Attachment HIVE-7127.5.patch.txt [ 12652341 ]
          Navis made changes -
          Description NO PRECOMMIT TESTS

          Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          Currently, JDBC hands over exception message and error codes. But it's not helpful for debugging.
          {noformat}
          org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
          at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
          at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:231)
          at org.apache.hive.beeline.Commands.execute(Commands.java:736)
          at org.apache.hive.beeline.Commands.sql(Commands.java:657)
          at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:889)
          at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:744)
          at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:459)
          at org.apache.hive.beeline.BeeLine.main(BeeLine.java:442)
          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:160)
          {noformat}

          With this patch, JDBC client can get more details on hiveserver2.

          {noformat}
          Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'createa' 'asd' '<EOF>'
          at org.apache.hive.service.cli.operation.SQLOperation.prepare(Unknown Source)
          at org.apache.hive.service.cli.operation.SQLOperation.run(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(Unknown Source)
          at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.CLIService.executeStatementAsync(Unknown Source)
          at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(Unknown Source)
          at org.apache.thrift.ProcessFunction.process(Unknown Source)
          at org.apache.thrift.TBaseProcessor.process(Unknown Source)
          at org.apache.hive.service.auth.TSetIpAddressProcessor.process(Unknown Source)
          at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          {noformat}
          Navis made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Fix Version/s 0.14.0 [ 12326450 ]
          Resolution Fixed [ 1 ]
          Navis made changes -
          Link This issue is duplicated by HIVE-7379 [ HIVE-7379 ]
          Thejas M Nair made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Navis
              Reporter:
              Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development