when use HIVE Mapping mongodb External Table is ok,but Error reporting when querying

[Manoj Chaurasia]

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)