Error Messages Relating to Joins
| Code | 161500 |
| Severity | Error |
| Message | Join {0} needs an insert-only source. |
| Description | No additional information available. |
| Code | 161501 |
| Severity | Error |
| Message | Join {0} should either be insert-only or a source stream. |
| Description | No additional information available. |
| Code | 161502 |
| Severity | Error |
| Message | {0} {1} is a source Stream to a Join Stream but is assigned to a Stateless Store. Streams belonging to a Stateless Store cannot be a source to a Join Stream. |
| Description | No additional information available. |
| Code | 161503 |
| Severity | Error |
| Message | ERROR: Stream |
| Description | No additional information available. |
| Code | 161504 |
| Severity | Error |
| Message | A Many-To-Many relationship detected in join for stream {0}. |
| Description | This feature is not supported. |
| Code | 161505 |
| Severity | Error |
| Message | in Stream |
| Description | No additional information available. |
| Code | 161506 |
| Severity | Error |
| Message | An error occured while compiling the join statement for Stream {0}. |
| Description | No additional information available. |
| Code | 161507 |
| Severity | Error |
| Message | Columns selected in join {0} do not form a valid key. |
| Description | A Join window requires that the required columns that form a key for a join be directly copied from its sources. Valid key columns for a join safeguards against rows rejected due to null key fields, duplicate inserts or bad updates and deletes. |
| Code | 161508 |
| Severity | Error |
| Message | Declare blocks of Joins ({0}) cannot use {1} on sources. |
| Description | Eventcaches,Iterators and Typeof currently not supported in Join declare block. |
| Code | 161509 |
| Severity | Alert |
| Message | Incorrect key columns specified for {0}. Needs to be a superset of {1}. |
| Description | User specified keys for joins need to match the constraints of the ON clause and Join type. |
| Code | 161510 |
| Severity | Warning |
| Message | Warning: More than one set of keys deducible for join {0}. Potential keys are {1}. |
| Description | More than one potential key column(s) have been selected in the projected list. Remove the conflicting columns from projection list or specify the key columns explicitly. |
| Code | 161511 |
| Severity | Error |
| Message | ON Clause of Join {0} contains an equality between fields of the KEY of the same side of a join. This is not supported. |
| Description | ON Clause construct cannot specify equalities between fields of the KEY of any side of a join. |
| Code | 161512 |
| Severity | Error |
| Message | Alias {0} refers to a STREAM but is an inner member of an outer join with {1}. This is not allowed. |
| Description | A STREAM can only be an outer member of a outer join i.e. it must be on the right side of RiGHT JOIN and on the left for a LEFT JOIN. |
| Code | 161513 |
| Severity | Error |
| Message | Alias {0} refers to a STREAM and participates in a FULL OUTER join. This is not allowed. |
| Description | A STREAM cannot participate in a FULL OUTER join. It can only participate in a INNER, LEFT or RIGHT join. |
| Code | 161514 |
| Severity | Error |
| Message | Stream(s) {0} participates in a OUTER join with {1} but is the one side of a ONE-MANY cardinality. This is not allowed. |
| Description | No additional information available. |
| Code | 161515 |
| Severity | Error |
| Message | Stream(s) {0} participates in a FULL OUTER join with Stream(s) {1} but not all the keys are mapped to each other. This is not allowed. |
| Description | A FULL OUTER join can only be performed if all the keys on both sides of the joins are mapped to each other and the number of keys on both sides are the same. |
| Code | 161516 |
| Severity | Error |
| Message | The target of a join is a Delta Stream. This is not allowed. |
| Description | The target of a join can only be a Stream or a Window. |
| Code | 161517 |
| Severity | Error |
| Message | The alias {0} is used in a join condition before it has been joined. |
| Description | No additional information available. |
| Code | 161518 |
| Severity | Error |
| Message | Cannot have a 'where' in the for statement when the container is of type vector or dictionary. |
| Description | No additional information available. |
| Code | 161519 |
| Severity | Error |
| Message | The iterator {0} cannot be defined in a local/global declare block. |
| Description | No additional information available. |
| Code | 161520 |
| Severity | Error |
| Message | A vector cannot contain a stream/iterator. |
| Description | No additional information available. |
| Code | 161521 |
| Severity | Error |
| Message | A dictionary cannot contain a stream/iterator as its key or value type. |
| Description | No additional information available. |
| Code | 161522 |
| Severity | Error |
| Message | An internal error has occurred. StreamType '{0}' bad arguments to setRefTypes(). |
| Description | No additional information available. |
| Code | 161523 |
| Severity | Error |
| Message | An internal error has occurred. StreamType '{0}' reftype '{1}' is not found |
| Description | No additional information available. |
| Code | 161524 |
| Severity | Alert |
| Message | Columns from Nullable stream '{0}' cannot be set as Primary Key. |
| Description | No additional information available. |