I have a matrix table of variants (behaving fine) and I have imported a table of VQSR scores. I cannot get around what must be a stupid problem: the table (row_qc) is keyed by a string (which looks like a locus). The matrix table (mt_split_annotated) has rows keyed by [locus, alleles]. When I attempt a simple join to bolt on the vqsr scores like so:
mt_split_annotated = mt_split_annotated.annotate_rows(vqsr = row_qc[mt_split_annotated.locus])
I get this error:
ExpressionException: Key type mismatch: cannot index table with given expressions:
Table key: str
Index Expressions: locus
I can see there’s a clear type-mismatch, but my attempts to cast the string to a locus or convert the locus to a string are not working so far
Any help appreciated!