Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Full Outer Join Error #3369

Closed
nbauernfeind opened this issue Jan 27, 2023 · 0 comments · Fixed by #3386
Closed

Full Outer Join Error #3369

nbauernfeind opened this issue Jan 27, 2023 · 0 comments · Fixed by #3386
Assignees
Labels
bug Something isn't working query engine
Milestone

Comments

@nbauernfeind
Copy link
Member

Description

Full outer join has a merge error due to an intermediate table having the wrong table definition.

Steps to reproduce

import io.deephaven.engine.util.TableTools
import io.deephaven.engine.util.OuterJoinTools
t1 = TableTools.timeTable("00:00:00.001").update("a = i", "b = i * 2")
t2 = TableTools.timeTable("00:00:00.001").update("a = i", "c = i * 2")
t3 = OuterJoinTools.fullOuterJoin(t1, t2, "a", "c");

Expected results

t3 should be a table that joins t1 and t2 sharing column A, and adds column C

Actual results

Internal Error 'c293970c-5f24-4451-9b26-757ec0d78c8a' io.deephaven.engine.table.TableDefinition$IncompatibleTableDefinitionException: Table definition incompatibilities: 
	expected column 'a' is missing in constituent
        at io.deephaven.engine.table.TableDefinition.checkMutualCompatibility(TableDefinition.java:333)
        at io.deephaven.engine.table.impl.partitioned.PartitionedTableImpl.validateConstituents(PartitionedTableImpl.java:549)
        at io.deephaven.engine.table.impl.partitioned.PartitionedTableImpl$ValidateConstituents.initialize(PartitionedTableImpl.java:513)
        at io.deephaven.engine.table.impl.QueryTable.lambda$getResultNoMemo$70(QueryTable.java:3169)
        at io.deephaven.engine.table.impl.remote.ConstructSnapshot.callDataSnapshotFunction(ConstructSnapshot.java:1193)
        at io.deephaven.engine.table.impl.remote.ConstructSnapshot.callDataSnapshotFunction(ConstructSnapshot.java:1035)
        at io.deephaven.engine.table.impl.BaseTable.initializeWithSnapshot(BaseTable.java:1181)
        at io.deephaven.engine.table.impl.QueryTable.lambda$getResultNoMemo$71(QueryTable.java:3168)
        at io.deephaven.engine.table.impl.perf.QueryPerformanceRecorder.withNugget(QueryPerformanceRecorder.java:518)
        at io.deephaven.engine.table.impl.QueryTable.getResultNoMemo(QueryTable.java:3157)
        at io.deephaven.engine.table.impl.QueryTable.lambda$getResult$69(QueryTable.java:3151)
        at io.deephaven.engine.table.impl.QueryTable$MemoizedResult.getOrCompute(QueryTable.java:3111)
        at io.deephaven.engine.table.impl.QueryTable.memoizeResult(QueryTable.java:3080)
        at io.deephaven.engine.table.impl.QueryTable.getResult(QueryTable.java:3150)
        at io.deephaven.engine.table.impl.partitioned.PartitionedTableImpl.<init>(PartitionedTableImpl.java:79)
        at io.deephaven.engine.table.impl.partitioned.PartitionedTableCreatorImpl.constituentsToPartitionedTable(PartitionedTableCreatorImpl.java:188)
        at io.deephaven.engine.table.impl.partitioned.PartitionedTableCreatorImpl.ofTables(PartitionedTableCreatorImpl.java:154)
        at io.deephaven.engine.table.PartitionedTableFactory.ofTables(PartitionedTableFactory.java:179)
        at io.deephaven.engine.util.TableTools.lambda$merge$2(TableTools.java:1005)
        at io.deephaven.engine.table.impl.perf.QueryPerformanceRecorder.withNugget(QueryPerformanceRecorder.java:445)
        at io.deephaven.engine.util.TableTools.merge(TableTools.java:990)
        at io.deephaven.engine.util.OuterJoinTools.fullOuterJoin(OuterJoinTools.java:121)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working query engine
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant