Creating stream and associated stream with new topic, appears to be attempting to associate with another topic

[andrew-sledge]

Existing topic, with data is mysite. All data if flowing through with two associated streams:

ksql> SHOW STREAMS;

 Stream Name        | Kafka Topic  | Format 
--------------------------------------------
 BIRF_BROWSER_SESSID | mysite | JSON   
 RUM_TTL_SESSID      | mysite | JSON 
ksql> CREATE STREAM ttl_browser_request WITH (kafka_topic='browser_requests', value_format='JSON') AS SELECT r.rum_ttl AS ttl, b.brand_name AS browser, r.sessid AS sessid, b.camg_reqid AS requestid FROM rum_ttl_sessid r LEFT JOIN birf_browser_sessid b ON r.requestid=b.camg_reqid;
Invalid topology building: Topic mysite has already been registered by another source.
ksql> LIST TOPICS;

 Kafka Topic        | Registered | Partitions | Partition Replicas 
-------------------------------------------------------------------
 _confluent-metrics | false      | 12         | 1                  
 _schemas           | false      | 1          | 1                  
 browser_requests   | true       | 2          | 1                  
 mysite             | true       | 1          | 1                  
 ksql__commands     | true       | 1          | 1                  
 pageviews          | false      | 1          | 1                  
 users              | false      | 1          | 1                  
ksql> 

Am I reading this correctly? How can I associate ttl_browser_request with browser_requests.

EDIT: Formatting

[hjafarpour]

@andrew-sledge currently we only have Stream/Table join support in KSQL. You are joining twi streams and it also seems that you are doing self join! Stream-Stream join will come soon.

[andrew-sledge]

Thanks Hojjat! Looking forward to it.

[miguno]

See #731 for adding stream-stream joins.

[hinguabhishek]

can i do table-table join?

[apurvam]

See #760 .