org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:36 cannot recognize input near 'INTEGER' ',' 'CLFCUST' in column type

Stack Overflow | Anthony | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Error when using JDBC to write a Dataframe to an existing Hive table

    Stack Overflow | 7 months ago | Anthony
    org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:36 cannot recognize input near 'INTEGER' ',' 'CLFCUST' in column type
  2. 0

    Hive hplsql stored procedure cannot insert timestamp values

    Stack Overflow | 2 months ago | David Wang
    org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 2:27 mismatched input '-' expecting ) near '2016' in value row constructor

  1. jf-ast 24 times, last 2 weeks ago
1 unregistered visitors

Root Cause Analysis

  1. java.lang.RuntimeException

    org.apache.hadoop.hive.ql.parse.ParseException:line 1:36 cannot recognize input near 'INTEGER' ',' 'CLFCUST' in column type

    at org.apache.hadoop.hive.ql.parse.ParseDriver.parse()
  2. Hive Query Language
    Driver.compileAndRespond
    1. org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:205)
    2. org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
    3. org.apache.hadoop.hive.ql.Driver.compile(Driver.java:396)
    4. org.apache.hadoop.hive.ql.Driver.compile(Driver.java:308)
    5. org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1122)
    6. org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1116)
    6 frames
  3. org.apache.hive
    HiveSessionImpl.executeStatementAsync
    1. org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
    2. org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
    3. org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
    4. org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:388)
    5. org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:375)
    5 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:483)
    4 frames
  5. org.apache.hive
    HiveSessionProxy$1.run
    1. org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
    2. org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
    3. org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
    3 frames
  6. Java RT
    Subject.doAs
    1. java.security.AccessController.doPrivileged(Native Method)
    2. javax.security.auth.Subject.doAs(Subject.java:422)
    2 frames
  7. Hadoop
    UserGroupInformation.doAs
    1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
    1 frame
  8. org.apache.hive
    HiveSessionProxy.invoke
    1. org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
    1 frame
  9. com.sun.proxy
    $Proxy20.executeStatementAsync
    1. com.sun.proxy.$Proxy20.executeStatementAsync(Unknown Source)
    1 frame
  10. org.apache.hive
    TCLIService$Processor$ExecuteStatement.getResult
    1. org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
    2. org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
    3. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
    4. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
    4 frames
  11. Apache Thrift
    TBaseProcessor.process
    1. org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    2. org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    2 frames
  12. org.apache.hive
    TSetIpAddressProcessor.process
    1. org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
    1 frame
  13. Apache Thrift
    TThreadPoolServer$WorkerProcess.run
    1. org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
    1 frame
  14. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:744)
    3 frames