Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2776

Integration build broken: hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators

    XMLWordPrintableJSON

Details

    Description

      The integration build which uses the latest hive fails in data loading with

      No rows affected (0.003 seconds)
      0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_hbase ^M.escapechartesttable SELECT * FROM functional.escapechartesttable;
      Getting log thread is interrupted, since query is done!
      Error: Error while compiling statement: FAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators) (state=42000,code=40000)
      org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators)
              at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:235)
              at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:221)
              at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:244)
              at org.apache.hive.beeline.Commands.execute(Commands.java:814)
              at org.apache.hive.beeline.Commands.sql(Commands.java:670)
              at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:974)
              at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:810)
              at org.apache.hive.beeline.BeeLine.executeFile(BeeLine.java:790)
              at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:759)
              at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:480)
              at org.apache.hive.beeline.BeeLine.main(BeeLine.java:463)
              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.run(RunJar.java:221)
              at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
      Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators)
              at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:371)
              at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:120)
              at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:189)
              at org.apache.hive.service.cli.operation.Operation.run(Operation.java:313)
              at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:423)
              at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:399)
              at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
              at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
              at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
              at java.security.AccessController.doPrivileged(Native Method)
              at javax.security.auth.Subject.doAs(Subject.java:415)
              at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)
              at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
              at com.sun.proxy.$Proxy17.executeStatementAsync(Unknown Source)
              at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:258)
              at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:506)
              at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
              at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
              at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
              at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
              at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
              at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators)
              at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:275)
              at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:255)
              at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genTablePlan(SemanticAnalyzer.java:9476)
              at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9796)
              at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9777)
              at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10250)
              at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:287)
              at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10261)
              at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:193)
              at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:222)
              at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:425)
              at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:306)
              at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1148)
              at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1142)
              at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:118)
              ... 26 more
      Caused by: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException \r and \n cannot be used as escaping characters or separators)
              at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:389)
              at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:273)
              ... 40 more
      

      Attachments

        Activity

          People

            alex.behm Alexander Behm
            caseyc casey
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: