Windowed Tables should use [delete, compact] for their Sink Topics

[agavra]

Describe the bug

A windowed table such as the one below is not created with the compacted topic cleanup policy.

CREATE TABLE bar 
  AS SELECT count(*) as count, id 
  FROM foo 
  WINDOW SESSION (1 hour) 
  GROUP BY id;

To Reproduce

Create the stream above based on:

CREATE STREAM bar AS SELECT count(*) as count, id FROM foo WINDOW SESSION (1 hour) GROUP BY id;

List the configs of the topic:

(13:11:06) confluent-5.5.1-SNAPSHOT ➤ ./bin/kafka-configs --topic BAR --bootstrap-server localhost:29092 --describe --all
All configs for topic BAR are:
...
{DEFAULT_CONFIG:log.cleanup.policy=delete}
...

Expected behavior

The topic should use cleanup.policy=[compact,delete]

Actual behaviour

The topic uses cleanup.policy=[delete]

Additional context

There are two workarounds:

1. we can create the topic before issuing the create statement
2. we can alter the topic using kafka-configs to change the cleanup policy:

--alter --add-config cleanup.policy=[compact,delete]

It seems like this was called out by @rodesai here: #1042 (comment) but it was not addressed