dj121121121 Posted April 3, 2019 Share Posted April 3, 2019 2019-04-02 18:38:54,985 WARN [HiveServer2-Handler-Pool: Thread-42]: thrift.ThriftCLIService (ThriftCLIService.java:ExecuteStatement(508)) - Error executing statement: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: JSONParseException {"uid":"_id","attributes_operation":"attributes.operation","attributes_pdf":"attributes.pdf","attributes_pdf_approve":"attributes.pdf-approve","attributes_pdf_draft":"attributes.pdf-draft","creator":"creator","dateCreated":"dateCreated","dateModified":"dateModified","extra":"extra","grants":"grants","id":"id","instanceId":"instanceId","javaClass":"javaClass","modifier":"modifier","order":"order","owners":"owners","parent":"parent","parentId":"parentId","properties_LegalAgent":"properties.LegalAgent","properties_TakeRollDate":"properties.TakeRollDate","properties_TakeRollName":"properties.TakeRollName","properties_acceptDate":"properties.acceptDate","properties_acceptNote":"properties.acceptNote","properties_accepter":"properties.accepter","properties_acreage":"properties.acreage","properties_agent":"properties.agent","properties_agentAttestation":"properties.agentAttestation","properties_agentName":"properties.agentName","properties_annex":"properties.annex","properties_appellation":"properties.appellation","properties_appellation1_mb":"properties.appellation1_mb","properties_appellation2_mb":"properties.appellation2_mb","properties_appellation3_mb":"properties.appellation3_mb","properties_appellation_mb":"properties.appellation_mb","properties_applicantName":"properties.applicantName","properties_applyAmount":"properties.applyAmount","properties_applyBorrowDate":"properties.applyBorrowDate","properties_applyBorrowName":"properties.applyBorrowName","properties_approval":"properties.approval","properties_approveDate":"properties.approveDate","properties_approveLevel":"properties.approveLevel","properties_approveNote":"properties.approveNote","properties_approveResult":"properties.approveResult","properties_approver":"properties.approver","properties_approverName":"properties.approverName","properties_assistant_0":"properties.assistant.0","properties_attestation":"properties.attestation","properties_avgChargeTime":"properties.avgChargeTime","properties_avgMakeTime":"properties.avgMakeTime","properties_barCode":"properties.barCode","properties_batchNo":"properties.batchNo","properties_bid":"properties.bid","properties_bindDepartment":"properties.bindDepartment","properties_bindOperator":"properties.bindOperator","properties_bindeDate":"properties.bindeDate","properties_binder":"properties.binder","properties_birthplace":"properties.birthplace","properties_borrowApproveDate":"properties.borrowApproveDate","properties_borrowApproveName":"properties.borrowApproveName","properties_borrowApproveStatus":"properties.borrowApproveStatus","properties_borrowRemark":"properties.borrowRemark","properties_borrowSignDate":"properties.borrowSignDate","properties_borrowSignName":"properties.borrowSignName","properties_borrowStatus":"properties.borrowStatus","properties_borrowStatusName":"properties.borrowStatusName","properties_cancelRegisterDate":"properties.cancelRegisterDate","properties_cancelRegisterName":"properties.cancelRegisterName","properties_cancelRollDate":"properties.cancelRollDate","properties_cancelRollName":"properties.cancelRollName","properties_cancelSignName":"properties.cancelSignName","properties_caseNumber":"properties.caseNumber","properties_caseType":"properties.caseType","properties_catalogNo":"properties.catalogNo","properties_cause":"properties.cause","properties_certainlyType":"properties.certainlyType","properties_certificateDate":"properties.certificateDate","properties_certificateName":"properties.certificateName","properties_chargeAmount":"properties.chargeAmount","properties_chargeStatus":"properties.chargeStatus","properties_checkApproveDate":"properties.checkApproveDate","properties_checkApproveNote":"properties.checkApproveNote","properties_checkApprover":"properties.checkApprover","properties_checkCode":"properties.checkCode","properties_checkDate":"properties.checkDate","properties_checkNote":"properties.checkNote","properties_checker":"properties.checker","properties_closeDate_mb":"properties.closeDate_mb" ^ at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:400) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:187) at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:271) at org.apache.hive.service.cli.operation.Operation.run(Operation.java:337) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:439) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:416) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) 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:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1920) at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) at com.sun.proxy.$Proxy22.executeStatementAsync(Unknown Source) at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:282) at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:501) 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:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: com.mongodb.util.JSONParseException: {"uid":"_id","attributes_operation":"attributes.operation","attributes_pdf":"attributes.pdf","attributes_pdf_approve":"attributes.pdf-approve","attributes_pdf_draft":"attributes.pdf-draft","creator":"creator","dateCreated":"dateCreated","dateModified":"dateModified","extra":"extra","grants":"grants","id":"id","instanceId":"instanceId","javaClass":"javaClass","modifier":"modifier","order":"order","owners":"owners","parent":"parent","parentId":"parentId","properties_LegalAgent":"properties.LegalAgent","properties_TakeRollDate":"properties.TakeRollDate","properties_TakeRollName":"properties.TakeRollName","properties_acceptDate":"properties.acceptDate","properties_acceptNote":"properties.acceptNote","properties_accepter":"properties.accepter","properties_acreage":"properties.acreage","properties_agent":"properties.agent","properties_agentAttestation":"properties.agentAttestation","properties_agentName":"properties.agentName","properties_annex":"properties.annex","properties_appellation":"properties.appellation","properties_appellation1_mb":"properties.appellation1_mb","properties_appellation2_mb":"properties.appellation2_mb","properties_appellation3_mb":"properties.appellation3_mb","properties_appellation_mb":"properties.appellation_mb","properties_applicantName":"properties.applicantName","properties_applyAmount":"properties.applyAmount","properties_applyBorrowDate":"properties.applyBorrowDate","properties_applyBorrowName":"properties.applyBorrowName","properties_approval":"properties.approval","properties_approveDate":"properties.approveDate","properties_approveLevel":"properties.approveLevel","properties_approveNote":"properties.approveNote","properties_approveResult":"properties.approveResult","properties_approver":"properties.approver","properties_approverName":"properties.approverName","properties_assistant_0":"properties.assistant.0","properties_attestation":"properties.attestation","properties_avgChargeTime":"properties.avgChargeTime","properties_avgMakeTime":"properties.avgMakeTime","properties_barCode":"properties.barCode","properties_batchNo":"properties.batchNo","properties_bid":"properties.bid","properties_bindDepartment":"properties.bindDepartment","properties_bindOperator":"properties.bindOperator","properties_bindeDate":"properties.bindeDate","properties_binder":"properties.binder","properties_birthplace":"properties.birthplace","properties_borrowApproveDate":"properties.borrowApproveDate","properties_borrowApproveName":"properties.borrowApproveName","properties_borrowApproveStatus":"properties.borrowApproveStatus","properties_borrowRemark":"properties.borrowRemark","properties_borrowSignDate":"properties.borrowSignDate","properties_borrowSignName":"properties.borrowSignName","properties_borrowStatus":"properties.borrowStatus","properties_borrowStatusName":"properties.borrowStatusName","properties_cancelRegisterDate":"properties.cancelRegisterDate","properties_cancelRegisterName":"properties.cancelRegisterName","properties_cancelRollDate":"properties.cancelRollDate","properties_cancelRollName":"properties.cancelRollName","properties_cancelSignName":"properties.cancelSignName","properties_caseNumber":"properties.caseNumber","properties_caseType":"properties.caseType","properties_catalogNo":"properties.catalogNo","properties_cause":"properties.cause","properties_certainlyType":"properties.certainlyType","properties_certificateDate":"properties.certificateDate","properties_certificateName":"properties.certificateName","properties_chargeAmount":"properties.chargeAmount","properties_chargeStatus":"properties.chargeStatus","properties_checkApproveDate":"properties.checkApproveDate","properties_checkApproveNote":"properties.checkApproveNote","properties_checkApprover":"properties.checkApprover","properties_checkCode":"properties.checkCode","properties_checkDate":"properties.checkDate","properties_checkNote":"properties.checkNote","properties_checker":"properties.checker","properties_closeDate_mb":"properties.closeDate_mb" ^ at com.mongodb.util.JSONParser.read(JSON.java:302) at com.mongodb.util.JSONParser.parseObject(JSON.java:273) at com.mongodb.util.JSONParser.parse(JSON.java:228) at com.mongodb.util.JSONParser.parse(JSON.java:156) at com.mongodb.util.JSON.parse(JSON.java:98) at com.mongodb.util.JSON.parse(JSON.java:79) at com.mongodb.hadoop.hive.BSONSerDe.initialize(BSONSerDe.java:110) at org.apache.hadoop.hive.serde2.SerDeUtils.initializeSerDe(SerDeUtils.java:526) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:393) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:273) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:255) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genTablePlan(SemanticAnalyzer.java:9433) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9758) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9739) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10212) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:287) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10223) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:193) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:223) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:558) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1356) at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1343) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:185) ... 27 more Thank you very much for helping me solve this problem! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now