drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "陈。" <lro...@qq.com>
Subject 转发:N4}[48H$DHWIOXNQQB%~$GD
Date Thu, 17 Jan 2019 02:56:37 GMT
------------------ 原始邮件 ------------------
发件人: "陈。"<lroy_z@qq.com>;
发送时间: 2019年1月17日(星期四) 上午10:52
收件人: "user-subscribe"<user-subscribe@drill.apache.org>;

主题: N4}[48H$DHWIOXNQQB%~$GD



I don't know if it's due to an empty result
query sql
select `6a993905-f23e-4f1a-967a-0d7504e64740`.`委托任务名称` as `委托任务名称`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`委托任务编号`
as `委托任务编号`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`委托分类` as `委托分类`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`预估金额(万元)`
as `预估金额(万元)`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`预估工作量` as `预估工作量`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`甲方`
as `甲方`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`甲方联系人` as `甲方联系人`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`联系电话`
as `联系电话`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`主责部门` as `主责部门`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`委托日期`
as `委托日期`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`约定完工日期` as `约定完工日期`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`状态`
as `状态`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`附件` as `附件`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`备注`
as `备注`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`登记人` as `登记人`,`6a993905-f23e-4f1a-967a-0d7504e64740`.`登记时间`
as `登记时间`,`30cf7541-fbed-4a42-acea-86e46822b31a`.`合同编号` as `合同编号`,`30cf7541-fbed-4a42-acea-86e46822b31a`.`合同名称`
as `合同名称`,`30cf7541-fbed-4a42-acea-86e46822b31a`.`项目类型(小类)` as `项目类型(小类)`,`30cf7541-fbed-4a42-acea-86e46822b31a`.`项目类型(大类)`
as `项目类型(大类)`,`30cf7541-fbed-4a42-acea-86e46822b31a`.`合同额(万元)` as `合同额(万元)`,`5eb9d0e4-0f63-44cf-b1d2-29228a423db3`.`name`
as `name`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`ID` as `ID`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`已采`
as `已采`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`已发` as `已发`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`电商平台`
as `电商平台`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`平台` as `平台`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`标题`
as `标题`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`评论` as `评论`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`时间`
as `时间`,`fbd15f17-9fb3-4283-a6b5-89c47014a627`.`PAGEURL` as `PAGEURL`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`省名称`
as `省名称`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`省简称` as `省简称`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`所属国家`
as `所属国家`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`省编号` as `省编号`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`描述`
as `描述`,`b63343f4-a65c-47f2-8e70-ae48c85d181d`.`外键` as `外键` from (select `附件`,`甲方联系人`,`约定完工日期`,`状态`,`登记时间`,`登记人`,`委托分类`,`甲方`,`备注`,`委托日期`,`预估工作量`,`联系电话`,`预估金额(万元)`,`主责部门`,`委托任务编号`,`委托任务名称`
from mongo.`lzdataplatformbusiness`.`dP_OperationControlCooperation` where leadingDPWorkTableId='351501113310052353')
`6a993905-f23e-4f1a-967a-0d7504e64740` left join(select `项目类型(大类)`,`合同额(万元)`,`项目类型(小类)`,`合同编号`,`合同名称`
from mongo.`lzdataplatformbusiness`.`dP_Mysql` where leadingDPWorkTableId='351501113343606784')
`30cf7541-fbed-4a42-acea-86e46822b31a`  on cast( `6a993905-f23e-4f1a-967a-0d7504e64740`.`委托任务名称`
as varchar)=cast( `30cf7541-fbed-4a42-acea-86e46822b31a`.`合同编号` as varchar) left join(select
`name` from mongo.`lzdataplatformbusiness`.`dP_Sqlserver` where leadingDPWorkTableId='351501113364578304')
`5eb9d0e4-0f63-44cf-b1d2-29228a423db3`  on cast( `30cf7541-fbed-4a42-acea-86e46822b31a`.`合同编号`
as varchar)=cast( `5eb9d0e4-0f63-44cf-b1d2-29228a423db3`.`name` as varchar) left join(select
`时间`,`已发`,`平台`,`PAGEURL`,`评论`,`ID`,`标题`,`电商平台`,`已采` from mongo.`lzdataplatformbusiness`.`dP_Oracle`
where leadingDPWorkTableId='351501113389744128') `fbd15f17-9fb3-4283-a6b5-89c47014a627`  on
cast( `5eb9d0e4-0f63-44cf-b1d2-29228a423db3`.`name` as varchar)=cast( `fbd15f17-9fb3-4283-a6b5-89c47014a627`.`ID`
as varchar) left join(select `外键`,`所属国家`,`省编号`,`省名称`,`描述`,`省简称`
from mongo.`lzdataplatformbusiness`.`dP_Excel` where leadingDPWorkTableId='351501113284886529')
`b63343f4-a65c-47f2-8e70-ae48c85d181d`  on cast( `fbd15f17-9fb3-4283-a6b5-89c47014a627`.`ID`
as varchar)=cast( `b63343f4-a65c-47f2-8e70-ae48c85d181d`.`省名称` as varchar)


Exception
java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Failure while reading
vector.  Expected vector class of org.apache.drill.exec.vector.NullableVarCharVector but was
holding vector class org.apache.drill.exec.vector.complex.UnionVector, field= [`name` (UNION:OPTIONAL),
subtypes=([VARCHAR, INT]), children=([`internal` (MAP:REQUIRED), children=([`types` (UINT1:REQUIRED)])])]

	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator$PartitionerTask.run(PartitionerDecorator.java:347)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at com.google.common.util.concurrent.MoreExecutors$DirectExecutorService.execute(MoreExecutors.java:299)
~[guava-18.0.jar:na]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator.createAndExecute(PartitionerDecorator.java:172)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator.lambda$executeMethodLogic$0(PartitionerDecorator.java:152)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at java.util.ArrayList.forEach(ArrayList.java:1257) ~[na:1.8.0_181]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator.executeMethodLogic(PartitionerDecorator.java:152)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator.flushOutgoingBatches(PartitionerDecorator.java:91)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionSenderRootExec.innerNext(PartitionSenderRootExec.java:191)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:93) [drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:294)
[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:281)
[drill-java-exec-1.14.0.jar:1.14.0]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_181]
	at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0_181]
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) [hadoop-common-2.7.1.jar:na]
	at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:281) [drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) [drill-common-1.14.0.jar:1.14.0]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
Caused by: java.lang.IllegalStateException: Failure while reading vector.  Expected vector
class of org.apache.drill.exec.vector.NullableVarCharVector but was holding vector class org.apache.drill.exec.vector.complex.UnionVector,
field= [`name` (UNION:OPTIONAL), subtypes=([VARCHAR, INT]), children=([`internal` (MAP:REQUIRED),
children=([`types` (UINT1:REQUIRED)])])] 
	at org.apache.drill.exec.record.VectorContainer.getValueAccessorById(VectorContainer.java:324)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.record.RecordBatchLoader.getValueAccessorById(RecordBatchLoader.java:251)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.unorderedreceiver.UnorderedReceiverBatch.getValueAccessorById(UnorderedReceiverBatch.java:139)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.test.generated.PartitionerGen8454$OutgoingRecordBatch.doSetup(PartitionerTemplate.java:563)
~[na:na]
	at org.apache.drill.exec.test.generated.PartitionerGen8454$OutgoingRecordBatch.initializeBatch(PartitionerTemplate.java:387)
~[na:na]
	at org.apache.drill.exec.test.generated.PartitionerGen8454.flushOutgoingBatches(PartitionerTemplate.java:173)
~[na:na]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator$FlushBatchesHandlingClass.execute(PartitionerDecorator.java:285)
~[drill-java-exec-1.14.0.jar:1.14.0]
	at org.apache.drill.exec.physical.impl.partitionsender.PartitionerDecorator$PartitionerTask.run(PartitionerDecorator.java:340)
~[drill-java-exec-1.14.0.jar:1.14.0]
	... 18 common frames omitted
Mime
  • Unnamed multipart/mixed (inline, 8-Bit, 0 bytes)
View raw message